For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command? (Choose two.)

• A.to exclude all tablespaces except SYSTEM, SYSAUX, and TEMPwhen plugging in a PDB
• B.to specify the list oftablespaces to include when creating a PDB from the CDB seed
• C.to specify the list of user tablespaces to include when moving a non-CDB to a PDB
• D.to include specific user tablespaces only when relocating a PDB
• E.to specify a default tablespace in a PDB cloned from another PDB in the same CDB.
• F.to exclude a temp tablespace when plugging in a PDB

Comment: *

Name: *

Email: *

Verification: *

You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded. Sometimes, you are not able to connect to the database instance because it hangs. How can you detect the cause of the degraded performance?

• A.by using Active Session History (ASH) data and performing hang analysis
• B.by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) to fetch data directly from SGA for analysis
• C.by running ADDM to fetch information from the latest Automatic Workload Repository (AWR) snapshots
• D.by running ADDM in diagnostic mode

Comment: *

Name: *

Email: *

Verification: *

A container database, CDB1, contains a pluggable database PDB1. Another container database is called CDB2. You want to relocate PDB1 from CDB1 to CDB2 with near-zero down time. Which three are required?

• A.CDB2 must be in archivelog mode.
• B.CDB1 must be in shared UNDO mode only.A container database, CDB1, contains a pluggable database PDB1.
• C.CDB1 must be in archivelog mode.
• D.CDB1 and CDB2 must both be in local UNDO mode.
• E.CDB1 and CDB2 must be in shared UNDO mode.
• F.CDB2 must be in shared UNDO mode only.

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 PDB2 is not in UPGRADE state.
• B.Only CDB$ROOT, PDB$SEED, and PDB1 are upgraded.
• C.Only CDB$ROOT, PDB$SEED, and PDB2 are upgraded.
• D.It fails because PDB$SEED is in MIGRATE state.
• E.CDB$ROOT, PDB$SEED, PDB1, and PDB2 are upgraded.
• F.Only CDB$ROOT and PDB$SEED are upgraded.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Database Point-in-Time Recovery?

• A.The target point for the recovery must be specified as a time or System Change Number (SCN).
• B.The database must be open resetlogs after Database Point-in-Time Recovery.
• C.The database must be in archivelog mode.
• D.The database must be in mount state when performing Database Point-in-Time Recovery.
• E.The database must have flashback database on to perform Database Point-in-Time Recovery.
• F.Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)

Comment: *

Name: *

Email: *

Verification: *