What two are the prerequisites for enabling Flashback Database?()A. The database must be in ARCHIVELOG modeB. The database must be in MOUNT EXCLUSIVE modeC. The database must be opened in RESTRICTED modeD. The database instance must be started in the NOMO

题目
What two are the prerequisites for enabling Flashback Database?()

A. The database must be in ARCHIVELOG mode

B. The database must be in MOUNT EXCLUSIVE mode

C. The database must be opened in RESTRICTED mode

D. The database instance must be started in the NOMOUNT state

E. The database instance must have the keep buffer pool defined


相似考题
更多“What two are the prerequisites for enabling Flashback Database?() ”相关问题
  • 第1题:

    YouareworkingasaDBAatNetFxCorporation.YoudiscoverthattheSCOTTschemaisdeletedbymistake.Youdecidetoflashthedatabasebacktothetimewhentheschemaexisted.Whichviewwillyouquerytodeterminetheestimatedsizeoftheflashbackdatathatyourequireforyourcurrenttargetretention?()

    A.V$FLASHBACK_DATABASE_LOG

    B.V$FLASHBACK_DATABASE_STAT

    C.V$DATABASE

    D.V$UNDOSTAT


    参考答案:A

  • 第2题:

    At10:30A.M.,youranabatchjobbymistake,whichexecutedatransactioninthedatabase.Thetransactionidentifierofthetransactionthatmadetothechangesinthedatabaseis0500A00627B000.At11:10A.M.,youstoppedthebatchjob.Now,youwanttoidentifythechangesmadetothedatabasetablesbythebatchjob.Whichviewwillyouquery?()

    A.DBA_PENDING_TRANSACTIONS

    B.DBA_AUDIT_STATEMENT

    C.V$FLASHBACK_DATABASE_STATS

    D.FLASHBACK_TRANSACTION_QUERY


    参考答案:D

  • 第3题:

    YouaremaintainingtheSALESdatabaseforanorganization.YouhaveenabledtheFlashbackDatabasefeatureandwanttoestimatetheflashbackspacerequiredforfutureoperations.Whichviewwouldyouquerytoestimatetheflashbackspacerequired?()

    A.V$DATABASE

    B.V$FLASHBACK_DATABASE_STAT

    C.V$FLASHBACK_DATABASE_LOG

    D.V$RECOVERY_FILE_DEST


    参考答案:B

  • 第4题:

    FlashbackDatabaseisenabledinyourOracle10gdatabase.Oneofyourdatabaseuserserroneouslypurgedanimportanttableresidinginhisschema.Thetablewaspurgedsometimebetween10:00P.M.and10:30P.M.Thenextday,youdecidetoflashbackthedatabase.Beforeyouflashbackthedatabase,youwanttoensurethatyouhaveallthenecessaryflashbackdata.Whichdynamicperformanceviewmustyouusetodeterminewhetheryouhavetherequiredflashbackdatatorecoverthepurgedtable?()

    A.V$DATABASE

    B.V$UNDOSTAT

    C.V$FLASHBACK_DATABASE_LOG

    D.V$FLASHBACK_DATABASE_STAT


    参考答案:C

  • 第5题:

    Youarerequiredtoflashbackyourdatabase.Youwanttofindtheamountofflashbackdatageneratedsincethedatabasewasopened.Whichtaskwillyouperformtoobtaintherequiredinformation?()

    A.QuerytheV$FLASHBACK_DATABASE_LOGview.

    B.QuerytheV$FLASHBACK_DATABASE_STATview.

    C.CheckthevalueoftheDB_FLASHBACK_RETENTION_TARGETinitializationparameter.

    D.QuerytheV$RECOVERY_FILE_DESTview.


    参考答案:B

  • 第6题:

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

    A.Thetimewhenthelastflashbackoperationinyourdatabasewasperformed.

    B.Thetimewhenthefirstflashbackoperationinyourdatabasewasperformed.

    C.AlistofflashbackoperationsperformedinyourdatabaseusingSCNandtime.

    D.Theapproximatetimeandthelowestsystemchangenumber(SCN)towhichyoucanflashbackyourdatabase.


    参考答案:D