You want to set the following initialization parameters for your database instance: LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 = 'LOCATION=/disk2/arch' LOG_ARCHIVE_DEST_3 = 'LOACTION=/disk3/arch' LOG_ARCHIVE_DEST_4 = 'LOCATION=/disk4/arch MANDATORY' Identify the statement that correctly describes this setting.()
A、The MANDATORY location must be a flash recovery area.
B、The optional destinations may not use the flash recovery area.
C、This setting is not allowed because the first destination is not set as MANDATORY.
D、The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.
相关问题推荐
-
If you back up a database without connecting to the recovery catalog, which operations will cause the recovery catalog to be updated?()
AThe next time you back up the database when you are also connected to the recovery catalog and the target database
BThe next time you are connected to the target database and the recovery catalog database and issue the resync command
CThe next time you connect RMAN to just the recovery catalog
DThe next time you connect to the recovery catalog and the target database with RMAN
EConnecting to the recovery catalog and issuing the resync all databases command
-
Examine the following command: SQL> ALTER TABLE booking SHRINK SPACE COMPACT; Which activity is performed when the preceding command is executed?()
A、The shrink operation touches every block in the BOOKING table
B、The high-water mark (HWM) for the BOOKING table is shifted from its original position
C、The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table
D、The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation
-
You are maintaining the SALES database. You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity. Which parameter should you specify to control the speed of the rebalancing activity?()
A、 ASM_POWER_LIMIT
B、 ASM_DISKSTRING
C、 ASM_DISKGROUPS
D、 INSTANCE_TYPE
-
Which statement most accurately describes the implementation of a SQL Access Advisor recommendation?()
A、SQL Access Advisor recommendations are automatically implemented.
B、Individual SQL Access Advisor recommendations can be scheduled for implementation.
C、All SQL Access Advisor recommendations for a specific task must be implemented at the same time.
D、SQL Access Advisor recommendations are automatically scheduled for implementation during the maintenance window.
E、None of the above.
-
If a log file becomes corrupted, it may cause the database to stall. How would you correct such a situation?()
A、 Recover the online redo log from backup.
B、 Delete and re-create the log file.
C、 Use the alter database clear logfile command to clear the log file.
D、 Shut down the database and restart it.
E、 Shut down the database and then mount it. Clear the log file with the alter database clear logfile command and then restart the database with alter database open resetlogs.