Examine this output:

Which two are true? (Choose two.)

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

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:
23.CDB1and CDB2are two container databases.
24.PDB1is a pluggable database in CDB1.
25.PDB1_C1_SRVis a service for PDB1.
26.CDB1_LINKis a database link in CDB2referring to PDB1.
27.CDB2is also an entry in tnsnames.orapointing to the CDB2database default service.
You execute these commands successfully:
$ sqlplus sys/oracle_4U@cdb2 as sysdba
SQL> CREATE PLUGGABLE DATABASE PDB1
FROM PDB1@CDB1_LINK
SERVICE_NAME_CONVERT=('PDB1_C1_SRV','PDB1_C2_SRV');
Which two are true? (Choose two.)

• A.PDB1 will be created in CDB2 and automatically opened.
• B.PDB1 will be created in CDB2 and left in MOUNT state.
• C.PDB1_C1_SRV in CDB1 will be renamed PDB1_C2_SRV.
• D.PDB1_C2_SRV will be created and started automatically.
• E.PDB1_C2_SRV will be created but not started.

Comment: *

Name: *

Email: *

Verification: *

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

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process? (Choose three.)

• A.By default, AWR snapshots are automatically purged after eight days.
• B.AWR snapshots must be deleted when no longer required by ADDM.
• C.ADDM can recommend extending the buffer cache.
• D.By default, MMON creates an AWR snapshot every 30 minutes.
• E.ADDM performs its analysis only when a DBA requests it.
• F.ADDM can recommend shrinking the buffer cache.

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:
CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2.
PDB$SEED is open READ ONLY
PDB1 is open READ WRITE
PDB2 is MOUNTED.
ORACLE_HOME is /u01/app/oracle/product/18.1.0/dbhome_1.
You execute these commands before upgrading the database to the current release:

For which databases will fixup scripts be created?

• A.CDB1, PDB1, and PDB2 only
• B.CDB1, PDB$SEED, and PDB1 only
• C.CDB1, PDB$SEED, PDB1, and PDB2
• D.PDB$SEED, PDB1, and PDB2 only
• E.CDB1 and PDB$SEED only

Comment: *

Name: *

Email: *

Verification: *