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.Uncommitted transactions in CDB1 and PDB1 have been rolled back.
• C.CDB1 is in MOUNT state
• D.PDB1 is closed.
• E.CDB1 is shut down.

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 a temp tablespace when plugging in a PDB
• C.to specify the list of user tablespaces to include when moving a non-CDB to a PDB
• D.to include specific user tablespaces only when relocating a PDB
• E.to exclude all tablespaces except SYSTEM, SYSAUX, and TEMPwhen plugging in a PDB
• F.to specify the list oftablespaces to include when creating a PDB from the CDB seed

Comment: *

Name: *

Email: *

Verification: *

choose two Which two statements are true about encrypted backups performed by using RMAN?

• A.Encrypted backups can only be written to disk.
• B.A database uses the same encryption key for every encrypted backup.
• C.A password encryption of backups uses the password while creating and restoring backups.
• D.Image copy backups can be created by using password encryption.
• E.Transparent encryption of backups uses an encryption wallet.

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 must be recovered while PDB2 is closed.
• B.Data file 24 can be recovered while PDB2 is opened.
• C.Data file 24 must be recovered while the CDB is opened.
• D.Data file 24 cannot be recovered while the CDB is opened.
• E.Data file 24 can be recovered while CDB$ROOT and PDB$SEED are opened.

Comment: *

Name: *

Email: *

Verification: *

Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?

• A.It is a set of recommendations by the optimizer to restructure a SQL statement to avoid suboptimal execution plans.
• B.It is a set of recommendations by the optimizer to change the access methods used.
• C.It is auxiliary information collected by the optimizer for a SQL statement to eliminate estimation error.
• D.It is auxiliary information collected by the optimizer for a SQL statement to help use better joins orders.
• E.It is a set of recommendations by the optimizer to create new indexes.

Comment: *

Name: *

Email: *

Verification: *