Oracle 11gocmu Actual Free Exam Questions & Community Discussion

Exam Code/Number: 11gocmu
Exam Name/Title: Oracle Database 11g Certified Master Upgrade Exam
Certification Provider: Oracle
Corresponding Certification: Oracle Database 11g

Exam Questions: 673
Updated On: Aug 08, 2026

Question #33

The user SYS creates a job by using the following command:

Which two statements are true about the job that was created by the preceding command? (Choose two.)

A. The job is enabled by default after creation

B. The job is automatically dropped after the end date

C. The globalization environment that exists at the time of the job creation prevails at the job runs

D. The job executes with the privileges of the user SYS

Discussion 0

Correct Answer: B,D Vote an answer

Question #34

Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?

A. It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.

B. It returns space usage of only SecureFile LOB chunks.

C. It returns space usage of only BasicFile LOB chunks.

D. It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.

Discussion 0

Correct Answer: B Vote an answer

Question #35

A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger, which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression?

A. backup as compressed backupset database;

B. backup as compressed backup database plus archivelog all;

C. backup as compressed backupset database plus compress archivelog all;

D. backup compressed database

E. backup database all

Discussion 0

Correct Answer: A Vote an answer

Question #36

When running the tablespace point-in-time command
recover tablespace users
until time '10/06/2008:22:42:00'
auxiliary destination 'c:\oracle\auxiliary';
you receive the following error:
RMAN-00571:
===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
===============
RMAN-00571:
===========================================================
RMAN-03002: failure of recover command at 10/08/2008 16:00:30
RMAN-20202: Tablespace not found in the recovery catalog
RMAN-06019: could not translate tablespace name "USERS"
What is the likely cause of the error?

A. The USERS tablespace is not eligible for TSPITR because it has invalid objects.

B. The database is in ARCHIVELOG mode.

C. The USERS tablespace has dependent objects in other tablespaces and can not be a part of a TSPITR alone.

D. The recover tablespace command is incorrect and generates the error.

E. There is not a current backup of the database available.

Discussion 0

Correct Answer: E Vote an answer

Question #37

When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this? (Choose two.)

A. Only the changes in the execution plan, and not performance regression, are detected.

B. It automatically calls the SQL Tuning Advisor for recommendations.

C. It produces less accurate results of the comparison analysis.

D. It shortens the time of execution and reduces the impact on system resources.

Discussion 0

Correct Answer: C,D Vote an answer

Question #38

What is the proper command to shut down the database in a consistent manner?

A. Shutdown abort

B. Shutdown nowait

C. shutdown halt

D. shutdown immediate

E. Shutdown kill

Discussion 0

Correct Answer: D Vote an answer

Question #39

View the Exhibit and examine the steps that you executed to create a database resource
plan. Subsequently, you execute the following procedure which results in an error:
SQL> EXECUTE dbms_resources_manager.validate_pending_area ( );
What could be the reason?
Exhibit:

A. The procedure must be executed before creating the resources plan directive

B. The OTHER_GROUPS resources consumer group is not included in the resource plan directive

C. The SYS_GROUP resource consumer group is not included in the resource plan directive

D. The pending area is automatically submitted after the plan creation

Discussion 0

Correct Answer: B Vote an answer

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

Question #40

View the Exhibit for the object interdependency diagram.
The PRODUCTS table is used to create the PRODCAT_VW view.
PRODCAT_VW is used in the GET_DATA procedure.
GET_DATA is called in the CHECK_DATA function.
A new column PROD_QTY is added to the PRODUCTS table.
How does this impact the status of the dependent objects?

A. Only the view becomes invalid and gets automatically revalidated the next time it is used.

B. All dependent objects remain valid.

C. Only the procedure and function become invalid and get automatically revalidated the next time they are called.

D. Only the procedure and function become invalid and must be recompiled.

Discussion 0

Correct Answer: B Vote an answer

Download Free Oracle 11gocmu Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 11gocmu exam.