更多"in your database ins"的相关试题:
[单项选择] You want an ASM instance to manage the files of your database. To achieve this objective, you specify the following parameters in the parameter file of the database: INSTANCE_TYPE = RDBMS DB_NAME = PROD LARGE_POOL_SIZE = 8MB DB_BLOCK_SIZE = 4K LOG_ARCHIVE_DEST = +dgroupA LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t" DB_CREATE_FILE_DEST = +dgroupA COMPATIBLE = 10.1.0.2.0 CONTROL_FILES = +dgroupA Which parameter would be ignored while starting up the instance for the database PROD?()
A. DB_BLOCK_SIZE
B. CONTROL_FILES
C. LARGE_POOL_SIZE
D. LOG_ARCHIVE_DEST
E. LOG_ARCHIVE_FORMAT
F. DB_CREATE_FILE_DEST
[单项选择] our database instance is started using the server parameter file (SPFILE). You executed a command tochange the value of the LOG_BUFFER initialization parameter:ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH; What would be the outcome of this command()
A. The command succeeds only if Automatic Memory Management is not enabled.
B. The command succeeds, but you need to restart the database for changes to take effect.
C. The command returns an error because the size of the redo log buffer cannot be changed dynamically.
D. The parameter value is changed and it comes into effect as soon as space becomes available in theSystem Global Area (SGA)
[单项选择] Your database instance is configured with automatic undo management and the UNDO_RETENTIONparameter is set to 900 seconds. You executed the following command to enable retention guarantee: SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE; What effect would this command have onthe database()
A. The extents in the undo tablespace retain data until the next full database backup.
B. The extents containing committed undo in the undo tablespace are not overwritten for at least 15 minutes.
C. The extents containing committed data in the undo tablespace are not overwritten until the instance is shutdown.
D. The extents containing committed undo in the undo tablespace are transferred to Flash Recovery Areabefore being overwritten
[单项选择] Your database instance is currently configured to support 1,500 connections. The Web applicationthat uses the database allows a large number of users to work with the database simultaneously. Someusers of the Web application do not interact with the server all the time. You want to increase the scalability by configuring the database instance to handle more connections. Asa DBA, which configuration would you set to support more than 1,500 connections at a time()
A. You would configure more listeners for the database.
B. You would configure the database in shared server mode to use the connection pooling feature.
C. You would increase the value of the PGA_AGGREGATE_TARGET initialization parameter that assigns more session memory to users.
D. You would decrease the value of the PRIVATE_SGA resource limit in the profiles used by the users to accommodate more session information.
[多项选择] Your database instance is functional for the past one month. The Automatic Workload Repository(AWR) snapshot retention is set to 7 and the STATISTICS_LEVEL initialization parameter is set to TYPICAL. You receive a complaint about the poor performance of the database between 7 PM and 9 PM of theprevious day. Choose two actions any of which can be referred to first to diagnose the problem. ()
A. Use the Active Session History report.
B. Use the AWR Compare Periods report.
C. Use an ADDM analysis between 7 PM and 9 PM of the previous day.
D. Use the AWR Compare Period report between 7 PM and 9 PM of the previous day.
[单项选择] Your database instance is started using the server parameter file (SPFILE). You executed acommand to change the value of the LOG_BUFFER initialization parameter: ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH; What would be the outcome of this command()
A. The command succeeds only if Automatic Memory Management is not enabled.
B. The command succeeds, but you need to restart the database for changes to take effect.
C. The command returns an error because the size of the redo log buffer cannot be changed dynamically.
D. The parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area (SGA).
[多项选择] Your database instance is running with full workload after database creation. You have decided to useafixed-sizeundo tablespace. You want to use the Undo Advisor to estimate the capacity of the undotablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace()
A. the retention period to support flashback
B. the expected length of the longest-running query
C. the number of undo tablespaces in the database
D. the size of the Flash Recovery Area for the database instance
[单项选择] The database instance has the following parameter setting: OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD.You create a database user OPS$SKD, and then assign external authentication. The user OPS$SKD has theCREATE SESSION privilege. What would you achieve by the above process()
A. The database user OPS$SKD will be able to administer the database.
B. The authentication detail for the database user OPS$SKD is recorded in the password file.
C. The local operating system user SKD will be able to access the database instance without specifying theusername and password.
D. The database user OPS$SKD has to login with the password of the local operating system user SKD toaccess the database instance.
[单项选择] The instance abnormally terminates because of a power outage. Which statement is true about redo log filesduring instance recovery()
A. Inactive and current redo log files are required to accomplish recovery.
B. Online and archived redo log files are required to accomplish instance recovery.
C. All redo log entries after the last checkpoint are applied from redo log files to data files.
D. All redo log entries recorded in the current redo log file until the checkpoint position are applied to data files
[单项选择] In your running instance, some of the initialization parameters are set as shown below: SGA_MAX_SIZE = 14GB DB_CACHE_SIZE = 1GB SHARED_POOL_SIZE = 3GB STATISTICS_LEVEL = BASIC PGA_AGGREGATE_TARGET = 0 You plan to enable Automatic Shared Memory Management but you are not able to set SGA_TARGET to a nonzero value. What could be the reason?()
A. The STATISTICS_LEVEL initialization parameter is set to BASIC
B. The PGA_AGGREGATE_TARGET initialization parameter is set to zero.
C. The SGA_MAX_SIZE initialization parameter is set to less than 20 GB
D. The DB_CACHE_SIZE initialization parameter is set to less than 5 GB
E. The SHARED_POOL_SIZE initialization parameter is set to a nonzero value.
[单项选择] In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC. What isthe impact of this setting()
A. Optimizer statistics are collected automatically.
B. Only timed operating system (OS) statistics and plan execution statistics are collected.
C. The snapshots for the Automatic Workload Repository (AWR) are not generated automatically.
D. Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.
E. The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
[多项选择]
下列解释正确的是()
A. out_applet.java中一定有一个参数是“display_string”
B.
具有两个属性“name”和“value”
C. value是参数的名称
D. “good morning”通过
标记传递给“Our_Applet.class”
[简答题] 一般程序如下: ORG 2000H ARY DW --4,3,--2,1 CNT DW $--ARY VAR DW ARY,$+4 ┆ MOV AX,ARY MOV BX,OFFSET VAR MOV CX,CNT MOV DX,VAR+2 LEA SI,ARY ┆ 此程序段执行后,寄存器AX,BX,CX,DX与SI中的内容各是多少?