单项选择题

William specified the following initialization paramete……

William specified the following initialization parameter settings in the pfile：
BACKGROUND_DUMP_DEST = ’u01\oradata\dir_A’
USER_DUMP_DEST = ’u01\oradata\dir_B’
DB_CREATE_FILE_DEST = ’u01\oradata\dir_C’
DB_CREATE_ONLINE_LOG_DEST_n = ’u01\oradata\dir_D’
William enabled the change-tracking feature because he does not want to scan the entire datafile during backup. What is the default storage location for the change tracking file？（）

A. ’u01\oradata\dir_A’
B. ’u01\oradata\dir_B’
C. ’u01\oradata\dir_C’
D. ’u01\oradata\dir_D’

<上一题目录下一题>

热门试题

单项选择题YouwanttochecktheEMPtableintheuser，Scott’sschemaforblockcorruption.Youalsowanttofixthecorruptedblocks，ifany.Howwillyouaccomplishtherequiredtask？（）

A.by using the ANALYZE utility
B.by using the DBVERIFY utility
C.by using the DB_BLOCK_CHECKING parameter
D.by using the DBMS_REPAIR package

单项选择题YouareusingtheDBVERIFYutilitytocheckthedatafilesforanyblockcorruption.Youwanttowritetheoutputofthedbvcommandtoafilenottothescreen.WhichparameteroftheDBVERIFYutilitywillyouuse？（）

A. FILE
B. PARFILE
C. LOGFILE
D. FEEDBACK

单项选择题While working on the database， you receive the following error： 01578： ORACLE data block corrupted （file# 6， block # 54） ORA-01110 ： data file 6： ’u01 oracle oradata data1.dbf’ You decide to recover the corrupted data block by using the Block Media Recovery feature. Which option is NOT a disadvantage of using block media recovery？（）

A. Block Media Recovery must be used with RMAN.
B. You must perform complete recovery of individual blocks.
C. You must have a full RMAN backup， not an incremental backup.
D. You must use the DBVERIFY utility before using the Block Media Recovery feature.

单项选择题You executed the following code： BACKUP VALIDATE DATABASE； BLOCKRECOVER CORRUPTION LIST； What will be the result of executing the above code？（）

A. The code will run a backup validation to populate the V$BACKUP_CORRUPTION view and repair corrupt blocks， if any， recorded in the view.
B. The code will run a backup validate to populate the V$COPY_CORRUPTION view and then repair any corrupt blocks recorded in the view.
C. The code will runs a backup validate to populate the V$DATABASE_BLOCK_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.
D. The code will run a backup validate to populate the RC_BACKUP_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.

多项选择题WhichtwostatementsaretrueaboutBlockMediaRecovery（BMR）？（）

A. BMR increases the Mean Time To Recover （MTTR）.
B. BMR can only be implemented using Recovery Manager （RMAN）.
C. The blocks that need to be recovered are accessible during BMR.
D. BMR cannot be performed using cumulative incremental backups.
E. The datafile must be restored if most of the blocks in the datafile are corrupt.