0

Relational Database Transaction Scheme

Description: Relational database transaction scheme Java/Oracle /C/C++Oracle
Number of Questions: 15
Created by:
Tags: Relational database transaction scheme Java/Oracle /C/C++ Oracle
Attempted 0/15 Correct 0 Score 0

Which of the following RAID levels refers to memory-style error correcting codes and redundancy through hamming code?

  1. Registration

  2. One-safe

  3. RAID level 2

  4. RAID level 0

  5. RAID level 6


Correct Option: C
Explanation:

This RAID level refers to memory-style error correcting code and redundancy through hamming code.

Which of the following nodes participating in the session tree instructs the commit point site to initiate the global commit of the transaction?

  1. Global coordinator

  2. Local coordinator

  3. Client

  4. Stream pool

  5. Command language interpreter


Correct Option: A
Explanation:

This node participating in the session tree instructs the commit point site to initiate the global commit of the transaction.

The contents of the which of the files will be interpreted as if entered at the command line?

  1. Read only

  2. Parameter file

  3. Archive file

  4. Command file

  5. Command language interpreter


Correct Option: D
Explanation:

The contents of the command file will be interpreted as if entered at the command line.

Which of the following transaction properties has to be strictly followed to avoid a problem called cascading aborts?

  1. Local agent

  2. Shrinking phase

  3. Shared mode

  4. Serializability

  5. Isolation


Correct Option: E
Explanation:

This transaction property has to be strictly followed to avoid a problem called cascading aborts.

Which of the following components of the RMAN environment contains the control files, recovery meta data etc.?

  1. Mounting the database

  2. Target database

  3. Duplicate database

  4. Media management catalog

  5. Media management application


Correct Option: B
Explanation:

This component of the RMAN environment contains control files, recovery meta data etc.

Which of the following can be executed against any control files in the catalog?

  1. Recover

  2. Global stored script

  3. Duplicate database

  4. Media management catalog

  5. Archive file


Correct Option: B
Explanation:

It can be executed against any control files in the catalog.

In which of the following is it possible to lock individual tuples?

  1. Mounting the database

  2. Local agents

  3. Granularity of locking

  4. Shared mode locking

  5. Shrinking phase


Correct Option: C
Explanation:

Here, it is possible to lock individual tuples.

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

  1. Registration

  2. One-safe

  3. RAID level 6

  4. RAID level 1

  5. RAID level 0


Correct Option: D
Explanation:

This RAID level refers to mirrored set without parity and mirrored disks.

Which of the following components of the RMAN environment spawn server sessions on the target database to do work of backup?

  1. Stream pool

  2. Duplicate database

  3. RMAN client

  4. Client

  5. Media management application


Correct Option: C
Explanation:

This component of the RMAN environment spawn server sessions on the target database to do work of backup.

Which of the following areas is an automatic storage management group that includes RMAN backup, flashback logs etc.?

  1. Flashback recovery area

  2. Oracle flashback database

  3. Proxy archived log backups

  4. SQL work area

  5. Private SQL area


Correct Option: A
Explanation:

It is an automatic storage management disk group that includes RMAN backups, flashback logs etc.

Which of the following features of the RMAN describes the level of multiplexing and defines which files are multiplexed?

  1. Java pool

  2. Media management application

  3. Proxy archived log backup

  4. Oracle flashback database

  5. Disk topology and automatic performance tuning


Correct Option: E
Explanation:

This feature of the RMAN describes the level of multiplexing and deines which files are multiplexed.

What is the activity of providing durability of the transaction called?

  1. Recover

  2. Database recovery

  3. Concurrency control

  4. Exclusive mode

  5. Growing phase


Correct Option: B
Explanation:

The activity of providing durability of the transaction is called database recovery.

Which of the following is/are identical to the results of copying a file with operating system commands?

  1. Image copies

  2. Command language interpreter

  3. Media management catalog

  4. Logical standby database

  5. Archive file


Correct Option: A
Explanation:

They are identical to the results of copying a file with operating system commands.

Which of the following levels refers to striped set with dedicated parity and bit-interleaved parity organization?

  1. RAID level 3

  2. RAID level 0

  3. RAID level 6

  4. One-safe

  5. Registration


Correct Option: A
Explanation:

It refers to striped set with dedicated parity and bit-interleaved organization.

Which of the following nodes participating in the session tree hosts a database from which a client requests data?

  1. Database buffer cache

  2. Database server

  3. Client

  4. Local coordinator

  5. Oracle database


Correct Option: B
Explanation:

This node participating in the session tree hosts a database from which a client requests data.

- Hide questions