Oracle 1Z0-083 Quiz 19 Topic 8 Questions 91-95

Question: 1

Examine this configuration:

1. CDB1 is a container database.

2. PDB1 and PDB2 are pluggable databases in CDB1.

3. PDB1 and PDB2 are open in read write mode.

You execute these commands successfully:

q1_1Z0-083

Which two are true?

ACDB1 is in mount state

BCDB1 is shut down.

CPDB1 is closed.

DUncommitted transactions in PDB1 have been rolled back.

EUncommitted transactions in CDB1 and pdbi have been rolled back.

Show Answer

Question: 2

Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor?

AUsing the Data Recovery Advisor list failure command always requires that the database for which failures are to be listed is in mount state.

BData Recovery Advisor can be used if a database is closed.

CData Recovery Advisor can proactively check for failures.

DA failure can be closed only when it has been repaired.

EThe Data Recovery Advisor change failure command can be used only to change failure priorities.

Show Answer

Question: 3

Examine these queries and their output:

q3_1Z0-083

After a system crash, an instance restart and an attempted opening of the PDBs result in:

q3_1Z0-083

Which two are true?

AData file 24 can be recovered while CDB$ROOTand PDB$SEED are opened.

BData file 24 must be recovered while the CDB is opened.

CData file 24 cannot be recovered while the CDB is opened.

DData file 24 can be recovered while PDB2 is opened.

EData file 24 must be recovered while PDB2 is closed.

Show Answer

Question: 4

A database is configured in archivelog mode.

A full RMAN backup exists but no control file backup to trace has been taken.

A media failure has occurred.

In which two scenarios is incomplete recovery required?

Aafter losing all copies of the control file

Bafter losing all members of an inactive online redo log group

Cafter losing all members of the current online redo log group

Dafter losing an undo tablespace that is in use

Eafter losing a sysaux tablespace data file

Show Answer

Question: 5

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?

ABackups must be done incrementally.

BBackups must be contained in backup sets.

CBackups can be done incrementally.

DOnly consistent backups can be created.

EBackups can be taken only if the database is in archivelog mode.

FThe database must be registered in an RMAN catalog.

Show Answer

Oracle 1Z0-083 Quiz:19 Topic:8 Questions:91-95