Which three are true? (Choose three.)

A.

Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized
with all application PDBs containedin the application container.

B.

Application-common TSDP policies are always container specific.

C.

Application-common Transparent Security Data Protection (TSDP) policies can be created only within
an application install/patch BEGIN-END block.

D.

Application-common Oracle Label Security (OLS) policies cannot be created in an application root
outside an install/patch BEGIN-END block.

E.

Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all
application PDBs contained in the application container.

F.

Application-common OLS policies can be created in an application root inside an install/patch
BEGIN-END Block

G.

Unified auditing can be automatically synchronized to all application PDBs in an applicationcontainer.

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 savedtwo 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.

A container database called CDB1 is OMF-enabled.
PDB_FILE_NAME_CONVERT is not configured in CDB1. PDB1 was unplugged from CDB1 earlier in the
week. Examine this command, which will be executed in CDB1:
CREATE PLUGGABLE DATABASE pdb1
USING ‘/u01/app/oracle/oradata/pdb1.xml’
SOURCE_FILE_NAME_CONVERT =
(‘/u01/app/oracle/oradata/’, ‘/u02/app/oracle/oradata/’);
Which two are true? (Choose two.)

A.

PDB1 data files already exist in the correct location.

B.

DBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before executing the command.

C.

PDB_FILE_NAME_CONVERT must be set before executing the command.

D.

/u01/app/oracle/oradata/pdb1.xml does not contain the current locations of data filesfor PDB1.

E.

PDB1 must be dropped from CDB1.

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

A.

ADDM can recommend shrinking the buffer cache

B.

ADDM can recommend extending the buffer cache.

C.

By default, MMON creates an AWR snapshot every 30 minutes.

D.

ADDM performs itsanalysis only when a DBA requests it.

E.

By default, AWR snapshots are automatically purged after eight days.

F.

AWR snapshots must be deleted when no longer required by ADDM.

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)

Which two are true about duplicating pluggable databases (PDBs) with RMAN? (Choose two.)

A.

Two or more PDBs can be duplicated with the same RMAN DUPLICATE command.

B.

All tablespaces belonging to a PDB must be duplicated when duplicating the PDB.

C.

The auxiliary instance is automatically created with ENABLE_PLUGGABLE_DATABASE = TRUE.

D.

A user with SYSDBA or SYSBACKUP must be logged in with RMAN to the PDB to duplicate it.

E.

CDB$ROOT and PDB$SEED are automatically duplicated.

A user complains about poor database performance.
You want to verify if the user’s session has waited for certain types of I/O activity. Which view displays all
waits waited on by a session at least once?

A.

V$SESSION_EVENT

B.

V$SESSTAT

C.

V$SESSION_WAIT

D.

V$SESSION_WAIT_CLASS

E.

V$SESSION

How do you configure a CDB for local undo mode?

A.

Open the CDB instance in upgrade mode. In cdb$root, execute alter database local undo on, and then
restart the CDB instance

B.

Open the CDB in read-only mode. In cdb$root, execute alter database local undo on, and then change
the CDB to read/write mode

C.

Open the CDB instance in restricted mode. In cdb$root, execute alter database local undo on. create an
undo tablespace in each PDB, and then restart the CDB instance

D.

Open the CDB instance in restricted mode. In cdb$root, drop the undo tablespace. Execute alter
database local undo on in each PDB, and then restart the CDB instance.

E.

Open the CDB instance in upgrade mode. In each PDB, execute alter database local undo on, create an
undo tablespace, and then restart the CDB instance.

Examine these actions:
1.Create a new database for a recovery catalog.
2.Create a tablespace with sufficient space in the catalog database for the recovery catalog.
3.Configure ARCHIVELOG mode for the catalog database.
4.Create a user to own the recovery catalog schema with quota on the tablespace that will containthe
catalog.
5.Grant the RECOVERY_CATALOG_OWNER role to the recovery catalog schema owner.
6.Grant the SYSBACKUP privilege to the recovery catalog schema owner.
Which are the minimum actions that must be performed before executing the CREATECATALOG command?

A.

2, 4, 5, 6

B.

1, 2, 3, 4, 5, 6

C.

1, 2, 4, 5

D.

2, 4, 5

E.

1, 3, 4, 5

Your container database, CDB1, has an application container, HR_ROOT, with an application PDB,
HR_PDB1.
You have the required privilege to clone HR_PDB1 to container database CDB2, which does not contain
HR_ROOT.
Which two are always true? (Choose two.)

A.

CDB1 and CDB2 must be in shared undo mode.

B.

A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege.

C.

All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.

D.

Cloning HR_ROOT automatically clones HR_PDB1.

E.

The HR_PDB1 clone created in CDB2 will be in mount state when cloning ends.

Which three are true in Oracle 19c and later releases? (Choose three.)

A.

If the password file location changes, then the new location is used automatically by the Oracle Server.

B.

Schema Only accounts can be granted administrator privileges

C.

All the Oracle-supplied accounts are Schema Only accounts.

D.

Privilege Analysis is included in Oracle Enterprise Edition and no longer requires Database Vault.

E.

Unified Auditing can be configured to audit only events that are issued indirectly by an audited user.

F.

Unified Auditing can be configured to audit only events that are issued directly by an audited user.

Which two are true about data movement between a non-CDB and a PDB using Data Pump? (Choose two.)

A.

Tablespaces are automatically created as neeed while importing full exports in either a non-CDB or a
PDB.

B.

Oracle attempts to convert conventional database users to local users when moving schemas from a non-
CDB to a PDB.

C.

A new PDB is automatically created when importing a non-CDB into a CDB.

D.

Oracle attempts to convert common users to conventional users when moving schemas from a PDB to a
non-CDB.

E.

Moving data from a PDB to anon-CDB is only possible by using transportable tablespace export and
import.

F.

Moving data from a non-CDB to a PDB is only possible by using conventional export and import.