1z0-083 Practice Test

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