Oracle Database 11g Certified Master Upgrade - 11gocmu Exam Questions [2026]

QUESTION NO: 1
You want to use RMAN to create compressed backups.
Which statement is true about the compression algorithms that RMAN can use?

A. The BZIP2 compression algorithm consumes more CPU resources than the ZLIB compression algorithm. B. Only the BZIP2 compression algorithm can be used to make compressed backups to disk. C. The ZLIB compression algorithm provides maximum compression and produces smaller backups than the BZIP2 compression algorithm. D. The ZLIB compression algorithm consumes more CPU resources than the BZIP2 compression algorithm.

Correct Answer: A

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

QUESTION NO: 2
In a database with the database character set of US7ASCII and a national character set of UTF-8, which datatypes would be capable of storing Unicode data by default?

A. CHAR B. CLOB C. LONG D. NVARCHAR2 E. VARCHAR2

Correct Answer: D

QUESTION NO: 3
Which NLS parameter directly governs linguistic searches?

A. NLS_SORT B. NLS_SEARCH_L C. NLS_SEARCH D. None of the above E. NLS_SORT_L

Correct Answer: A

QUESTION NO: 4
When you create a backup control file, where is the resulting file written to?

A. To the directory and filename you specify in the command B. To $ORACLE_HOME/rdbms C. To $ORACLE_HOME/admin D. The database user dump destination directory E. The database diagnostic destination directory

Correct Answer: A

QUESTION NO: 5
Evaluate the following statements:
CREATE TABLE purchase_orders
(po_id NUMBER(4),
po_date TIMESTAMP,
supplier_id NUMBER(6),
po_total NUMBER(8,2),
CONSTRAINT order_pk PRIMARY KEY(po_id))
PARTITION BY RANGE(po_date)
(PARTITION Q1 VALUES LESS THAN (TO_DATE(?1-apr-2007?d-mon-yyyy?),
PARTITION Q2 VALUES LESS THAN (TO_DATE(?1-jul-2007?d-mon-yyyy?),
PARTITION Q3 VALUES LESS THAN (TO_DATE(?1-oct -2007?d-mon-yyyy?),
PARTITION Q4 VALUES LESS THAN (TO_DATE(?1-jan-2008?d-mon-yyyy?));
CREATE TABLE purchase_order_items
(po_id NUMBER(4) NOT NULL,
product_id NUMBER(6) NOT NULL,
unit_price NUMBER(8,2),
quantity NUMBER(8),
CONSTRAINT po_items_fk
FOREIGN KEY (po_id) REFERENCES purchase_orders(po_id))
PARTITION BY REFERENCE(po_items_fk);
What are the two consequences of the above statements? (Choose two.)

A. Partition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table. B. Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each. C. Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table. D. The PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns. E. Partitions of PURCHASE_ORDER_ITEMS have system-generated names.

Correct Answer: B,C

QUESTION NO: 6
Examine the following PL/SQL block:
SET SERVEROUTPUT ON
SET LONG 10000
ECLARE report clob;
BEGIN
report := DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE();
DBMS_OUTPUT.PUT_LINE(report);
END;
Which statement describes the effect of the execution of the above PL/SQL block?

A. All the nonaccepted SQL profiles are accepted into the plan baseline. B. The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines. C. All fixed plan baselines are converted into nonfixed plan baselines. D. The plan baselines are verified with the SQL profiles.

Correct Answer: B

QUESTION NO: 7

View the Exhibit to examine the details for an incident.
Which statement is true regarding the status of the incident?

A. The DBA is working on the incident and prefers that the incident be kept in the ADR. B. The data collection for the incident is complete and the incident can be packaged and
sent to Oracle Support. C. The incident is now in the Done state and the ADR can select the incident to be purged. D. The incident has been newly created and is in the process of collecting diagnostic information.

Correct Answer: B

QUESTION NO: 8
You executed the following commands:
SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false;
SQL> EXECUTE DBMS_STATS.SET_TABLE_PREFS('SH', 'CUSTOMERS', 'PUBLISH','false');
SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS('SH', 'CUSTOMERS');
Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?

A. The statistics are temporary and used by the optimizer for all sessions until this session terminates. B. The statistics are treated as the current statistics by the optimizer for the current sessions only. C. The statistics are stored in the pending statistics table in the data dictionary. D. The statistics are treated as the current statistics by the optimizer for all sessions.

Correct Answer: C

QUESTION NO: 9
You issue the following command on the RMAN prompt.
REPORT NEED BACKUP DAYS 5;
Which statement is true about executing this command?

A. It will display a list of files that were backed up in the last five days B. It will apply the current retention policy to determine the files that need to be backed up C. It will display a list of files that have not been backed up in the last five days D. It will display a list of files that need incremental backup E. It will display a list of files that need backup after five days

Correct Answer: C

QUESTION NO: 10
An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command:
SQL>CREATE INDEX ord_custname_ix ON orders(custname);
The ORDERS table is frequently queried using the CUSTNAME column in the WHERE
clause.
You want to check the impact on the performance of the queries if the index is not
available. You do not want the index to be dropped or rebuilt to perform this test.
Which is the most efficient method of performing this task?

A. disabling the index B. making the index unusable C. using the MONITORING USAGE clause for the index D. making the index invisible

Correct Answer: D

QUESTION NO: 11
The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?

A. Allow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfiles B. Allow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfile C. Allow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted. D. Shut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGS

Correct Answer: C

QUESTION NO: 12
What is the correct order of the following commands if you wanted to restore datafile 4,
which was accidentally removed from the file system?
a.sql 'alter database datafile 4 online';
b.restore datafile 4;
c.recover datafile 4;
d.sql 'alter database datafile 4 offline';
e.startup
f.shutdown

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

Correct Answer: E

QUESTION NO: 13
You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database.
What must you do accomplish this task?

A. Create Flashback Data Archive in the tablespace where the tables are stored. B. Create Flashback Data Archive and enable Flashback Data Archive for specific tables C. Specify undo retention guarantee for the database D. Enable supplemental logging for the database.

Correct Answer: B

QUESTION NO: 14
Which of the following describes how a distributed resumable transaction behaves?

A. None of the above. B. The resumable setting on the initiating session determines the resumable conditions for the entire distributed transaction. C. The resumable setting for the initiating instance determines the resumable conditions for the entire distributed transaction. D. The resumable setting on the initiating session controls only that part of the transaction that occurs within the local instance; remote resumable settings determine the behavior of the distributed parts of the transaction.

Correct Answer: D