单选题How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog？（）AIssue the grant command from the SYS user （or equivalent） of the target database.BIssue the grant command from the SYS user （or equivalent

第1题：

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;

第2题：

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

第3题：

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

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

第4题：

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

第5题：

You want to implement the backup and recovery strategy in your database using Recovery Manager （RMAN）. You have chosen the control file of the target database for the RMAN repository.  Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication？（）

• A、 rman TARGET / NOCATALOG
• B、 rman TARGET sys/password
• C、 rman TARGET sys/password AS SYSDBA
• D、 rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat

第6题：

The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command：  SQL> GRANT SELECT，INSERT，UPDATE ON emp TO scott WITH GRANT OPTION； The user SCOTT executes this command to grant privileges to the user JIM： SQL> GRANT SELECT，INSERT，UPDATE ON hr.emp TO jim；  Now， the user HR decides to revoke privileges from JIM using this command： SQL> REVOKE SELECT，INSERT，UPDATE ON emp FROM jim； Which statement is true after HR issues the REVOKE command（）

• A、The command fails because SCOTT still has privileges.
• B、The command succeeds and privileges are revoked from JIM.
• C、The command fails because HR cannot revoke the privileges from JIM.
• D、The command succeeds and only HR has the privilege to perform the SELECT， INSERT， and UPDATEoperations on the EMP table.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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.

第14题：

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

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

第16题：

You want to create a consumer group， GROUP1， and you execute the following command in the command-line interface：  SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP （CONSUMER_GROUP =>’group1’， COMMENT => ’New Group’）；  This command errorsout displaying the following message：  ERROR at line 1：  ORA-01031： insufficient privileges  ORA-06512： at "SYS.DBMS_RMIN"， line 115  ORA-06512： at SYS.DBMS_RESOURCE_MANAGER"， line 108 ORA-06512： at line 1  What action would you take to overcome this error？（）

• A、 grant SYSDBA to the user
• B、 grant SYSOPER to the user
• C、 grant the RESOURCE role to the user
• D、 use the GRANT command to grant the ADMINISTER_RESOURCE_MANAGER privilege to the use
• E、 grant the ADMINISTER_RESOURCE_MANAGER privilege to the user by using the DBMS_RESOURCE_MANAGER_PRIVS package

第17题：

You have control-file autobackups enabled. When starting your database from SQL*Plus， you receive the following error message：   SQL> startup ORA-01078： failure in processing system parameters LRM-00109：  could not open parameter file ，  C:///ORACLE/PRODUCT/11.1.0/DB_1/DATABASE/INITORCL.ORA Using RMAN，   how would you respond to this error？（）  

• A、 Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.
• B、 Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.
• C、 Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.
• D、 Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.
• E、 Issue the restore spfile from autobackup command from the RMAN prompt.

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：