单选题In what order would you execute the following steps to create a recovery catalog？（） a.Issue the create catalog command.  b.Create the recovery-catalog database.  c.Create the recovery-catalog user.  d.Grant the recovery_catalog_owner privilege to the r

题目
单选题
In what order would you execute the following steps to create a recovery catalog？（） a.Issue the create catalog command.  b.Create the recovery-catalog database.  c.Create the recovery-catalog user.  d.Grant the recovery_catalog_owner privilege to the recovery-catalog user.  e.Issue the register database command from the target database.
A

a，b，c，d，e

B

b，a，d，c，e

C

b，c，d，a，e

D

b，c，d，e，a

E

b，d，c，a，e

相似考题

1.You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables:What is the outcome of the above commands?（）A. They execute and create a virtual catalog for pre-Oracle 11g clients.B. They produce an error because PROD1 and PROD2 databases belong to the older version.C. They produce an error because you need to connect as CATOWNER to execute this packaged procedure.D. They produce an error because you need to connect to the target database to execute this packaged procedure.

2. Which is the correct way to connect to both the target database and the recovery catalog from the RMAN command line？（） Assume that the target database is called ORCL and that the recovery catalog database is called RCAT. Also assume that the recovery-catalog owner is called RCAT_OWN. Assume the environment is configured for the ORCL database. A、 rman target=/ catalog=/@rcatB、 rman target=/ catalog=rcat_own/rcat_ownC、 rman target=/ catalog=rcat_own/rcat_own@RCATD、 rman target=sys/robert@orcl catalog=rcat_own/rcat_own@RCATE、 You cannot connect to the target database and the recovery catalog at the same time.

3.The RVPC user can do which of the following？（）A、 Register databases if granted the register database privilegeB、 See all databases in the recovery-catalog schemaC、 See all database-related metadata in the recovery catalog if they are granted access to that databaseD、 Unregister databases from the RVPC catalog that were not granted to the RVPC catalog owner with  the grant commandE、 Not be connected to with the RMAN command-line catalog parameter for backup or recovery purposes

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

