Oracle 1Z0-083 Quiz 18 Topic 7 Questions 86-90

Question: 1

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?

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

BData file 24 can be restored only while connected to CDB$ROOT.

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

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

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

FData file 24 can be recovered while connected to PDB2.

Show Answer

Question: 2

Which two are true about Oracle Database Configuration Assistant (DBCA) templates?

AOracle DBCA templates can store only logical structure and not database files.

BThe General Purpose or Transaction Processing templates are most suitable when concurrency and recoverability are key criteria.

CNew templates can only be created by modifying an existing user-created template.

DOracle DBCA templates can be used to create new databases and duplicate existing databases.

EThe Data Warehouse template is most suitable when transaction response time is the key criterion.

Show Answer

Question: 3

Which four are true about RMAN backup sets?

AA backup set must be written to media.

BBlocks from multiple data files can be contained in one backup set.

CA backup set must be written to disk.

DBlocks from multiple data files can be contained in one backup piece.

EA data file can be split into multiple sections stored in different backup sets.

FA backup piece can belong to only one backup set.

GA backup set can contain only one backup piece.

HA data file can be split into multiple sections stored in different backup pieces in the same backup set.

Show Answer

Question: 4

You have configured RMAN SBT channels to write backups to media.

You then take an RMAN backup by using this command:

q4_1Z0-083

Which three are true?

AAll archive logs created after this backup are kept for two years.

BThe data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.

CThe restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.

DThe control file is included in the self-contained archival backup.

EThe spfile is included in the self-contained archival backup.

FThe restore point is a label for the system change number (SCN) before the archival backup was taken.

Show Answer

Question: 5

Examine this configuration:

q5_1Z0-083

To recover from this critical failure, you execute these commands:

q5_1Z0-083

What will be the outcome?

AOption

BOption

COption

DOption

EOption

Show Answer

Oracle 1Z0-083 Quiz:18 Topic:7 Questions:86-90