Question 1

____ failure can be due to an administrator-induced problem,such as repetitive use of the SHUTDOWN ABORT command,or pulling the power plug out of the wall.

Accepted Answer

A)  Media 
B)  User 
C)  Application 
D)  Oracle Database-Induced 
A)  Media 
B)  User 
C)  Application 
D)  Oracle Database-Induced

Question 2

A(n)____ backup is a backup performed when the database is online,active,and available for use.

Accepted Answer

A)  cold 
B)  hot 
C)  online 
D)  active 
A)  cold 
B)  hot 
C)  online 
D)  active

Question 3

____ is the process of copying files from a backup.

Accepted Answer

A)  Backup 
B)  Restoration 
C)  Recovery 
D)  Rollback 
A)  Backup 
B)  Restoration 
C)  Recovery 
D)  Rollback

Question 4

____ logs contain entries of all transactional activity in a database as transactions occur.

Accepted Answer

A)  Archive 
B)  Redo 
C)  Transactional 
D)  Undo 
A)  Archive 
B)  Redo 
C)  Transactional 
D)  Undo

Question 5

A(n)____ backup is the easiest method of backup and recovery.

Accepted Answer

A)  cold 
B)  hot 
C)  automated 
D)  manual 
A)  cold 
B)  hot 
C)  automated 
D)  manual

Question 6

Cold backups,especially in the case of using RMAN,can allow for recovery of failure due to partial errors such as a single disk failure in a collection of disks,or the loss of a single table.

Accepted Answer

A) True 
 B)False

____ failure can be due to an administrator-induced problem,such as repetitive use of the SHUTDOWN ABORT command,or pulling the power plug out of the wall.

A(n)____ backup is a backup performed when the database is online,active,and available for use.

____ is the process of copying files from a backup.

____ logs contain entries of all transactional activity in a database as transactions occur.

A(n)____ backup is the easiest method of backup and recovery.

Cold backups,especially in the case of using RMAN,can allow for recovery of failure due to partial errors such as a single disk failure in a collection of disks,or the loss of a single table.

Oracle Architecture Overview

Tools and Architecture

Creating an Oracle Instance

Oracle Physical Architecture and Data Dictionary Views

Basic Storage Concepts and Settings

The Basics of Querying a Database

Basic Table Management

Advanced Table Management

Constraints, indexes, and Other Specialized Objects

Basic Data Management

Advanced Data Management

Security Management

Performance Monitoring

Proactive Maintenance

Filters

Exam 15: Backup and Recovery

____ failure can be due to an administrator-induced problem,such as repetitive use of the SHUTDOWN ABORT command,or pulling the power plug out of the wall.

A(n)____ backup is a backup performed when the database is online,active,and available for use.

____ is the process of copying files from a backup.

____ logs contain entries of all transactional activity in a database as transactions occur.

A(n)____ backup is the easiest method of backup and recovery.

Cold backups,especially in the case of using RMAN,can allow for recovery of failure due to partial errors such as a single disk failure in a collection of disks,or the loss of a single table.

Oracle Architecture Overview

Tools and Architecture

Creating an Oracle Instance

Oracle Physical Architecture and Data Dictionary Views

Basic Storage Concepts and Settings

The Basics of Querying a Database

Basic Table Management

Advanced Table Management

Constraints, indexes, and Other Specialized Objects

Basic Data Management

Advanced Data Management

Security Management

Performance Monitoring

Proactive Maintenance

Filters