APP1 is an application container that has an application seed and two application PDBs, APP_PDB1 and APP_PDB2.

1.0 is the current version of the application. You execute this block in the application root:

What is the outcome?

A. An error is thrown because the version number should be sequential, either 1.1 or 2.0.

B. An error is thrown because the CONTAINER=ALL clause is missing.

C. An error is thrown because the c## prefix is missing in the role name.

D. A common role is created only in the application root.

E. A common role is created only in the application root and application seed.

F. A common role is created in the application root, application seed, APP_PDB1, and APP_PDB2.

Which statement is true about transportable tablespaces?

A. The tablespace data file or data files to be plugged in to the target database cannot have a different block size than any of the source database's data file or files.

B. The cannot be dictionary-managed tablespaces

C. The source tablespace can be encrypted D. They can be administrative tablespaces such as SYSTEM or SYSAUX

Examine these statements:

Which statement is true?

A. Statements 2 and 3 will validate the conversion

B. Only statement 3 will validate the conversion

C. Only statement 1 will validate the conversion

D. Statement 1 will return an error

E. All the statements will validate the conversion

Which three statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose three.)

A. It analyzes only those memory components of the database instance that are impacting performance.

B. It determines the segments on which waits are occurring when the database has a high number of buffer busy waits.

C. It analyzes the performance of the database instance based on the latest two AWR snapshots.

D. It determines SQL statements that are performing poorly.

E. It recommends implementing SQL profiles to generate better execution plans.

F. It analyzes only the components and waits that are impacting database performance.

Which three statements are true about the SQL Performance Analyzer? (Choose three.)

A. It recommends the use of SQL Tuning Advisor for regressed SQL statements.

B. It recommends the creation of indexes for regressed SQL statements.

C. It compares and analyzes execution plans for the SQL statements in a SQL Tuning Set (STS).

D. It always executes triggers that are fired recursively in FULLDML mode.

E. It generates execution plans for each SQL statement in an STS.