Oracle Database 11g Certified Master Upgrade Exam (11gocmu) Free Practice Test

Question 1

Choose the correct order to package and upload data for an incident to Oracle Support.

A. Create new package, view manifest, view contents, schedule

B. Schedule, create new package, view contents, view manifest

C. None of the above.

D. Create new package, view contents, view manifest, schedule

E. Schedule, create new package, view manifest, view contents

Correct Answer: D

Question 2

What is the purpose of the RMAN recovery catalog? (Choose all that apply.)

A. It provides a means of storing all RMAN backup sets physically in an Oracle database server.

B. It provides the ability to store RMAN scripts for global use by any database that has access to the repository.

C. It provides the ability to store backup records for more than a year.

D. It must be used because all RMAN-related backup and recovery metadata information is contained in it.

E. It provides a convenient, optional, repository of backup- and recovery-related metadata.

Correct Answer: B,C,E

Question 3

You issue the following command:
RMAN>CONFIGURE BACKUP OPTIMIZATION ON;
What is the result of this command on your backups?

A. RMAN will configure itself for maximum performance at the cost of CPU.

B. RMAN will automatically compress backups.

C. Read-only datafiles will not be backed up as long as backups of those files already exist and those backups meet established retention criteria.

D. RMAN will configure itself for minimal OS/CPU impact at the cost of time to back up the database.

E. An incremental backup strategy will be used automatically.

Correct Answer: C

Question 4

Which of the following methods can be used to detect block corruption?

A. dbv

B. All of the above

C. SQL queries that access the potentially corrupt block

D. ANALYZE operations

E. RMAN

Correct Answer: B

Question 5

The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?

A. to allow the Automated Maintenance Tasks to use system resources without any restriction

B. to allow resource sharing only among the Automated Maintenance Tasks in the maintenance window

C. to prevent the creation of an excessive number of scheduler job classes

D. to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources

Correct Answer: D

Question 6

ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?

A. The data is decrypted during SORT and JOIN operations.

B. The data remains encrypted when it is stored in the redo logs.

C. The data remains encrypted when it is read into memory.

D. The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.

Correct Answer: B

Question 7

Which three are the valid statements in relation to SQL plan baselines? (Choose three.)

A. The plans generated for every SQL statement are stored in the SQL plan baseline by default.

B. The plans can be manually loaded to the SQL plan baseline.

C. The plans in the SQL plan baseline are verified and accepted plans.

D. The plan baselines are stored temporarily in the memory as long as the database instance is running.

E. For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online.

Correct Answer: B,C,E

Question 8

How many individual archive-log destination directories are supported by Oracle Database11g?

A. 7

B. 21

C. 1

D. 10

E. 11

Correct Answer: D

Question 9

Which of these are valid Flashback Database recovery point parameters? (Choose all that apply.)

A. Timestamp

B. Named recovery point

C. Transaction ID

D. SCN

E. Session ID

Correct Answer: A,B,D

Question 10

You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script:
SQL>@utlu111i.sql
Which statement about the execution of this script is true?

A. It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

B. It must be executed from the Oracle Database 11g environment.

C. It must be executed from the environment of the database that is being upgraded.

D. It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.

E. It must be executed only after the SYSAUX tablespace has been created.

Correct Answer: C

Question 11

Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN. (Choose all that apply.)

A. Backup retention policy

B. Default backup device type

C. Multiple backup device types for single backup

D. Default destinations for backups

E. Default section size for backups

Correct Answer: A,B,D

Question 12

View the exhibit and examine the TRANS table's storage information.
After a massive delete operation, you executed the following statement to shrink the
TRANS table:
SQL> ALTER TABLE trans SHRINK SPACE CASCADE;
Which statement describes the outcome of the command?
Exhibit:

A. An error is produced.

B. The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchanged

C. The table and all related objects are compacted and the position of the high-water mark (HWM) for the table is adjusted

D. The unused space in the table is reclaimed and returned to the tablespace and the data manipulation language (DML) triggers on the table are fired during the shrinking process

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 13

View the Exhibit to examine the output for the V$DIAG_INFO view.
Which statements are true regarding the location of diagnostic traces? (Choose all that apply.)

A. The path to the location of the background as well as the foreground process trace files is /u01/oracle/diag/rdbms/orclbi/orclbi/trace.

B. The location of the XML-formatted version of the alert log is /u01/oracle/diag/rdbms/orclbi/orclbi/alert.

C. The location of the text alert log file is /u01/oracle/diag/rdbms/orclbi/orclbi/alert.

D. The location of the trace file for the current session is /u01/oracle/diag/rdbms/orclbi/orclbi/trace.

Correct Answer: A,B,D

Question 14

You work with a newly created database. Presently, there is no application load on the database instance. You want to create a baseline for tuning the application, so you decide to collect recommendations that can be implemented to improve application performance.
What action must you take to achieve this?

A. Run Segment Advisor

B. Run the SQL Tuning Advisor (STA)

C. Run the SQL Access Advisor with a hypothetical workload

D. Run the Automatic Workload Repository (AWR) report

Correct Answer: C

Welcome to TestSimulate

Oracle Database 11g Certified Master Upgrade (11gocmu) Free Practice Test