itgle.com

Note the following statements that use flashback technology:1. FLASHBACK TABLE <table> TO SCN <scn>;2. SELECT * FROM <table> AS OF SCN 123456;3. FLASHBACK TABLE <table> TO BEFORE DROP;4. FLASHBACK DATABASE TO TIMESTAMP <timestamp>;5. SELECT * FROM <table>

题目

Note the following statements that use flashback technology:1. FLASHBACK TABLE <table> TO SCN <scn>;2. SELECT * FROM <table> AS OF SCN 123456;3. FLASHBACK TABLE <table> TO BEFORE DROP;4. FLASHBACK DATABASE TO TIMESTAMP <timestamp>;5. SELECT * FROM <table> VERSIONS AS OF SCN 123456 AND 123999;Which of these statements will be dependent on the availability of relevant undo data in the undo segment?（）

A. 1, 2, and 5

B. 1, 3, and 4

C. 2, 3, 4, and 5

D. 1, 2, 3, 4, and 5

相似考题

1.On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am. Which option must you use to check whether a flashback operation can recover the database to the specified time? （）A. Check the alert log fileB. Query the V$FLASHBACK_DATABASE_LOG viewC. Query the V$RECOVERY_FILE_DEST_SIZE viewD.Query the V$FLASHBACK_DATABASE_STAT viewE. Check the value assigned for the UNDO_RETENTION parameter

2.ThesearethedetailsaboutV$FLASHBACK_DATABASE_STAT：SQL>DESCV$FLASHBACK_DATABASE_STATNameNull？Type-----------------------------------BEGIN_TIMEDATEEND_TIMEDATEFLASHBACK_DATANUMBERDB_DATANUMBERREDO_DATANUMBERESTIMATED_FLASHBACK_SIZENUMBERWhichtwostatementsregardingtheV$FLASHBACK_DATABASE_STATviewaretrue？（）A.BEGIN_TIMEisthetimeatwhichFlashbackloggingisenabled.B.END_TIMEisthetimeatwhichthequeryisexecutedontheview.C.REDO_DATAisthenumberofbytesofredodatawrittenduringtheinterval.D.Thisviewcontainsinformationaboutflashbackdatapertainingtothelast24hours.E.FLASHBACK_DATAistheamountofflashbackdatageneratedsincethedatabasewasopened.

3.YoudecidetoenableFlashbackDatabaseinyourOracle10gdatabasesothatfuturerecoverieswilltakelesstimethantraditionalrecoveries.WhichofthefollowingparametersmustbeincludedinyourinitializationparameterfilebeforeenablingFlashbackDatabase？（）A.DB_RECOVERY_FILE_DESTonlyB.DB_FLASHBACK_RETENTION_TARGETonlyC.DB_RECOVERY_FILE_DEST_SIZEandDB_RECOVERY_FILE_DESTonlyD.DB_RECOVERY_FILE_DESTandDB_FLASHBACK_RETENTION_TARGETonlyE.DB_RECOVERY_FILE_DEST_SIZE，DB_RECOVERY_FILE_DESTandF.DB_FLASHBACK_RETENTION_TARGET

4.Notetheoutputofthefollowingquery；SQL>SELECTflashback_archieve_name，statusFROMdba_flashback_archieve；FLASHBACK_ARCHIEVE_NAMESTATUSFLA1YouexecutedthefollowingcommandtoenableFlashbackDataArchiveontheEXCHANGB_PATEtable：ALTERTABLEexchange_rateFLASHBACKARCHIEVE；Whatistheoutcomeofthiscommand？（）A.ThetableusesthedefaultFlashbackDataArchive.B.TheFlashbackDataArchiveIscreatedIntheSYSAUXtablespace.C.TheFlashbackDataArchiveiscreatedinthesametablespacewherethetablesarestored.D.ThecommandgeneratesanerrorbecausenoflashbackDataArchivenameisspecifiedandthereis nodefaultFlashbackDataAchieve.

更多“Note the following statements that use flashback technology:1. FLASHBACK TABLE &lt;table&g ”相关问题

  • 第1题：

    YouareworkingasaDBAatNetFxCorporation.YoudiscoverthattheSCOTTschemaisdeletedbymistake.Youdecidetoflashthedatabasebacktothetimewhentheschemaexisted.Whichviewwillyouquerytodeterminetheestimatedsizeoftheflashbackdatathatyourequireforyourcurrenttargetretention？（）

    A.V$FLASHBACK_DATABASE_LOG

    B.V$FLASHBACK_DATABASE_STAT

    C.V$DATABASE

    D.V$UNDOSTAT


    参考答案：A

  • 第2题：

    YouaremaintainingtheSALESdatabaseforanorganization.YouhaveenabledtheFlashbackDatabasefeatureandwanttoestimatetheflashbackspacerequiredforfutureoperations.Whichviewwouldyouquerytoestimatetheflashbackspacerequired？（）

    A.V$DATABASE

    B.V$FLASHBACK_DATABASE_STAT

    C.V$FLASHBACK_DATABASE_LOG

    D.V$RECOVERY_FILE_DEST


    参考答案：B

  • 第3题：

    下面哪2个参数是flashback databae必须设置的? ()

    A. DB_FLASHBACK_RETENTION_TARGET

    B. DB_RECOVERY_FILE_DEST

    C. RECOVERY_PARALLELISM

    D. FLASHBACK_TRANSACTION_QUERY

    E. DB_RECOVERY_FILE_DEST_SIZE


    参考答案BE

  • 第4题：

    Youarerequiredtoflashbackyourdatabase.Youwanttofindtheamountofflashbackdatageneratedsincethedatabasewasopened.Whichtaskwillyouperformtoobtaintherequiredinformation?()

    A.QuerytheV$FLASHBACK_DATABASE_LOGview.

    B.QuerytheV$FLASHBACK_DATABASE_STATview.

    C.CheckthevalueoftheDB_FLASHBACK_RETENTION_TARGETinitializationparameter.

    D.QuerytheV$RECOVERY_FILE_DESTview.


    参考答案：B

  • 第5题：

    Youexecutedthefollowingqueryinyourdatabase:SELECToldest_flashback_scn,oldest_flashback_timeFROMV$FLASHBACK_DATABASE_LOG;Whatwouldyoudeterminefromthe output?()

    A.Thetimewhenthelastflashbackoperationinyourdatabasewasperformed.

    B.Thetimewhenthefirstflashbackoperationinyourdatabasewasperformed.

    C.AlistofflashbackoperationsperformedinyourdatabaseusingSCNandtime.

    D.Theapproximatetimeandthelowestsystemchangenumber（SCN）towhichyoucanflashbackyourdatabase.


    参考答案：D

  • 第6题：

    Flash back


    答案：
    解析：
    Hash back即闪回，是指病人仿佛又完全身临创伤性事件发生时的情境，重新表现出事件发生时所伴发的各种情感，持续时间可从数秒钟到几天不等。

相关内容