单选题Which of the following roles provides the privileges to maintain and query the recovery catalog schema？（）A EXECUTE_CATALOG_ROLEB CONNECTC RESOURCED RECOVERY_CATALOG_OWNERE RECOVERY_CATALOG_USER

题目
单选题
Which of the following roles provides the privileges to maintain and query the recovery catalog schema？（）
A

EXECUTE_CATALOG_ROLE

B

CONNECT

C

RESOURCE

D

RECOVERY_CATALOG_OWNER

E

RECOVERY_CATALOG_USER

相似考题

1.You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11.You executed the following commands:Which two statements are true regarding the tasks accomplished with these commands?（）A. They import all metadata from the RCAT10 catalog.B. They unregister the database from the RCAT10 catalog.C. They do not register the databases registered in the RCAT10 catalog.D. They register all databases registered in the RCAT10 catalog.

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

3.Whichofthefollowingrolesprovidestheprivilegestomaintainandquerytherecoverycatalogschema?()A.EXECUTE_CATALOG_ROLEB.CONNECTC.RESOURCED.RECOVERY_CATALOG_OWNERE.RECOVERY_CATALOG_USER

4.You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository.Which condition must be met before you create the VPC?（）A. A base catalog existsB. The recovery catalog is emptyC. The base recovery catalog must be droppedD. A target database is registered in the recovery catalog

