In RMAN， when the RESYNC CATALOG command is issued， in which

第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

第2题：

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.

第3题：

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=/@rcat
• B、 rman target=/ catalog=rcat_own/rcat_own
• C、 rman target=/ catalog=rcat_own/rcat_own@RCAT
• D、 rman target=sys/robert@orcl catalog=rcat_own/rcat_own@RCAT
• E、 You cannot connect to the target database and the recovery catalog at the same time.

第4题：

You issued the following RMAN command：  RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；     What is NOT an impact of using the above command？（）

• A、 When a successful backup is recorded in the RMAN repository， then a backup of the current control file is performed.
• B、 When a structural change is made to the database， then a backup of the current control file is performed.
• C、 When a successful backup is performed in the RMAN repository， then a backup of the spfile is performed.
• D、 When a structural change is made to the database， then a backup of the alert log file will be performed.

第5题：

Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）

• A、 when you change the name of a datafile
• B、 when you drop a table from the database
• C、 when you take an export of the database
• D、 when you back up the database using OS utilities
• E、 when you issue an ALTER SYSTEM SWITCH LOGFILE statement
• F、 when you issue a BACKUP command from inside the RMAN run block

第6题：

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 also want to deregister them from the catalog after import. You executed the following commands to achieve this：   RMAN> CONNECT CATALOG rco11/password@catdb  RMAN> IMPORT CATALOG rcat10/oracle@inst1 DBID=1423241，1423242；   What happens if the RCO11 catalog has scripts with the same name as that of the scripts in RCAT10 catalog？（）

• A、 The scripts in the RCO11 catalog are overwritten.
• B、 RMAN renames the local stored scripts in the RCO11 catalog.
• C、 The RMAN session in which the command is executed aborts.
• D、 RMAN renames the global scripts that are imported from the RCAT10 catalog.

第7题：

You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?（）

• A、Immediately following statement execution 
• B、After the ALTER TABLE DROP UNUSED COLUMNS command is issued 
• C、After the ALTER TABLE SET UNUSED COLUMN command is issued 
• D、After the ALTER TABLE MODIFY command is issued

第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题：

If you back up a database without connecting to the recovery catalog， which operations will cause the recovery catalog to be updated？（）

• A、 The next time you back up the database when you are also connected to the recovery catalog and the target database
• B、 The next time you are connected to the target database and the recovery catalog database and issue the resync command
• C、 The next time you connect RMAN to just the recovery catalog
• D、 The next time you connect to the recovery catalog and the target database with RMAN
• E、 Connecting to the recovery catalog and issuing the resync all databases command

第10题：

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；