Oracle Database 11g Certified Master Upgrade Sample Questions:

1. Which statements are true regarding the creation of an incident package file by using the EM Workbench Support? (Choose all that apply.)

A) You can add or remove the trace files to the package.
B) You can add SQL test cases to the incident package.
C) You cannot create an incremental incident package when the physical files are purged rom the ADR.
D) You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.

2. Given two different character sets (A and B), which of the following must be true for A to be considered a strict superset of B? (Choose all that apply.)

A) A must be Unicode.
B) A must contain all of the characters defined in B.
C) The encoded values in A must match the encoded values in B for all characters defined in B.
D) A must be a multibyte character set.
E) The encoded values in A must match the encoded values in B for all numeric and alphabetic characters in B.

3. Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)? (Choose three.)

A) Recovery Manager (RMAN) backup piece
B) Archived redo log files
C) Server Parameter file (SPFILE)
D) Control file autobackups
E) Alert log file

4. The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed?

A) The Oracle database will perform block checking for the index blocks only
B) The Oracle database will perform block checking for the default permanent tablespace only
C) The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only
D) The Oracle database will perform block checking for the data blocks in all user tablespaces
E) The Oracle database will not perform block checking for any of the data blocks

5. View the Exhibit exhibit1 to examine the series of SQL commands.
View the Exhibit exhibit2 to examine the plans available in the SQL plan baseline. The baseline in the first row of the Exhibit is created when OPTIMIZER_MODE was set to FIRST_ROWS.
Which statement is true if the SQL query in exhibit1 is executed again when the value of OPTIMIZER_MODE is set to FIRST_ROWS?

A) The optimizer uses the plan in the first row of the exhibit2 because OPTIMIZER_MODE was set to FIRST_ROW during its creation.
B) The optimizer uses a new plan because none of the plans in the exhibit2 are fixed plans.
C) The optimizer uses the plan in the first row of the exhibit2 because it is the latest generated plan.
D) The optimizer uses the plan in the second row of the exhibit2 because it is an accepted plan.

Solutions: