Examine this configuration:
1. CDB1 is an Oracle Database 12c Release 2 container database (CDB).
2. PDB1 and PDB2 are two pluggable databases (PDBs) in CDB1.
After successfully performing all the preupgrade tasks, you execute these commands from the Oracle Database 18c environment:
What is the outcome?

• A.It fails because PDB2 is not in UPGRADE state.
• B.Only CDB$ROOT, PDB$SEED, and PDB1 are upgraded.
• C.Only CDB$ROOT and PDB$SEED are upgraded.
• D.CDB$ROOT, PDB$SEED, PDB1, and PDB2 are upgraded.
• E.Only CDB$ROOT, PDB$SEED, and PDB2 are upgraded.
• F.It fails because PDB$SEED is in MIGRATE state.

Comment: *

Name: *

Email: *

Verification: *

You are managing this configuration:
CDB1 is a container database.
PDB1 and PDB2 are two pluggable databases in CDB1.
USER1.EMP is a table in PDB1 and USER2.DEPT is a table in PDB2.
CDB1 user SYS executes these commands after connecting successfully to PDB2:

Which two are true? (Choose two.)

• A.The insert on USER2.DEPT is uncommitted.
• B.The inserts on USER1.EMP were committed when the session inserted a row into USER2.DEPT.
• C.The insert on USER2.DEPT fails because of the active transaction in the parent container.
• D.The inserts on USER1.EMP were committed when the session connected to PDB2.
• E.The inserts on USER1.EMP remain uncommitted when the session connected to PDB2.
• F.The inserts on USER1.EMP were rolled back when the session connected to PDB2.
• G.The insert on USER2.DEPT is a recursive autonomous transaction by the child session and is committed.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about the Automatic Database Diasnostic Monitor (ADDM)? (Choose two.)

• A.It runs automatically after each AWR snapshot.
• B.It analyzes a period of time corresponding to the last day of activity.
• C.It analyzes a period of time corresponding to the 12 hours of activity.
• D.A DBA can run it manually.
• E.Results are written to the alert log.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about a Recovery Manager (RMAN) duplication without a target connection?

• A.The undo tablespace clause is always required when no connection exists to the target instance.
• B.RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.
• C.RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.
• D.RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.
• E.The undo tablespace clause is always required when no connection exists to the recovery catalog and the target database is closed.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about gathering optimizer statistics? (Choose two.)

• A.Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open PDBs except PDB$SEED.
• B.Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/write mode gathers object statistics for that PDB.
• C.Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.
• D.System statistics can be gathered only while connected to CDB$ROOT.
• E.Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs)

Comment: *

Name: *

Email: *

Verification: *