单项选择题
The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（）
A.the DBNEWID utility
B.the ANALYZE command
C.the RMAN LIST command
D.the RMAN REPORT command
E.the RMAN CROSSCHECK command
F.the RMAN BLOCKRECOVER command
相关考题
-
单项选择题
Therewasmediafailureandyouneedtocheckthedatafilesforanyblockcorruption.Whichoptionwouldyouusetocreateareportonanycorruptionsfoundwithinthedatabase？（）
A.the DBNEWID utility
B.the DBVERIFY utility
C.the ANALYZE command
D.the RMAN REPORT command
E.the RMAN CROSSCHECK command
F.the CHECK_OBJECT procedure of the DBMS_REPAIR package -
单项选择题
Byusingthetransactionidentifierprovidedby（）foraparticularrowchange，youcanusetheFlashbackTransactionQuerytoseetheoperationperformedbythetransaction.
A.Flashback Table
B.Flashback Database
C.Flashback Versions Query
D.the RMAN REPORT command
E.the DBA_PENDING_TRANSACTIONS view -
单项选择题
You executed the following query： SELECT operation， undo_sql， table_name FROM flashback_transaction_query； Which statement is correct regarding the query output？（）
A.It would return information regarding only the last committed transaction.
B.It would return only the active transactions in all the undo segments in the database.
C.It would return only the committed transactions in all the undo segments in the database.
D.It would return both active and committed transactions in all the undo segments in the database.
E.It would return information regarding the transactions that began and were committed in the last 30 minutes.
