Examine this configuration:
* CDB1 is a container database.
* PDB1 and PDB2 are pluggable databases in CDB1.
* PDB1 and PDB2 are OPEN in READ WRITE mode.
You execute these commands successfully:

Which two are true? (Choose two.)

• A.Uncommitted transactions in PDB1 have been rolled back.
• B.PDB1 is closed.
• C.Uncommitted transactions in CDB1 and PDB1 have been rolled back.
• D.CDB1 is in MOUNT state
• E.CDB1 is shut down.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about memory advisors? (Choose two.)

• A.If Automatic Memory Management is enabled, the Shared Pool Advisor and Buffer Cache Advisor are available to set the maximum size for these individual System Global Area components.
• B.All memory advisors use data from Automatic Workload Repository.
• C.If Automatic Memory Management is enabled, no memory advisors are available.
• D.If Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor are always available.
• E.If Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer Cache Advisor are available.

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which are the three steps in the SQL tuning process for Oracle Database environments?

• A.Test the application as a whole using tuned SQL statements.
• B.Test tuned SQL statements one at a time for all statements in the application.
• C.Tune SQL statements as a group using the SQL Tuning and SQL Access Advisors.
• D.Identify poorly tuned SQL statements using Automatic Database Diagnostic Monitor.
• E.Tune individual SQL statements using the SQL Tuning Advisor.
• F.Identify poorly tuned SQL statements using the SQL Tuning Advisor.

Comment: *

Name: *

Email: *

Verification: *

For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command? (Choose two.)

• A.to specify a default tablespace in a PDB cloned from another PDB in the same CDB.
• B.to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDB
• C.to exclude a temp tablespace when plugging in a PDB
• D.to specify the list of user tablespaces to include when moving a non-CDB to a PDB
• E.to specify the list of tablespaces to include when creating a PDB from the CDB seed
• F.to include specific user tablespaces only when relocating a PDB

Comment: *

Name: *

Email: *

Verification: *

Examine these queries and their output:

After a system crash, an instance restart and an attempted opening of the PDBs result in:

Which two are true? (Choose two.)

• A.Data file 24 can be recovered while PDB2 is opened.
• B.Data file 24 must be recovered while the CDB is opened.
• C.Data file 24 can be recovered while CDB$ROOT and PDB$SEED are opened.
• D.Data file 24 cannot be recovered while the CDB is opened.
• E.Data file 24 must be recovered while PDB2 is closed.

Comment: *

Name: *

Email: *

Verification: *