1Z0-082 - Oracle Database Administration I Performing Backup and Recovery Questions and Answers

Question 1

A database running in ARCHIVELOG mode experiences a media failure, losing a single data file belonging to a non-system, non-undo tablespace.
The DBA needs to perform a complete recovery of the affected tablespace while the rest of the database remains online.
Which sequence of RMAN commands is the correct way to accomplish this?

Accepted Answer

ALTER TABLESPACE users OFFLINE; RESTORE TABLESPACE users; RECOVER TABLESPACE users; ALTER TABLESPACE users ONLINE;

Answer

RESTORE DATABASE; RECOVER DATABASE;

Answer

SHUTDOWN IMMEDIATE; STARTUP MOUNT; RESTORE TABLESPACE users; RECOVER TABLESPACE users; ALTER DATABASE OPEN;

Answer

RESTORE DATAFILE 5; RECOVER DATAFILE 5; ALTER DATABASE DATAFILE 5 ONLINE;

Question 2

What is the primary advantage of operating an Oracle database in ARCHIVELOG mode?

Accepted Answer

It enables online ('hot') backups and supports point-in-time recovery.

Answer

It improves the performance of DML operations by batching redo information.

Answer

It reduces the amount of storage required for the online redo logs.

Answer

It allows the database to be backed up while it is offline (cold backup).

Question 3

A DBA is configuring a database and wants to centralize the storage of backup and recovery-related files, allowing Oracle to manage their lifecycle automatically. Which of the following file types would be stored in the Fast Recovery Area (FRA) by default?

Accepted Answer

Archived redo logs, RMAN backupsets, and flashback logs.

Answer

Password files and server parameter files (SPFILE).

Answer

Data files and temporary files.

Answer

Alert logs and trace files.

Question 4

A backup strategy involves an RMAN incremental level 0 backup on Sunday. On Monday and Tuesday, RMAN incremental level 1 differential backups are performed. If a media failure occurs on Wednesday morning, which backups are essential to restore and recover the database to its most recent state?

Accepted Answer

The level 0 backup from Sunday, the level 1 backup from Monday, and the level 1 backup from Tuesday.

Answer

Only the level 1 backup from Tuesday.

Answer

The level 0 backup from Sunday and the level 1 backup from Monday.

Answer

The level 0 backup from Sunday and the level 1 backup from Tuesday.

Question 5

A junior developer accidentally executes a `DROP TABLE` command on a critical application table. The DBA needs to recover the table as quickly as possible with minimal impact on other database operations. Which Oracle feature is specifically designed for this scenario?

Accepted Answer

Flashback Drop.

Answer

RMAN Point-in-Time Recovery (PITR) of the tablespace.

Answer

Flashback Database.

Answer

Flashback Table.

Question 6

After a database failure, a DBA uses the Data Recovery Advisor (DRA) through RMAN. What is the primary function of the `ADVISE FAILURE` command?

Accepted Answer

It analyzes detected failures and generates one or more recommended repair scripts.

Answer

It automatically repairs all detected failures without user intervention.

Answer

It generates a human-readable report of all backups available in the RMAN catalog.

Answer

It lists all failures currently stored in the Automatic Diagnostic Repository (ADR).