Oracle Managed Files (OMF) is enabled in a CDB and this command is successfully executed:

Which three are true? (Choose three.)

• A.Application PDBs that are subsequently created in the APP1application container will be cloned from APP1$SEED.
• B.An application root PDB is created for APP1.
• C.A default service is created for the application root APP1.
• D.An application seed PDB is created for APP1.
• E.APP1can never be unplugged.
• F.Application PDBs that are subsequently created in the APP1 application container will be cloned from PDB$SEED.

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which three are true about using an RMAN Recovery Catalog with a pluggable database (PDB) target connection in Oracle Database 19c and later releases?

• A.The target PDB must be registered in both the base catalog and the Virtual Private Catalog.
• B.The target PDB must be registered in a Virtual Private Catalog.
• C.The base catalog must be used by RMAN when performing point-in-time recovery for the PDB registered in the Virtual Private Catalog.
• D.The base catalog owner must give the Virtual Private Catalog access to metadata for one or more PDBs.
• E.The base catalog must be enabled for Virtual Private Catalog use.
• F.The target PDB must be registered in a base catalog.

Comment: *

Name: *

Email: *

Verification: *

Examine this output:

Which two are true? (Choose two.)

• A.PDB2is guaranteed at least 25% of the available parallel execution processes if there is enough demand.
• B.Any PDB not specified in the plan will be unable to execute statements in parallel.
• C.PDB1is always limited to 40% of the available system resources regardless of demand.
• D.Any PDB not specified in the plan will be able to use a maximum of 16.5% of the available system resources.
• E.PDB3 can use all available parallel execution processes at times.
• F.PDB3 is guaranteed to receive at least 20% of the available system resources if there is enough demand.

Comment: *

Name: *

Email: *

Verification: *

Choose the best answer. 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: $ export ORACLE_SID=cdb1 $ sqlplus / as sysdba SQL> STARTUP UPGRADE; SQL> SHOW pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------------------------------------------------------------2 PDB$SEED 3 PDB1 4 PDB2 MIGRATE YES MOUNTED YES MOUNTED YES SQL> ALTER PLUGGABLE DATABASE pdb1 OPEN UPGRADE; Pluggable database altered. SQL> exit $ $ORACLE_HOME/perl/bin/perl catctl.pl -C 'PDB2' What is the outcome?

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

Comment: *

Name: *

Email: *

Verification: *

Which two are true about gathering optimizer statistics?

• A.Executing dbms_stats.gather_database_stats while connected to cdb$root gathers object statistics only in cdbSroot.
• B.Executing dbms_stats.gather_database_stats while connected to a PDBopened 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 in all open PDBs except pdb$seed.
• 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: *