单项选择题
You query the ORDERS table and discover that order number 1101 is missing. One of your reports, generated at 5:00 A.M. on April 23, 2005 using Oracle Reports, includes this order number in the output. You have inserted 100 new orders into the ORDERS table since generating this report. Which flashback technology would you use to recover order number 1101 into the ORDERS table without losing the 100 orders that you added after the report was generated?()
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 -
单项选择题
InwhichscenariowillyouusetheFlashbackVersionQueryfeature?()
A. when you want to restore a table that has been dropped from the Recycle Bin
B. when you want to identify the transaction ID of the transaction that deleted some important records from a table
C. when you want to recover the schema of a dropped user
D.when you want to restore a dropped tablespace -
单项选择题
YouareworkingasaDBAatNetFxCorporation.YoudiscoverthattheSCOTTschemaisdeletedbymistake.Youdecidetoflashthedatabasebacktothetimewhentheschemaexisted.Whichviewwillyouquerytodeterminetheestimatedsizeoftheflashbackdatathatyourequireforyourcurrenttargetretention?()
A. V$FLASHBACK_DATABASE_LOG
B. V$FLASHBACK_DATABASE_STAT
C. V$DATABASE
D. V$UNDOSTAT
