Examine the command for creating pluggable database PDB2 in container database CDB2.

Select three options, any one of which is required for it to execute successfully. (Choose three.)

A.

Add the FILE_NAME_CONVERT clause to the statement and set the PDB_FILE_NAME_CONVERT
parameter.

B.

Addonly the CREATE_FILE_DEST clause to the statement.

C.

Set only the PDB_FILE_NAME_CONVERT parameter

D.

Set the PDB_FILE_NAME_CONVERT parameter and enable OMF.

E.

Enable only OMF.

F.

Add the FILE_NAME_CONVERT clause to the statement and enable OracleManaged Files (OMF)

Which three are true about Audit policies In container databases (CDBs)?

A.

All audit records are written to the audit trail in CDB$ROOT

B.

A common unified audit policy can be created at the application root level.

C.

A common unified audit policy can be created at the CDB level.

D.

An application PDB cannot have a local audit policy

E.

Fine-grained auditing policies defined in an application root must be manually synchronized by each
application PDB contained in the application root.

F.

Application-common unified audit policies defined In an application root must be manually
synchronized by each application PDB contained in the application root.

Which two are facets of performance planning that should always be considered or implemented for an Oracle
Database environment? (Choose two.)

A.

defining primary keys for all tables to speed up all queries

B.

using check constraints to speed upupdates

C.

defining foreign keys for all tables to speed up joins

D.

the physical data model

E.

the configuration of storage arrays

While backing up to an SBT channel, you determine that the read phase of your compressed Recovery
Manager (RMAN) incremental level 0 backup is a bottleneck.
FORCE LOGGING is enabled for the database.
Which two could improve read performance? (Choose two.)

A.

Increase the size of tape I/O buffers

B.

Disable FORCE LOGGING for the database.

C.

Increase the size of the database buffer cache

D.

Enable asynchronous disk I/O.

E.

Increase the level of RMAN multiplexing

The USERS tablespace consists of data files 3 and 4 and must always be online in read/write mode.
Which two are true about using RMAN to perform an open database back up of this tablespace? (Choose two.)

A.

Backups must be doneincrementally

B.

Backups must be contained in backup sets.

C.

Backups can be taken only if the database is in ARCHIVELOG mode.

D.

Backups can be done incrementally

E.

The database must be registered in an RMAN catalog.

F.

Only consistent backups can becreated

A container database (CDB) contains two pluggable databases PDB1 and PDB2.
The LOCAL_UNDO_ENABLED database property is set to FALSE in the CDB. Data file 24 of PDB2 was
deleted and you need to restore and recover it.
The only RMAN backup that exists was created with the BACKUP DATABASE command while connected
to
CDB$ROOT.
Which three are true? (Choose three.)

A.

Data file 24 can be recovered only while connected to PDB2.

B.

Data file 24 can be restored and recovered while connected to CDB$ROOT.

C.

Data file 24 can be restored only while connected toCDB$ROOT.

D.

Data file 24 can be restored only while connected to PDB2.

E.

Data file 24 can be recovered while connected to PDB2

F.

Data file 24 can be recovered while connected to CDB$ROOT.

Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)

A.

Tablespaces from different PDBs with identical names must be backed up by connecting RMAN
separately to each PDB to back up the tablespaces.

B.

The BACKUP DATABASE command will create a pluggable database (PDB) backup when RMAN is
connected to a PDB.

C.

SPFILEbackups can be created while connected to an application root PDB.

D.

The BACKUP DATABASE PLUS ARCHIVELOG command will back up archive logs when RMAN is connected to a PDB.

E.

The BACKUP PLUGGABLE DATABASE command can be used to back up CDB$ROOT.

Which two are true about the Automatic Database Diasnostic Monitor (ADDM)? (Choose two.)

A.

It analyzes a period of time corresponding to the 12 hours of activity.

B.

It runs automatically after each AWR snapshot.

C.

A DBA can run it manually

D.

Results are written to the alert log

E.

It analyzes a period of time corresponding to the last day of activity

Which three are true about Automatic Workload Repository (AWR)? (Choose three.)

A.

By default, AWR snapshots are taken every 60 minutes.

B.

Its collection level is determined by the value of theSTATISTICS_LEVEL database parameter

C.

By default, AWR snapshots are retained for 7 days.

D.

The taking of AWR snapshots can be disabled.

E.

AWR data is stored in the SYSTEM tablespace

Which two are true about RMAN duplexed backup sets? (Choose two.)

A.

A duplexed backup set uses the same number of SBT channels as a non-duplexed backup set for the
same number of files.

B.

A non-duplexed backup set written to disk can be duplexed to disk bybacking up the backup set that is
already on disk.

C.

A non-duplexed backup set written to SBT can be duplexed to tape by backing up the backup set that is
already on tape.

D.

A non-duplexed backup set written to disk can be duplexed to tape by backing upthe backup set that is
already on disk.

E.

A non-duplexed backup set written to SBT can be duplexed to disk by backing up the backup set that is
already on tape.

F.

A duplexed backup set always uses twice as many SBT channels as a non-duplexedbackup set for the
same number of files.

You are managing this configuration:
CDB1is a container database.
PDB1andPDB2are two pluggable databases inCDB1.
USER1.EMPis a table inPDB1andUSER2.DEPTis a table inPDB2.
CDB1userSYSexecutes these commands after connecting successfully toPDB2:

Which two are true? (Choose two.)

A.

The inserts on USER1.EMP remain uncommitted when the session connected to PDB2.

B.

The inserts on USER1.EMP were committed when the session inserted a row into USER2.DEPT.

C.

The insert on USER2.DEPT fails because of the active transaction in the parent container.

D.

The insert on USER2.DEPT is a recursive autonomous transaction by the child session and is
committed.

E.

The inserts on USER1.EMP were rolled back when the session connected to PDB2.

F.

The insert on USER2.DEPT is uncommitted

G.

The inserts on USER1.EMP were committed when the session connected to PDB2

Examine this configuration:

What will be the outcome?

A.

It will create ‘$ORACLE_HOME/dbs/cdb1/CDB1/controlfile02.ctl’

B.

It will create ‘/u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl’.

C.

It will re-create ‘/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl’

D.

It will create ‘/u01/app/oracle/product/12.2.0.1/db_1/dbs/snapcf_cdb1control02.ctl’.

E.

It will fail because there is no autobackup of the controlfiles.