Question No. 1

Which two are true about Oracle instance recovery? (Choose three.)

ARecovery begins from the beginning of the CURRENT redo log group.

BRecovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure.

CRecovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log group if no other group is ACTIVE.

DRecovery reads redo until the end of the redo thread. SMON rolls back any dead transactions, and then the datanase is opened.

ERecovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).

FRecovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.

Show Answer

Correct Answer: B, E, F

Question No. 2

Which two are true about unplugging an application container from a container database and plugging it into a different container database?

AIt requires local undo mode in both container databases.

BIt requires only local undo mode in the database where the application container will be unplugged.

CPlugging the application root into a different CDB plugs In all its application PDBs.

DApplication PDBs In the application container must be unplugged before the application root Is unplugged.

EUnplugging the application root from a CDB unplugs all its application PDBs.

FThe application root of an application container should be plugged Into the other CDB before Its application PDBs are plugged in.

Show Answer

Correct Answer: D, E

Question No. 3

In which two situations can you use Database Upgrade Assistant? (Choose two.)

Awhen the operating system (OS) needs to be changed as part of the upgrade

Bwhen a character set conversion is required during the upgrade

Cwhen multiple pluggable databases in a container database have to be upgraded in a specific sequence

Dwhen the target and source database are on the same platform

Ewhen the hardware platform needs to be changed as part of the upgrade

Show Answer

Correct Answer: C, D

upgrade-assistant-dbua.html#GUID-F929338D-48EE-434F-A5F9-A9E7CD61B17F

Question No. 4

Examine this configuration:

CDB1 is a container database.

PDB1 and PDB2 are pluggable databases in CDB1.

You execute these commands successfully:

Which two are true? (Choose two.)

APDB1 and PDB2 are in MOUNT state.

BRedo logs are opened.

CPDB1 and PDB2 are in READ ONLY state.

DCDB$ROOT is in MOUNT state.

EPDB$SEED is in READ ONLY state.

Show Answer

Correct Answer: B, E

Question No. 5

Examine this configuration:

1. CDB1 is a container database.

2. APP_ROOT is an application root in CDB1.

3. APP_PDB1 is an application PDB in APP_ROOT.

4. FLASHBACK DATABASE is ON.

You execute these commands:

Which table or set of tables will exist after the Flashback operation has completed?

ACDB1_TAB, APP_ROOT_TAB, and APP_PDB1_TAB

BCDB1_TAB and APP_PDB1_TAB

Cnone of the tables, because all three tables will be dropped

DCDB1_TAB only

ECDB1_TAB and APP_ROOT_TAB

Show Answer

Correct Answer: A

Free Oracle 1Z0-083 Exam Actual Questions

The questions for 1Z0-083 were last updated On Nov 17, 2024