0

Oracle Database Recovery and Server Tuning

Description: Oracle database recovery and server tuning Java/Oracle /C/C++Oracle
Number of Questions: 15
Created by:
Tags: Oracle database recovery and server tuning Java/Oracle /C/C++ Oracle
Attempted 0/15 Correct 0 Score 0

Which of the following components of the RMAN environment is the database to be backed up or recovered?

  1. Duplicate database

  2. Target database

  3. Media management catalog

  4. Proxy archived log backups

  5. Database server


Correct Option: B
Explanation:

This component of the RMAN environment is the database to be backed up or recovered.

Which of the following areas includes files created by RESTORE and RECOVER commands?

  1. Flash recovery area

  2. SQL work area

  3. Redo log buffer

  4. Image copy

  5. Recovery through resetlogs


Correct Option: A
Explanation:

A flash recovery area includes files created by RESTORE and RECOVER commands.

During which of the following phases of 2-phase locking mechanism, locks are only released?

  1. Growing phase

  2. Compilation phase

  3. Two-very-phase

  4. Shrinking phase

  5. Local agent


Correct Option: D
Explanation:

During this phase of 2-phase locking mechanism, locks are only released.

Which of the following RAID levels refers to striped set without parity and non-redundant array?

  1. RAID level 5

  2. RAID level 6

  3. RAID level 0

  4. Two-very-safe

  5. Detection of failure


Correct Option: C
Explanation:

This RAID level refers striped set without parity and non-redundant array.

A transaction can lock a data item in which of the following modes if it is not locked at all?

  1. Exclusive mode

  2. Local agents

  3. Growing phase

  4. Command file

  5. Shared mode


Correct Option: E
Explanation:

A transaction can lock a data item in shared mode if it is not locked at all.

Which of the following RAID levels refers to mirrored set without parity?

  1. RAID level 5

  2. RAID level 6

  3. Duplicate database

  4. RAID level 1

  5. Registration


Correct Option: D
Explanation:

This RAID level refers mirrored set without parity.

Which of the following components of the RMAN environment is a separate database created to hold the recovery catalog?

  1. Catalog database

  2. Media management catalog

  3. Duplicate database

  4. Proxy archived log backups

  5. Local agents


Correct Option: A
Explanation:

Catalog database is a separate database created to hold the recovery catalog.

Which of the following features of the RMAN describes the contents of the backup sets that defines which files are multiplexed?

  1. Disk topology and automatic performance tuning

  2. Oracle flashback database

  3. Proxy archived log backups

  4. Duplicate database

  5. Stream pool


Correct Option: A
Explanation:

Here, the contents of the backup sets that define which files are multiplexed.

Which of the following interfaces is an alternative method for issuing commands to RMAN and receiving the output from those commands?

  1. Command file

  2. RMAN pipe interface

  3. Media management application

  4. Two-very-safe

  5. Member method


Correct Option: B
Explanation:

It is an alternative method for issuing commands to RMAN and receiving the output from those commands.

Which of the following is a series of tables and views owned by a single user populated with backup and recovery information for one or more databases?

  1. Standby database

  2. Recovery catalog

  3. Duplicate database

  4. Media management catalog

  5. Registration


Correct Option: A
Explanation:

It is a copy of the primary database that is updated using archived logs created by the primary database.

During which of the following phases, RMAN sends the remote procedure calls to the target database and remotes their progress?

  1. Growing phase

  2. Compilation phase

  3. Execution phase

  4. Two-very-safe

  5. Image copy


Correct Option: C
Explanation:

During the execution phase, RMAN sends the remote procedure calls to the target database and monitors their progress.

Which of the following RAID levels refers to redundancy through hamming code?

  1. RAID level 6

  2. RAID level 5

  3. RAID level 2

  4. Two-very-safe

  5. Image copy


Correct Option: C
Explanation:

This RAID level refers redundancy through hamming code.

Which of the following can be associated with a single database in the catalog?

  1. Command file

  2. Stored scripts

  3. Duplicate database

  4. Media management catalog

  5. Registration


Correct Option: B
Explanation:

Stored scripts can be associated with a single database in the catalog.

Which of the following classifications of the degree of durability has the problem that updates of a committed transaction may not have made it to the backup site, when the backup site takes over processing?

  1. Two-very-safe

  2. Detection of failuer

  3. Growing phase

  4. Exclusive mode

  5. One-safe


Correct Option: E
Explanation:

The problem with this scheme is that updates of a committed transaction may not have made it to the backup site, when the backup site takes over processing.

Which of the following RAID levels refers to striped set with dedicated parity?

  1. Two-very-safe

  2. RAID level 6

  3. RAID level 3

  4. Registration

  5. RAID level 5


Correct Option: C
Explanation:

This RAID level refers striped set with dedicated parity.

- Hide questions