1z0-083 Practice Test

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)