更多“单选题In what order would you execute the following steps to create a recovery catalog？（） a.Issue the create catalog command.  b.Create the recovery-catalog database.  c.Create the recovery-catalog user.  d.Grant the recovery_catalog_owner privilege to the r”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    What RMAN command must you use before you can back up a database using the recovery catalog？（）

    • A、 create catalog
    • B、 install database
    • C、 catalog database
    • D、 merge Catalog with database
    • E、 register database

    正确答案:E

  • 第4题：

    Which statement is true regarding virtual private catalogs? （）

    • A、A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script. 
    • B、The virtual private catalog owner cannot create and modify the stored scripts. 
    • C、The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner. 
    • D、To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database. 

    正确答案:D

  • 第5题：

    Which statement about using RMAN stored scripts is true？（）  

    • A、 To create and execute an RMAN stored script，you must use a recovery catalog.
    • B、 When executing a stored script and a command fails，the remainder of the script is executed，and a message is written to the alert log file.
    • C、 RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.
    • D、 When you execute a stored script，it always executes using the persistent channel settings previously set with the CONFIGURE command.

    正确答案:A

  • 第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

    正确答案:A,C

  • 第7题：

    单选题
    Which statement about using RMAN stored scripts is true？（）
    A

     To create and execute an RMAN stored script，you must use a recovery catalog.

    B

     When executing a stored script and a command fails，the remainder of the script is executed，and a message is written to the alert log file.

    C

     RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.

    D

     When you execute a stored script，it always executes using the persistent channel settings previously set with the CONFIGURE command.


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

  • 第8题：

    单选题
    What RMAN command must you use before you can back up a database using the recovery catalog？（）
    A

     create catalog

    B

     install database

    C

     catalog database

    D

     merge Catalog with database

    E

     register database


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

  • 第9题：

    单选题
    In what order would you execute the following steps to create a recovery catalog？（） a.Issue the create catalog command.  b.Create the recovery-catalog database.  c.Create the recovery-catalog user.  d.Grant the recovery_catalog_owner privilege to the recovery-catalog user.  e.Issue the register database command from the target database.
    A

    a，b，c，d，e

    B

    b，a，d，c，e

    C

    b，c，d，a，e

    D

    b，c，d，e，a

    E

    b，d，c，a，e


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

  • 第10题：

    单选题
    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
    解析： 暂无解析

  • 第11题：

    单选题
    Why would you execute the report obsolete command？（）
    A

     To list all backups that were no longer available for restore operations

    B

     To list all backups that had aged beyond the RMAN retention criteria

    C

     To list all backup set pieces listed in control-file or recovery-catalog metadata that are not on the backup media

    D

     To list all datafiles that are no longer part of the database and thus do not need to be backed up

    E

     To list all archived redo logs that are no longer needed for any database recovery


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

  • 第12题：

    单选题
    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
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    What is the purpose of the catalog command？（）  

    • A、 To review RMAN control file and recovery catalog metadata and ensure that its correct
    • B、 To delete RMAN backup-related metadata from the recovery catalog
    • C、 To create metadata in the control file and the recovery catalog related to backup set pieces 
    • D、 To create a report that lists database backups
    • E、 To rebuild the recovery catalog

    正确答案:C

  • 第15题：

    You are creating a recovery catalog for use with RMAN. You have issued these commands： SQL> CREATE TABLESPACE rman_ts DATAFILE  ’/DISK1/rman_ts01.dbf’ 2> SIZE 20M 3> DEFAULT STORAGE （initial 100K next 100K pctincrease 0）； SQL> CREATE USER rman_db01 IDENTIFIED BY rman_db01 2> DEFAULT TABLESPACE rman_ts 3> QUOTA unlimited ON rman_ts；  Which command should you issue next？（）

    • A、RESYNC CATALOG；
    • B、REGISTER DATABASE；
    • C、CREATE CATALOG TABLESPACE rman_ts；
    • D、GRANT recovery_catalog_owner TO rman_db01；

    正确答案:C

  • 第16题：

    In what order would you execute the following steps to create a recovery catalog？（） a.Issue the create catalog command.  b.Create the recovery-catalog database.  c.Create the recovery-catalog user.  d.Grant the recovery_catalog_owner privilege to the recovery-catalog user.  e.Issue the register database command from the target database.

    • A、a，b，c，d，e
    • B、b，a，d，c，e
    • C、b，c，d，a，e
    • D、b，c，d，e，a
    • E、b，d，c，a，e

    正确答案:C

  • 第17题：

    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

  • 第18题：

    多选题
    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
    解析： 暂无解析

  • 第19题：

    单选题
    What is the purpose of the catalog command？（）
    A

     To review RMAN control file and recovery catalog metadata and ensure that its correct

    B

     To delete RMAN backup-related metadata from the recovery catalog

    C

     To create metadata in the control file and the recovery catalog related to backup set pieces 

    D

     To create a report that lists database backups

    E

     To rebuild the recovery catalog


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

  • 第20题：

    单选题
    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
    解析： 暂无解析

  • 第21题：

    单选题
    Which statement is true regarding virtual private catalogs？（）
    A

     A virtual private catalog owner can create a local stored script， and have read/write access to a global stored script.

    B

     The virtual private catalog owner cannot create and modify the stored scripts.

    C

     The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.

    D

     To perform most of the RMAN operations， the virtual catalog owner must have the SYSDBA or  SYSOPER privilege on the target database.


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

  • 第22题：

    单选题
    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
    解析： 暂无解析

  • 第23题：

    单选题
    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
    解析： 暂无解析

  • 第24题：

    单选题
    The following databases are registered in the base recovery catalog： PROD1， PROD2， and PROD3. The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog. Given below are some of the commands required to achieve this：   1.SQL> GRANT recovery_catalog_owner TO vpc1； 2.RMAN> CONNECT CATALOG vpc1/password@catdb；  3.RMAN> GRANT CATALOG FOR DATABASE prod1 TO vpc1； 4.RMAN> CONNECT CATALOG catowner/password@catdb；  5.RMAN> CREATE VIRTUAL CATALOG；   What is the correct sequence in which the commands have to be executed？（）
    A

     1，4，5，2，3

    B

     1，4，3，2，5

    C

     4，5，2，3，1

    D

     2，3，4，5，1

    E

     1，4，2，3，5


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

相关内容