Examine the command for creating pluggable database PDB2 in container database CDB2. Select three options, any one of which is required for it to execute successfully. (Choose three.)

• A.Enable only OMF.
• B.Add only the CREATE_FILE_DEST clause to the statement.
• C.Set only the PDB_FILE_NAME_CONVERT parameter.
• D.Set the PDB_FILE_NAME_CONVERT parameter and enable OMF.
• E.Add the FILE_NAME_CONVERT clause to the statement and enable Oracle Managed Files (OMF)
• F.Add the FILE_NAME_CONVERT clause to the statement and set the PDB_FILE_NAME_CONVERT parameter.

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: *

Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)

• A.After the change, any user with the required privilege can create an undo tablespace in the PDBs.
• B.After the change, only one undo tablespace can exist in CDB$ROOT.
• C.Undo tablespaces existing in PDBs must be dropped before the change.
• D.After the change, each existing PDB has to be reopened for the new undo mode to take effect.
• E.After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.
• F.Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about managing memory components in an Oracle database instance? (Choose three.)

• A.Automatic Memory Management must be used together with locking the System Global Area into physical memory.
• B.With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.
• C.With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.
• D.On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.
• E.With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.
• F.Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about Oracle Optimizer Statistics, their use, and their collection?

• A.Statistics collected using DBMS_ATATS always yield the best optimizer result.
• B.The number of table rows is considered when evaluating the cost of accessing a table using an index.
• C.Index balanced B*Tree height is considered when evaluating the cost of using an index,
• D.The Statistics Advisor can help recommend the best way to gather statistics.
• E.The Statistics Advisor generates actions for all recommendations.

Comment: *

Name: *

Email: *

Verification: *