单项选择题
You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup?()
A. V$BACKUP_CORRUPTION
B. V$COPY_CORRUPTION
C. V$DATABASE_BLOCK_CORRUPTION
D. RC_BACKUP_CORRUPTION
相关考题
-
单项选择题
YouaremaintainingyourOLTPdatabaseinOracle10g.YouareperformingtheFlashbackTransactionQuerytofindtheundoSQLstatementsthatcanbeusedtoundothechangesmadetothedatabaseinthespecifictimeperiod.WhichpseudocolumnwillyouusetoperformtheFlashbackTransactionQuery?()
A. VERSIONS_STARTSCN
B. VERSIONS_STARTTIME
C. VERSIONS_XID
D. VERSIONS_OPERATION -
单项选择题
WhatwillbetheresultofusingtheSQL>DROPUSERSCOTTCASCADE;command?()
A. The user, Scott, is dropped, all the objects in Scott’s schema are placed in the Recycle Bin, and the objects that are already in the Recycle Bin are dropped.
B. The user, Scott, is dropped, all the objects in Scott’s schema are placed in the Recycle Bin, and all the objects in the Recycle Bin, belonging to the user Scott, are not dropped.
C. The user, Scott, is dropped, all the objects in the Scott’s schema are not placed in the Recycle Bin, and the objects in the Recycle Bin, belonging to the user, Scott, are not dropped.
D. The user, Scott, is dropped, all the objects in Scott’s schema are not placed in the Recycle Bin, and the objects in the Recycle Bin are dropped. -
单项选择题
You are performing flashback of the ORDERS table in the Scott’s schema because some important data is deleted in the table by mistake. The SCN number was 771513 at the time of deletion. You issued the following statement to perform Flashback Table: SQL> FLASHBACK TABLE ORDERS TO SCN 771513; What is the prerequisite to perform Flashback Table?()
A. You must configure OMF in your database.
B. You must enable block change tracking feature in your database.
C. You must enable ROW MOVEMENT feature on the ORDERS table.
D. You must use the Flashback Version Query before using the Flashback Table feature.
