0

Oracle Database Backup and Recovery

Description: Relational Database backup DatabasesDatabaseOracle
Number of Questions: 15
Created by:
Tags: Relational Database backup Databases Database Oracle
Attempted 0/15 Correct 0 Score 0

In which of the following phases does RMAN send the RPC calls to the target database, monitors their progress and collects the results?

  1. Execution phase

  2. Compilation phase

  3. Command file

  4. Common language interpreter

  5. Duplicate database


Correct Option: A
Explanation:

Here, RMAN sends the RPC calls to the target database, monitors their progress and collects the results.

In which of the following do memory systems have long used parity bits for error detection and correction?

  1. RAID level 0

  2. RAID level 1

  3. RAID level 2

  4. Image copy

  5. RAID level 5


Correct Option: C
Explanation:

Here, memory systems have long used parity bits for error detection and correction.

RMAN periodically propagates metadata from the target database control file into which of the following?

  1. Duplicate database

  2. Recovery catalog schema

  3. Media management application

  4. Media management catalog

  5. Command file


Correct Option: B
Explanation:

RMAN periodically propogates metadata from the target database control file into the recovery catalog schema.

In which of the following options does a transaction commit as soon as its commit log record is written to stable storage at the primary and the backup site?

  1. One-safe

  2. Detection of failure

  3. Image copy

  4. Two-very-safe

  5. RAID level 1


Correct Option: D
Explanation:

A transaction commits as soon as its commit log record is written to stable storage at the primary and the backup site.

Which of the following can use Oracle Net to connect to a target database?

  1. RMAN client

  2. Client

  3. Database server

  4. Duplicate database

  5. Media management application


Correct Option: A
Explanation:

The RMAN client can use Oracle Net to connect to a target database.

Which of the following level is the P + Q redundancy scheme, stores extra redundant information to guard against multiple disk failures?

  1. RAID level 5

  2. RAID level 0

  3. RAID level 6

  4. RAID level 1

  5. Image copy


Correct Option: C
Explanation:

It is the P+Q redundancy schemes, stores extra redundant information to guard against multiple disk failures.

Which of the following is a directory, file system or automatic storage management disk group that serves as the default storage area for files related to recovery?

  1. Duplicate database

  2. Flash recovery area

  3. Proxy archived log backups

  4. Automatic datafile creation

  5. One-safe


Correct Option: B
Explanation:

It is a directory, file system or automatic storage management disk group that serves as the default storage area for files related to recovery.

If the primary database goes down, then you can fail over to the which of the following databases?

  1. Duplicate database

  2. Media management catalog

  3. Database server

  4. Standby database

  5. Media management application


Correct Option: D
Explanation:

If the primary database goes down then you can fail over to the standby database.

By which of the following can you quickly revert a database to a previous time without restoring datafiles and performing media recovery?

  1. Proxy archived log backups

  2. Automatic datafile creation

  3. Media management catalog

  4. Duplicate database

  5. Oracle flashback database


Correct Option: E
Explanation:

You can quickly revert a database to a previous time without restoring datafiles and performing media recovery.

By which of following phases are the locks only released?

  1. Growing phase

  2. Compilation phase

  3. Shrinking phase

  4. Shared mode

  5. In-doubt transaction


Correct Option: C
Explanation:

During this phase, the locks are only released.

The work of backup and recovery is performed by server sessions running on which of the following databases?

  1. Media management catalog

  2. Target database

  3. Duplicate database

  4. Client

  5. Media management application


Correct Option: B
Explanation:

The work of backup and recovery is performed by server sessions running on the target database.

In which of the following does a transaction need to edit data item?

  1. Shared mode

  2. Exclusive mode

  3. Growing phase

  4. Compilation phase

  5. Local agents


Correct Option: B
Explanation:

Here, the transaction wants edit the data item.

In which of the following levels can the disk controllers detect whether a sector has been read correctly so the single parity bit can be used for error correction as well as for detection?

  1. RAID level 0

  2. RAID level 1

  3. RAID level 5

  4. Registration of database

  5. RAID level 3


Correct Option: E
Explanation:

Disk controllers can detect whether a sector has been read correctly, so the single parity bit can be used for error correction as well as for detection.

Which of the following nodes must reference data on other nodes to complete its part in the distributed transaction?

  1. Client

  2. Commit point site

  3. Database server

  4. Local coordinator

  5. Duplicate database


Correct Option: D
Explanation:

A node that must references data on other nodes to complete its part in the distributed transaction.

Which of the following RAID level keeps a parity block on a separate disk for corresponding blocks from N other disks?

  1. RAID level 4

  2. RAID level 0

  3. RAID level 1

  4. One-safe

  5. RAID level 5


Correct Option: A
Explanation:

It keeps a parity block on a separate disk for corresponding blocks from N other disks.

- Hide questions