单选题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 equiva

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

You are the DBA for an academic database. You need to create a role that allows a group of users to modify existing rows in the STUDENT_GRADES table.Which set of statements accomplishes this?（）

• A、CREATE ROLL registrar; GRANT MODIFY ON student_grant TO registrar; GRANT registrar to user 1, user2, user3
• B、CREATE NEW ROLE registrar; GRANT ALL ON student_grant TO registrar; GRANT registrar to user 1, user2, user3
• C、CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT ROLE to user1, user2, user3
• D、CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT registrar to user 1, user2, user3;
• E、CREATE registrar; GRANT CHANGE ON student_grant TO registrar; GRANT registrar;

第3题：

第4题：

To allocate another role to a user, which command is most appropriate?（）

• A、ALTER USER 
• B、ALTER DATABASE 
• C、ALTER SYSTEM 
• D、GRANT

第5题：

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

第6题：

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.

第7题：

You are ready to implement RMAN in the backup and recover strategy for your company. Which system privilege must the RMAN user have to be able to connect and execute RMAN commands on a target database？（）

• A、SYSDBA
• B、SYSOPER
• C、No system privileges are required for the RMAN user.
• D、Only SYS user can connect and execute RMAN commands on a target database.

第8题：

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.

第9题：

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

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