A. Granting UNLIMITED QUOTA on the SYSTEM tablespace to the owner
B. Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the user
C. Creating a new tablespace, allocating this as the default, and granting UNLIMITED QUOTA on this tablespace to the user
D. Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user
第1题:
WhichisthecorrectwaytoconnecttoboththetargetdatabaseandtherecoverycatalogfromtheRMANcommandline?()AssumethatthetargetdatabaseiscalledORCLandthattherecoverycatalogdatabaseiscalledRCAT.Alsoassumethattherecovery-catalogowneriscalledRCAT_OWN.AssumetheenvironmentisconfiguredfortheORCLdatabase.
A.rmantarget=/catalog=/@rcat
B.rmantarget=/catalog=rcat_own/rcat_own
C.rmantarget=/catalog=rcat_own/rcat_own@RCAT
D.rmantarget=sys/robert@orclcatalog=rcat_own/rcat_own@RCAT
E.Youcannotconnecttothetargetdatabaseandtherecoverycatalogatthesametime.
第2题:
A.EXECUTE_CATALOG_ROLE
B.CONNECT
C.RESOURCE
D.RECOVERY_CATALOG_OWNER
E.RECOVERY_CATALOG_USER
第3题:
A.COPY
B.BACKUP
C.CHANGE
D.DELETE
E.CATALOG
第4题:
A.RECOVERY_CATALOG_OWNER
B.DBA
C.RESOURCE
D.SELECTANYDICTIONARY
E.CONNECT
第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.CONNECT
B.RECOVERY_CATALOG_OWNER
C.DBA
D.RESOURCE