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

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

Comment: *

Name: *

Email: *

Verification: *

Which two are true about Recovery Manager (RMAN) diagnostic message output? (Choose two.)

• A.The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only.
• B.RMAN error stacks should be read from the top down as that is the order in which errors are generated.
• C.The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file and to standard output.
• D.RMAN error stacks should be read from the bottom up as that is the order in which errors are generated.
• E.Media Management messages for SBT devices are written to an Oracle trace file.
• F.Media Management messages for SBT devices are always written to sbtio.log.

Comment: *

Name: *

Email: *

Verification: *

Choose two. Which two are true about various Oracle security and auditing capabilities?

• A.Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container when they are updated.
• B.Application-common OLS policies can be created only if all the PDBs in the application container are closed.
• C.Unified auditing can be automatically synchronized to all application PDBs in an application container.
• D.Application-common Transparent Security Data Protection (TSDP) policies can be created only if all the PDBs in the application container are closed.
• E.Application-common TSDP policies are always container specific.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Optimizer Statistics Advisor? (Choose three.)

• A.It can be run only manually.
• B.It is part of the DBMS_ADVISOR package.
• C.It can recommend changes to improve the statistics gathering process.
• D.It always analyzes all schemas in the database.
• E.It runs automatically every night by default.
• F.It is part of the DBMS_STATS package.

Comment: *

Name: *

Email: *

Verification: *

Examine this command for creating pluggable database PDB2 in container database CDB2 CREATE PLUGGABLE DATABASE pdb2 ADMIN USER pdb2_adrn IDENTIFIED BY 12 3pdb ROLES=(CONNECT) ; Select three options, any one of which is required for it to execute successfully.

• A.Enable only OMF.
• B.Add the file_mame_comvert clause to the statement and enable Oracle Managed Files (OMF).
• C.Set the pdb_file_name_convert parameter and enable OMF.
• D.Set only the pdb_file_name_convert parameter.
• E.Add the file_name_convert clause to the statement and set the pdb_file_name_convert parameter.
• F.Add only the create_file_dest clause to the statement.

Comment: *

Name: *

Email: *

Verification: *