Oracle 1Z0-083 Quiz 10 Topic 5 Questions 46-50

Question: 1

Which three are true about recovery operations done without using Recovery Manager (RMAN)? (Choose

three.)

AA lost SPFILE can be recovered from memory using SQL*PLUS.

BA lost password file can be re-created with SQL*PLUS.

CA lost TEMPFILE must always be re-created manually.

DA lost password file can be manually re-created with the orapwd utility.

EA lost PFILE can be re-created alert.log using SQL*PLUS.

FA lost index tablespace can be re-created without performing any recovery.

Show Answer

Question: 2

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

Question: 3

Examine this configuration:

1. CDB1 is an Oracle Database 12c Release 2 container database (CDB).

2. PDB1 and PDB2 are two pluggable databases (PDBs) in CDB1.

After successfully performing all the preupgrade tasks, you execute these commands from the Oracle

Database 18c environment:

What is the outcome?

AIt fails because PDB$SEED is in MIGRATE state.

BOnly CDB$ROOT, PDB$SEED, and PDB2 are upgraded.

COnly CDB$ROOT, PDB$SEED, and PDB1 are upgraded.

DCDB$ROOT, PDB$SEED, PDB1, and PDB2 are upgraded.

EOnly CDB$ROOT and PDB$SEED are upgraded.

FIt fails because PDB2 is not in UPGRADE state.

Show Answer

Question: 4

Which three are true about a whole database backup? (Choose three.)

AIt can consist of either backup sets or image copies.

BIt is the only possible backup type for a database in NOARCHIVELOG mode.

CIt can be consistent.

DIt can be created only by using RMAN.

EIt can be inconsistent.

FIt always includes all data files, the current control file, the server parameter file, and archived redo logs.

Show Answer

Question: 5

Which two are true about reclaiming space used by Flashback logs in Oracle Database 19c and later

releases? (Choose two.)

ASpace is always reclaimed automatically when the retention period for Flashback logs is lowered.

BSpace might be reclaimed proactively before space pressure occurs.

CSpace might be reclaimed automatically when the retention period for Flashback logs is lowered.

DSpace is only reclaimed when there is space pressure in the Fast Recovery Area. (FRA)

ESpace is always reclaimed proactively before space pressure occurs.

Show Answer

Oracle 1Z0-083 Quiz:10 Topic:5 Questions:46-50