单选题Which command do you use to create a recovery-catalog schema? （）A create recovery catalog B create catalogC build catalog D catalog create E mount catalog

第1题：

In a JSP-centric web application， you need to create a catalog browsing JSP page. The catalog is stored asa List object in the catalog attribute of the webapp’s ServletContext object.  Which scriptlet code snippetgives you access to the catalog object？（）

• A、<% List catalog = config.getAttribute（"catalog"）； %>
• B、<% List catalog = context.getAttribute（"catalog"）； %>
• C、<% List catalog = application.getAttribute（"catalog"）； %>
• D、<% List catalog = servletContext.getAttribute（"catalog"）； %>

第2题：

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

第3题：

第4题：

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

第5题：

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

第6题：

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

第7题：

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.

第8题：

You have backed up your database twice without connecting to the recovery catalog. What command do you issue to transfer the control-file metadata to the recovery catalog？（）

• A、 synch catalog
• B、 resync catalog
• C、 replicate catalog
• D、 update catalog
• E、 restore catalog

第9题：

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

第10题：

While performing a regular check on your recovery catalog you realized that the catalog database is running out of space and you do not have options to increase the space. However, you have another database where more space is available and you want to move your existing recovery catalog to this database. The options that can be considered while moving the recovery catalog are as follows:（） 1. Using one of the Oracle expdp utilities to export the catalog data 2. Creating a recovery catalog user and granting the necessary privileges in the other database 3. Creating the recovery catalog using the CREATE CATALOG command 4. Using the corresponding impdp utility to import the catalog data into the other database 5. Registering the target database in the new catalog database using the REGISTER DATABASE command Identify the option with the correct sequence for moving the recovery catalog.

• A、2, 3, 5
• B、1, 2, 4
• C、1, 2, 4, 5
• D、1, 2, 3, 4, 5