单项选择题
You are employed as a DBA in an organization. You are informed that the record of EMP_NO 1000 is missing from the SCOTT.EMP table. You are required to identify the user who deleted the record， the SQL statement that will undo the deletion， and the transaction ID of the transaction that deleted the employee record. Which feature will you use to perform the tasks？（）
A. Only the Flashback Table
B. Both the Flashback Transaction Query and the Flashback Version Query
C. Only the Flashback Drop
D. Only the Flashback Version
相关考题
-
单项选择题
InwhichscenariowillyouusetheFlashbackTransactionQueryfeature？（）
A. when you want to restore an important table that is dropped from the Recycle Bin
B. when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction
C.when you want to restore a dropped user’s schema
D. when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period -
单项选择题
YouquerytheORDERStableanddiscoverthatordernumber1101ismissing.Oneofyourreports，generatedat5：00A.M.onApril23，2005usingOracleReports，includesthisordernumberintheoutput.Youhaveinserted100newordersintotheORDERStablesincegeneratingthisreport.Whichflashbacktechnologywouldyouusetorecoverordernumber1101intotheORDERStablewithoutlosingthe100ordersthatyouaddedafterthereportwasgenerated？（）
A. Flashback Table
B. Flashback Query
C.Flashback Version Query
D. Flashback Transaction Query -
单项选择题
YoudecidetoenableFlashbackDatabaseinyourOracle10gdatabasesothatfuturerecoverieswilltakelesstimethantraditionalrecoveries.WhichofthefollowingparametersmustbeincludedinyourinitializationparameterfilebeforeenablingFlashbackDatabase？（）
A. DB_RECOVERY_FILE_DEST only
B. DB_FLASHBACK_RETENTION_TARGET only
C. DB_RECOVERY_FILE_DEST_SIZE and DB_RECOVERY_FILE_DEST only
D. DB_RECOVERY_FILE_DEST and DB_FLASHBACK_RETENTION_TARGET only
E. DB_RECOVERY_FILE_DEST_SIZE， DB_RECOVERY_FILE_DEST and
F. DB_FLASHBACK_RETENTION_TARGET
