You have configured RMAN SBT channels to write backups to media.
You then take an RMAN backup by using this command:

Which three are true? (Choose three.)

• A.The control file is included in the self-contained archival backup.
• B.The restore point is a label for the system change number (SCN) before the archival backup was taken.
• C.The restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.
• D.All archive logs created after this backup are kept for two years.
• E.The SPFILE is included in the self-contaied archival backup.
• F.The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.

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.Set the pdb_file_name_convert parameter and enable OMF.
• B.Add only the create_file_dest clause to the statement.
• C.Add the file_mame_comvert clause to the statement and enable Oracle Managed Files (OMF).
• D.Enable only OMF.
• E.Add the file_name_convert clause to the statement and set the pdb_file_name_convert parameter.
• F.Set only the pdb_file_name_convert parameter.

Comment: *

Name: *

Email: *

Verification: *

Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)

• A.It recompiles all stored PL/SQL code by using utlrp.sql.
• B.It empties the RECYCLE BIN.
• C.It performs prerequisite checks to verify if the Oracle database is ready for upgrade.
• D.It sets all user tablespaces to "read-only" before starting the upgrade.
• E.It removes the AUDSYS schema and the AUDIT_ADMIN and AUDIT_VIEWER roles
• F.It increases tablespace size, if required, to meet upgrade requirements.

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:
1. CDB1 is a container database.
2. PDB1 and PDB2 are pluggable databases in CDB1.
3. 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.CDB1 is shut down.
• C.PDB1 is closed.
• D.Uncommitted transactions in CDB1 and PDB1 have been rolled back.
• E.CDB1 is in MOUNT state

Comment: *

Name: *

Email: *

Verification: *

Which two are true about server-generated alerts? (Choose two.)

• A.Stateless alerts can be purged manually from the alert history.
• B.Stateless alerts are automatically cleared.
• C.Stateless alerts can be cleared manually.
• D.Stateful alerts are purged automatically from the alert history.
• E.Stateful alerts must be created by a DBA after resolving the problem.

Comment: *

Name: *

Email: *

Verification: *