Examine the commands executed to monitor database operations:
$> conn sys oracle/oracle@prod as sysdba
SQL > VAR eid NUMBER
SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (`batch_job' ,
FORCED_TRACKING => `Y');
Which two statements are true?

• A.Database operations will be monitored only when they consume a significant amount of resource.
• B.Database operations for all sessions will be monitored.
• C.Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.
• D.Only DML and DDL statements will be monitored for the session.
• E.All subsequent statements in the session will be treated as one database operation and will be monitored.

Comment: *

Name: *

Email: *

Verification: *

In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer.
Which statement is true?

• A.The CDB must be open.
• B.The CDB must be in the mount stage.
• C.The CDB must be in the nomount stage.
• D.Alt existing PDBs must be closed.

Comment: *

Name: *

Email: *

Verification: *

Your multitenant container database (CDB) is running in ARCHIVELOGmode. You connect to the CDB RMAN.
Examine the following command and its output:

You execute the following command:
RMAN > BACKUP DATABASE PLUS ARCHIVELOG;
Which data files will be backed up?

• A.Data files that belong to only the root container
• B.Data files that belong to the root container and all the pluggable databases (PDBs)
• C.Data files that belong to only the root container and PDB$SEED
• D.Data files that belong to the root container and all the PDBs excluding PDB$SEED

Comment: *

Name: *

Email: *

Verification: *

A database is stored in an Automatic Storage Management (ASM) disk group, DGROUP1, created with SQL:

There is enough free space in the disk group for mirroring to be done.
What happens if the CONTROLLER1 failure group becomes unavailable due to error or for maintenance?

• A.Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.
• B.Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 failure group is brought back online.
• C.ASM does not mirror any data until the CONTROLLER1 failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the CONTROLLER2 failure group, without mirroring.
• D.The data in the CONTROLLER1 failure group is copied to the CONTROLLER2 failure group and rebalancing is initiated.

Comment: *

Name: *

Email: *

Verification: *

You plan to use the In Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.
Which three storage options support the use of HCC?

• A.ASM disk groups with ASM disks consisting of Exadata Grid Disks.
• B.ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array
• C.ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files
• D.Database files stored in ZFS and accessed using conventional NFS mounts.
• E.Database files stored in ZFS and accessed using the Oracle Direct NFS feature
• F.Database files stored in any file system and accessed using the Oracle Direct NFS feature
• G.ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

Comment: *

Name: *

Email: *

Verification: *