更多“单选题Which of the following roles provides the privileges to maintain and query the recovery catalog schema？（）A EXECUTE_CATALOG_ROLEB CONNECTC RESOURCED RECOVERY_CATALOG_OWNERE RECOVERY_CATALOG_USER”相关问题

  • 第1题：

    The RVPC user can do which of the following？（）

    • A、 Register databases if granted the register database privilege
    • B、 See all databases in the recovery-catalog schema
    • C、 See all database-related metadata in the recovery catalog if they are granted access to that database
    • D、 Unregister databases from the RVPC catalog that were not granted to the RVPC catalog owner with  the grant command
    • E、 Not be connected to with the RMAN command-line catalog parameter for backup or recovery purposes

    正确答案:A,C

  • 第2题：

    You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN). Identify two scenarios is which you must have a recovery catalog.（）

    • A、To store the backup information of multiple database
    • B、To restrict the amount of space that is used by the backups
    • C、To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.
    • D、To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

    正确答案:A,D

  • 第3题：

    How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog？（）  

    • A、 Issue the grant command from the SYS user （or equivalent） of the target database.
    • B、 Issue the grant command from the SYS user （or equivalent） of the recovery-catalog database.
    • C、 Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.
    • D、 Issue the grant command from RMAN when connected to the recovery catalog-owning schema.
    • E、 Issue the grant command from RMAN when connected to the target database.

    正确答案:D

  • 第4题：

    You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files：  $ rman target /  What would be the effect of this command？（）

    • A、RMAN would use the current operating system location to place the backup.
    • B、RMAN would use the control file of the target database to maintain the backup.
    • C、RMAN would use the recovery catalog of the target database to maintain the backup.
    • D、RMAN would use the control file of the target database to maintain the backup metadata. 
    • E、RMAN would use the recovery catalog of the target database to maintain the backup metadata.

    正确答案:D

  • 第5题：

    Which command do you use to create a recovery-catalog schema? （）

    • A、create recovery catalog 
    • B、create catalog
    • C、build catalog 
    • D、catalog create 
    • E、mount catalog 

    正确答案:B

  • 第6题：

    多选题
    What privileges must be granted to allow an account to create the recovery catalog？（）
    A

    RECOVERY_CATALOG_OWNER

    B

    DBA

    C

    RESOURCE

    D

    SELECT ANY DICTIONARY

    E

    CONNECT


    正确答案： C,A
    解析： 暂无解析

  • 第7题：

    单选题
    You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files：  $ rman target /  What would be the effect of this command？（）
    A

    RMAN would use the current operating system location to place the backup.

    B

    RMAN would use the control file of the target database to maintain the backup.

    C

    RMAN would use the recovery catalog of the target database to maintain the backup.

    D

    RMAN would use the control file of the target database to maintain the backup metadata. 

    E

    RMAN would use the recovery catalog of the target database to maintain the backup metadata.


    正确答案： C
    解析： 暂无解析

  • 第8题：

    单选题
    You executed the following command in Recovery Manager （RMAN）： RMAN> RESTORE CONTROLFILE; Which operation must you perform before this command is executed？（）
    A

    back up the control file to trace

    B

    bring database to the MOUNT state

    C

    open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database

    D

    set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog


    正确答案： D
    解析： 暂无解析

  • 第9题：

    单选题
    You would like to create an RMAN recover catalog in which to store information about your DB01 database. You want to use the database named RCDB for the storage of your recovery catalog. The six steps you will follow to create a recover catalog are not displayed in the correct order. Which displays the correct order？（） 1. Grant the appropriate privileges （CONNECT and RESOURCE） and roles  （RECOVERY_CATALOG_OWNER） to the user responsible for performing backup and recover operations.  2. Register the target database in the catalog.  3. Create the catalog using the RMAN command line interpreter.  4. Create a user and schema which will own the recovery catalog.  5. Create tablespace to hold the catalog in the database you have dedicated for your RMAN recovery catalog.  6. Connect to the target database using SYSDBA privileges.
    A

    4，1，5，6，3，2

    B

    4，3，1，5，6，2

    C

    4，5，1，3，2，6

    D

    5，4，1，3，2，6

    E

    5，4，1，3，6，2


    正确答案： B
    解析： 暂无解析

  • 第10题：

    多选题
    You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).Identify two scenarios is which you must have a recovery catalog. （）(Choose two.)
    A

    To store the backup information of multiple database

    B

    To restrict the amount of space that is used by the backups

    C

    To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.

    D

    To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.


    正确答案： B,C
    解析： 暂无解析

  • 第11题：

    单选题
    How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog？（）
    A

     Issue the grant command from the SYS user （or equivalent） of the target database.

    B

     Issue the grant command from the SYS user （or equivalent） of the recovery-catalog database.

    C

     Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.

    D

     Issue the grant command from RMAN when connected to the recovery catalog-owning schema.

    E

     Issue the grant command from RMAN when connected to the target database.


    正确答案： A
    解析： 暂无解析

  • 第12题：

    单选题
    You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository. Which condition must be met before you create the VPC?（）
    A

    A base catalog exists

    B

    The recovery catalog is empty

    C

    The base recovery catalog must be dropped

    D

    A target database is registered in the recovery catalog


    正确答案： A
    解析： 暂无解析

  • 第13题：

    Which of the following server roles provides a common time to all computers？（）

    • A、NTP
    • B、SNMP
    • C、SMTP
    • D、RAS

    正确答案:A

  • 第14题：

    You would like to create an RMAN recover catalog in which to store information about your DB01 database. You want to use the database named RCDB for the storage of your recovery catalog. The six steps you will follow to create a recover catalog are not displayed in the correct order. Which displays the correct order？（） 1. Grant the appropriate privileges （CONNECT and RESOURCE） and roles  （RECOVERY_CATALOG_OWNER） to the user responsible for performing backup and recover operations.  2. Register the target database in the catalog.  3. Create the catalog using the RMAN command line interpreter.  4. Create a user and schema which will own the recovery catalog.  5. Create tablespace to hold the catalog in the database you have dedicated for your RMAN recovery catalog.  6. Connect to the target database using SYSDBA privileges.

    • A、4，1，5，6，3，2
    • B、4，3，1，5，6，2
    • C、4，5，1，3，2，6
    • D、5，4，1，3，2，6
    • E、5，4，1，3，6，2

    正确答案:E

  • 第15题：

    You want to create the Recovery Manager （RMAN） Virtual Private Catalog （VPC） to maintain a separation of responsibilities along with a consolidation of RMAN repository.  Which condition must be met before you create the VPC？（）  

    • A、 A base catalog exists
    • B、 The recovery catalog is empty
    • C、 The base recovery catalog must be dropped
    • D、 A target database is registered in the recovery catalog

    正确答案:A

  • 第16题：

    You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).Identify two scenarios is which you must have a recovery catalog. （）(Choose two.)

    • A、To store the backup information of multiple database
    • B、To restrict the amount of space that is used by the backups
    • C、To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.
    • D、To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

    正确答案:A,D

  • 第17题：

    What privileges must be granted to allow an account to create the recovery catalog？（）

    • A、 RECOVERY_CATALOG_OWNER
    • B、 DBA
    • C、 RESOURCE
    • D、 SELECT ANY DICTIONARY
    • E、 CONNECT

    正确答案:A,C

  • 第18题：

    单选题
    Which of the following packages maintains information in the recovery catalog？ （）
    A

    DBMS_RCVMAN

    B

    DBMS_RMAN

    C

    DBMS_RCVCAT

    D

    DBMS_CATPROC


    正确答案： A
    解析： 暂无解析

  • 第19题：

    单选题
    You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files： % rman target / What would be the effect of this command？（）
    A

     RMAN would use the current operating system location to place the backup.

    B

     RMAN would use the control file of the target database to maintain the backup.

    C

     RMAN would use the recovery catalog of the target database to maintain the backup.

    D

     RMAN would use the control file of the target database to maintain the backup metadata.

    E

     RMAN would use the recovery catalog of the target database to maintain the backup metadata.


    正确答案： B
    解析： 暂无解析

  • 第20题：

    单选题
    Which of the following roles provides the privileges to maintain and query the recovery catalog schema？（）
    A

    EXECUTE_CATALOG_ROLE

    B

    CONNECT

    C

    RESOURCE

    D

    RECOVERY_CATALOG_OWNER

    E

    RECOVERY_CATALOG_USER


    正确答案： A
    解析： 暂无解析

  • 第21题：

    单选题
    Which of the following commands must be issued to remove a stored script from the recovery catalog？（）
    A

    DELETE SCRIPT

    B

    ERASE SCRIPT

    C

    REMOVE SCRIPT

    D

    UNCATALOG SCRIPT


    正确答案： D
    解析： 暂无解析

  • 第22题：

    单选题
    You want to create the Recovery Manager （RMAN） Virtual Private Catalog （VPC） to maintain a separation of responsibilities along with a consolidation of RMAN repository.  Which condition must be met before you create the VPC？（）
    A

     A base catalog exists

    B

     The recovery catalog is empty

    C

     The base recovery catalog must be dropped

    D

     A target database is registered in the recovery catalog


    正确答案： A
    解析： 暂无解析

  • 第23题：

    单选题
    Which of the following server roles provides a common time to all computers？（）
    A

    NTP

    B

    SNMP

    C

    SMTP

    D

    RAS


    正确答案： A
    解析： 暂无解析

  • 第24题：

    单选题
    Which command do you use to create a recovery-catalog schema? （）
    A

    create recovery catalog 

    B

    create catalog

    C

    build catalog 

    D

    catalog create 

    E

    mount catalog 


    正确答案： A
    解析： 暂无解析

相关内容