You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology, you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database. After the installation, you make the following changes in your initialization parameter file:LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’ DB_RECOVERY_FILE_DEST = ’LOCATION=d:/product/10.1.0/flash_recovery_area’ DB_RECOVERY_FILE_DEST_SIZE=10g Where are the archived redo logs stored for your database?()
A、 The archived redo logs are stored in an operating system-dependent location.
B、 The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.
C、 The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.
D、 The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and DB_RECOVERY_FILE_DEST.
相关问题推荐
-
You are the Database Administrator (DBA) of your company. You execute the following statement on an Oracle 10g instance: SQL> ALTER SYSTEM SWITCH LOGFILE; Which two tasks are performed when the statement is executed? ()
AThe DBWn process writes to the datafile.
BChanges in the background process are recorded.
CThe log file is updated with the current SCN number.
DThe System Change Number (SCN) is recorded in the control file.
EThe changes to the listener configuration in the listener.ora file are recorded.
-
In your production database, you have multiple resource plan directives that refer to the consumer group DB_GRP. Which two statements are correct?()
AThe parallel degree limit for DB_GRP will be the minimum of all the incoming values.
BThe parallel degree limit for DB_GRP will be the maximum of all the incoming values.
CThe maximum estimated execution time for DB_GRP would be the most nonrestrictive of all incoming values.
DIf a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time, then that session would not execute if the active session pool for the new consumer group was full.
EIf a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time, then that session would execute even if the active session pool for the new consumer group was full.
-
You are working on an Oracle Database 10g database. Because of data loss, you decided to perform a Flashback Database operation using the following command: SQL> FLASHBACK DATABASE TO TIMESTAMP(SYSDATE 5/24); Which two statements are true? ()
ASYSDATE should not be used with TIMESTAMP.
BThe database must have multiplexed redo log files.
CThe database must be in the MOUNT state to execute the command.
DThe database must be opened with the RESETLOGS option after the flashback operation.
EThe entire database needs to be restored from the most recent backup before the flashback operation.
-
You are using the Database Resource Manager to manage database resources. You created a resource plan directive for the MANAGERS resource consumer group under the SALES_PLAN by using the following statement: SQL>EXEC DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE (PLAN => ’SALES_PLAN’, GROUP_OR_SUBPLAN => ’MANAGERS’, CPU_P1 => 100, CPU_P2 =>0, SWITCH_GROUP => ’CLERKS’, SWITCH_TIME_IN_CALL => 600); A user, SCOTT, who is assigned to the MANAGERS group, starts a database session and executes a query on the database. What is the outcome if the query takes approximately 15 minutes to complete?()
A、 The query starts under the CLERKS group and the user, SCOTT, switches back to the MANAGERS group after the query completes.
B、 The query starts under the MANAGERS group but terminates with an error when the execution time exceeds 10 minutes.
C、 The query starts under the MANAGERS group and switches automatically to the CLERKS group when the execution time exceeds 10 minutes. The query does not switch back to the MANAGERS group after the query completes.
D、 The query starts under the MANAGERS group, the user SCOTT switches automatically to the CLERKS group when the execution time exceeds 10 minutes, and then switches back to the MANAGERS group after the query completes.
-
You have issued the following command: RMAN>CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 100 DAYS; What will be the result of using the above command?()
A、 The backup metadata will be maintained in the control file for 100 days.
B、 The backup metadata will be maintained in the recovery catalog for 100 days.
C、 The backup metadata will be maintained in the flash recovery area for 100 days.
D、 After 100 days, the backup sets and image copies will be deleted from the media.