Which two statements regarding the Flashback Table feature are correct?()A. Flashback Table can be performed on system tables.B. Flashback Table operation does not shrink the segments.C. Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO sta

题目
Which two statements regarding the Flashback Table feature are correct?()

A. Flashback Table can be performed on system tables.

B. Flashback Table operation does not shrink the segments.

C. Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.

D. Flashback Table operation acquires exclusive data manipulation language (DML) locks.


相似考题
更多“Which two statements regarding the Flashback Table feature are correct?() ”相关问题
  • 第1题:

    YoudecidetoenableFlashbackDatabaseinyourOracle10gdatabasesothatfuturerecoverieswilltakelesstimethantraditionalrecoveries.WhichofthefollowingparametersmustbeincludedinyourinitializationparameterfilebeforeenablingFlashbackDatabase?()

    A.DB_RECOVERY_FILE_DESTonly

    B.DB_FLASHBACK_RETENTION_TARGETonly

    C.DB_RECOVERY_FILE_DEST_SIZEandDB_RECOVERY_FILE_DESTonly

    D.DB_RECOVERY_FILE_DESTandDB_FLASHBACK_RETENTION_TARGETonly

    E.DB_RECOVERY_FILE_DEST_SIZE,DB_RECOVERY_FILE_DESTand

    F.DB_FLASHBACK_RETENTION_TARGET


    参考答案:C

  • 第2题:

    Youarerequiredtoflashbackyourdatabase.Youwanttofindtheamountofflashbackdatageneratedsincethedatabasewasopened.Whichtaskwillyouperformtoobtaintherequiredinformation?()

    A.QuerytheV$FLASHBACK_DATABASE_LOGview.

    B.QuerytheV$FLASHBACK_DATABASE_STATview.

    C.CheckthevalueoftheDB_FLASHBACK_RETENTION_TARGETinitializationparameter.

    D.QuerytheV$RECOVERY_FILE_DESTview.


    参考答案:B

  • 第3题:

    Import for the first three months this year is larger than that for the__________period last year.


    A.relating

    B.concerning

    C.corresponding

    D.regarding

    答案:C
    解析:
    考查词义辨析。句意为“今年前三个月的进口量比上一年同期多”。relating to“相关的”,concerning“关于”,corresponding“相当的,对应的”,regarding“关于;就……而论”。根据句意可知是今年前三个月和去年相对应的前三个月做对比.故选C。

  • 第4题:

    YouareworkingasaDBAatNetFxCorporation.YoudiscoverthattheSCOTTschemaisdeletedbymistake.Youdecidetoflashthedatabasebacktothetimewhentheschemaexisted.Whichviewwillyouquerytodeterminetheestimatedsizeoftheflashbackdatathatyourequireforyourcurrenttargetretention?()

    A.V$FLASHBACK_DATABASE_LOG

    B.V$FLASHBACK_DATABASE_STAT

    C.V$DATABASE

    D.V$UNDOSTAT


    参考答案:A

  • 第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即闪回,是指病人仿佛又完全身临创伤性事件发生时的情境,重新表现出事件发生时所伴发的各种情感,持续时间可从数秒钟到几天不等。