Oracle Database 11g Certified Master Upgrade 認定 11gocmu 試験問題:

1. You issue the following RMAN command to set a retention policy on a database:
RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
What will be the outcome of issuing this command?

A) If the RMAN repository has records of two or more recent backups of a file, then older backups will be deleted from the media.
B) After two days, a backup will be deleted from the media
C) After two days, a backup will be marked obsolete
D) If the RMAN repository has records of two or more recent backups of a file, then older backups will be marked obsolete.

2. Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:
SQL> SELECT * FROM sales;
Which process would retrieve the result from the database and return it to the client program?

A) Checkpoint process (CKPT)
B) Server process
C) User process
D) System Monitor (SMON)
E) Process Monitor (PMON)

3. Your ARCHIVELOG-mode database has lost three datafiles and shut down. One is assigned to the SYSTEM tablespace and two are assigned to the USERS tablespace. You can choose from the following steps to recover your database:
a.Restore the three database datafiles that were lost.
b.Issue the Startup Mount command to mount the database.
c.Issue the alter database open command.
d.Issue the alter database open resetlogs command.
e.Recover the database using the recover database command.
f.Recover the datafiles with the recover datafile command.
g.Take the datafiles offline.
Which is the correct order of these steps in this case?

A) a, b, d, c
B) a, b, d, f
C) a, b, e, c
D) b, e, d
E) b, g, c, f

4. 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.

5. Which option is best practice for creating a recovery catalog owner in the catalog database?

A) Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user
B) Creating a new tablespace, allocating this as the default, and granting UNLIMITED QUOTA on this tablespace to the user
C) Granting UNLIMITED QUOTA on the SYSTEM tablespace to the owner
D) Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the user

質問と回答：