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题:
YouaremaintainingtheSALESdatabaseforanorganization.YouhaveenabledtheFlashbackDatabasefeatureandwanttoestimatetheflashbackspacerequiredforfutureoperations.Whichviewwouldyouquerytoestimatetheflashbackspacerequired?()
A.V$DATABASE
B.V$FLASHBACK_DATABASE_STAT
C.V$FLASHBACK_DATABASE_LOG
D.V$RECOVERY_FILE_DEST
第2题:
Whileinstallinganapplication,theadministratorisinstructedtoperformtwofinaltaskspriortostartingtheapplication:1.Settheownershipofafilenamed’control_file’tobeownedbytheuser’database’andthegroup’appsrvr’.2.Changethepermissionsof’control_file’to0766.Afterthesetwotaskshavebeencompleted,whatwillthefilepermissionslooklikewhen’ls-lcontrol_file’isexecuted?()
A.-rwxrw-rw-1databaseappsrvr4913Mar1708:24control_file
B.-rw-r--r--1appsrvrdatabase4913Mar1708:24control_file
C.-rw-r--r--1databaseappsrvr4913Mar1708:24control_file
D.-rwxrw-rw-1appsrvrdatabase4913Mar1708:24control_file
第3题:
A.CONNECT
B.RECOVERY_CATALOG_OWNER
C.DBA
D.RESOURCE
第4题:
A.EXECUTE_CATALOG_ROLE
B.CONNECT
C.RESOURCE
D.RECOVERY_CATALOG_OWNER
E.RECOVERY_CATALOG_USER
第5题:
YouwouldliketocreateanRMANrecovercataloginwhichtostoreinformationaboutyourDB01database.YouwanttousethedatabasenamedRCDBforthestorageofyourrecoverycatalog.Thesixstepsyouwillfollowtocreatearecovercatalogarenotdisplayedinthecorrectorder.Whichdisplaysthecorrectorder?()
1.Granttheappropriateprivileges(CONNECTandRESOURCE)androles
(RECOVERY_CATALOG_OWNER)totheuserresponsibleforperformingbackupandrecoveroperations.
2.Registerthetargetdatabaseinthecatalog.
3.CreatethecatalogusingtheRMANcommandlineinterpreter.
4.Createauserandschemawhichwillowntherecoverycatalog.
5.CreatetablespacetoholdthecataloginthedatabaseyouhavededicatedforyourRMANrecoverycatalog.
6.ConnecttothetargetdatabaseusingSYSDBAprivileges.
第6题:
A.ping
B.Telnet
C.FTP
D.TCP
E.IP