Which option is best practice for creating a recovery catalog owner in the catalog database?()A. Granting UNLIMITED QUOTA on the SYSTEM tablespace to the ownerB. Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege

题目
Which option is best practice for creating a recovery catalog owner in the catalog database?()

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


相似考题
更多“Which option is best practice for creating a recovery catalog owner in the catalog database?() ”相关问题
  • 第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.


    参考答案:C, D

  • 第2题:

    Whichofthefollowingrolesprovidestheprivilegestomaintainandquerytherecoverycatalogschema?()

    A.EXECUTE_CATALOG_ROLE

    B.CONNECT

    C.RESOURCE

    D.RECOVERY_CATALOG_OWNER

    E.RECOVERY_CATALOG_USER


    参考答案:D

  • 第3题:

    WhichtwoRMANcommandsinitiatearesynchronizationoftherecoverycatalogwiththetargetdatabasecontrolfile?()

    A.COPY

    B.BACKUP

    C.CHANGE

    D.DELETE

    E.CATALOG


    参考答案:A, B, D

  • 第4题:

    Whatprivilegesmustbegrantedtoallowanaccounttocreatetherecoverycatalog?()

    A.RECOVERY_CATALOG_OWNER

    B.DBA

    C.RESOURCE

    D.SELECTANYDICTIONARY

    E.CONNECT


    参考答案:A, C

  • 第5题:

    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

  • 第6题:

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

    A.CONNECT

    B.RECOVERY_CATALOG_OWNER

    C.DBA

    D.RESOURCE


    参考答案:C