网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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
参考答案
更多 “ 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 store backup information of all registered databases in one placeD. Database backups are automatically deleted when they are older than the specified time period ” 相关考题
考题
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
考题
Whatprivilegesmustbegrantedtoallowanaccounttocreatetherecoverycatalog?()
A.RECOVERY_CATALOG_OWNERB.DBAC.RESOURCED.SELECTANYDICTIONARYE.CONNECT
考题
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
考题
Youarerequiredtoflashbackyourdatabase.Youwanttofindtheamountofflashbackdatageneratedsincethedatabasewasopened.Whichtaskwillyouperformtoobtaintherequiredinformation?()
A.QuerytheV$FLASHBACK_DATABASE_LOGview.B.QuerytheV$FLASHBACK_DATABASE_STATview.C.CheckthevalueoftheDB_FLASHBACK_RETENTION_TARGETinitializationparameter.D.QuerytheV$RECOVERY_FILE_DESTview.
考题
Youdecidedtoconfiguretheflashrecoveryareainyourdatabasetocentralizethestorageofalltherecoveryfilesinacertainlocationondisk.Whichtwoparameterswillyouspecifyintheinit.orafile?()
A.DB_CREATE_FILE_DESTB.DB_RECOVERY_FILE_DESTC.DB_RECOVERY_FILE_DEST_SIZED.DB_ONLINE_LOG_DEST_n
考题
YouaremaintainingtheSALESdatabaseforanorganization.YouhaveenabledtheFlashbackDatabasefeatureandwanttoestimatetheflashbackspacerequiredforfutureoperations.Whichviewwouldyouquerytoestimatetheflashbackspacerequired？（）A.V$DATABASEB.V$FLASHBACK_DATABASE_STATC.V$FLASHBACK_DATABASE_LOGD.V$RECOVERY_FILE_DEST
考题
Whichofthefollowingrolesprovidestheprivilegestomaintainandquerytherecoverycatalogschema?()
A.EXECUTE_CATALOG_ROLEB.CONNECTC.RESOURCED.RECOVERY_CATALOG_OWNERE.RECOVERY_CATALOG_USER
考题
下面哪2个参数是flashback databae必须设置的? ()
A. DB_FLASHBACK_RETENTION_TARGETB. DB_RECOVERY_FILE_DESTC. RECOVERY_PARALLELISMD. FLASHBACK_TRANSACTION_QUERYE. DB_RECOVERY_FILE_DEST_SIZE
考题
YouwouldliketocreateanRMANrecovercatalog&e
YouwouldliketocreateanRMANrecovercataloginwhichtostoreinformationaboutyourDB01database.YouwanttousethedatabasenamedRCDBforthestorageofyourrecoverycatalog.Thesixstepsyouwillfollowtocreatearecovercatalogarenotdisplayedinthecorrectorder.Whichdisplaysthecorrectorder？（）1.Granttheappropriateprivileges（CONNECTandRESOURCE）androles（RECOVERY_CATALOG_OWNER）totheuserresponsibleforperformingbackupandrecoveroperations.2.Registerthetargetdatabaseinthecatalog.3.CreatethecatalogusingtheRMANcommandlineinterpreter.4.Createauserandschemawhichwillowntherecoverycatalog.5.CreatetablespacetoholdthecataloginthedatabaseyouhavededicatedforyourRMANrecoverycatalog.6.ConnecttothetargetdatabaseusingSYSDBAprivileges.
考题
在对RMAN用户进行授权时,不需要授予的权限是()。
A.CONNECTB.RECOVERY_CATALOG_OWNERC.DBAD.RESOURCE
热门标签
最新试卷
