niusouti.com

Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN)?()A. You can use RMAN stored scriptsB. Recovery is faster if data is stored in catalog in addition to the control fileC. You can stor

题目
Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN)?()

A. You can use RMAN stored scripts

B. Recovery is faster if data is stored in catalog in addition to the control file

C. You can store backup information of all registered databases in one place

D. Database backups are automatically deleted when they are older than the specified time period

相似考题

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.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

3.Youarerequiredtoflashbackyourdatabase.Youwanttofindtheamountofflashbackdatageneratedsincethedatabasewasopened.Whichtaskwillyouperformtoobtaintherequiredinformation?()A.QuerytheV$FLASHBACK_DATABASE_LOGview.B.QuerytheV$FLASHBACK_DATABASE_STATview.C.CheckthevalueoftheDB_FLASHBACK_RETENTION_TARGETinitializationparameter.D.QuerytheV$RECOVERY_FILE_DESTview.

4.Whatprivilegesmustbegrantedtoallowanaccounttocreatetherecoverycatalog?()A.RECOVERY_CATALOG_OWNERB.DBAC.RESOURCED.SELECTANYDICTIONARYE.CONNECT

更多“Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN)?() ”相关问题

  • 第1题：

    Youdecidedtoconfiguretheflashrecoveryareainyourdatabasetocentralizethestorageofalltherecoveryfilesinacertainlocationondisk.Whichtwoparameterswillyouspecifyintheinit.orafile?()

    A.DB_CREATE_FILE_DEST

    B.DB_RECOVERY_FILE_DEST

    C.DB_RECOVERY_FILE_DEST_SIZE

    D.DB_ONLINE_LOG_DEST_n


    参考答案：B, C

  • 第2题：

    Whichofthefollowingrolesprovidestheprivilegestomaintainandquerytherecoverycatalogschema?()

    A.EXECUTE_CATALOG_ROLE

    B.CONNECT

    C.RESOURCE

    D.RECOVERY_CATALOG_OWNER

    E.RECOVERY_CATALOG_USER


    参考答案：D

  • 第3题：

    YouwouldliketocreateanRMANrecovercatalog&e

    YouwouldliketocreateanRMANrecovercataloginwhichtostoreinformationaboutyourDB01database.YouwanttousethedatabasenamedRCDBforthestorageofyourrecoverycatalog.Thesixstepsyouwillfollowtocreatearecovercatalogarenotdisplayedinthecorrectorder.Whichdisplaysthecorrectorder？（）

    1.Granttheappropriateprivileges（CONNECTandRESOURCE）androles

    （RECOVERY_CATALOG_OWNER）totheuserresponsibleforperformingbackupandrecoveroperations.

    2.Registerthetargetdatabaseinthecatalog.

    3.CreatethecatalogusingtheRMANcommandlineinterpreter.

    4.Createauserandschemawhichwillowntherecoverycatalog.

    5.CreatetablespacetoholdthecataloginthedatabaseyouhavededicatedforyourRMANrecoverycatalog.

    6.ConnecttothetargetdatabaseusingSYSDBAprivileges.


    参考答案：E

  • 第4题：

    YouaremaintainingtheSALESdatabaseforanorganization.YouhaveenabledtheFlashbackDatabasefeatureandwanttoestimatetheflashbackspacerequiredforfutureoperations.Whichviewwouldyouquerytoestimatetheflashbackspacerequired？（）

    A.V$DATABASE

    B.V$FLASHBACK_DATABASE_STAT

    C.V$FLASHBACK_DATABASE_LOG

    D.V$RECOVERY_FILE_DEST


    参考答案：B

  • 第5题：

    下面哪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

  • 第6题：

    在对RMAN用户进行授权时,不需要授予的权限是()。

    A.CONNECT

    B.RECOVERY_CATALOG_OWNER

    C.DBA

    D.RESOURCE


    参考答案：C

相关内容