Exam 15: Backup and Recovery

A(n)____ standby database can potentially pass log entries to a standby database server,log entry by log entry.In other words,each transaction is applied to the standby immediately after application to the primary database.

Free

(Multiple Choice)

4.9/5

(80)

Question 1

Correct Answer:

Verified

How does a cold backup work?

Free

(Essay)

4.9/5

(89)

Question 2

Correct Answer:

Verified

A cold backup requires that a database be completely shut down.When a database is shut down,no activity can take place,and thus no changes can be made to the database.This allows for a consistent snapshot of the database to be copied for which all database files are copied at a state at a specific time.

Restoration can utilize entries in both redo log files and archive log files to complete a recovery.

Free

(True/False)

4.8/5

(78)

Question 3

Correct Answer:

Verified

True

Placing a tablespace into backup mode forces all change activity for that tablespace to be copied to the redo logs.

(True/False)

4.9/5

(66)

Question 4

If records are not available in archive log files,they are likely to be stored in undo logs.

(True/False)

4.9/5

(75)

Question 5

You should never multiplex controlfiles.

(True/False)

4.9/5

(86)

Question 6

____________________ recovery implies that a file (the datafile)is out of date for that tablespace.

(Short Answer)

4.9/5

(89)

Question 7

The objective of a(n)____________________ backup is to obtain a snapshot of all data in the database.

(Short Answer)

4.9/5

(74)

Question 8

With respect to a backup strategy,what is the acceptable loss upon failure?

(Essay)

4.9/5

(71)

Question 9

A(n)____________________ is a little like a Unix pipe where data can simply be pushed onto the pipe and pulled off the pipe at the other end of it.

(Short Answer)

4.7/5

(91)

Question 10

You should always ____________________ controlfile so you have a copy that can simply be plugged into a shutdown database.

(Short Answer)

4.8/5

(73)

Question 11

A(n)____________________ database is a backup database,which can be used to replace a primary customer facing database virtually in seconds,and even automatically,in the event of a primary database failure.

(Short Answer)

4.8/5

(80)

Question 12

The ____________________ contain pointers to datafiles,dictating where datafiles should be in relation to redo log entries.

(Short Answer)

4.9/5

(74)

Question 13

____ logs are files that are copied from redo logs when a redo log file is switched out for recycling.

(Multiple Choice)

4.9/5

(78)

Question 14

Redo logs should always be ____.

(Multiple Choice)

4.8/5

(73)

Question 15

The shorter the time between successive checkpoints,the more transactional changes to a database you could lose.

(True/False)

4.8/5

(80)

Question 16

A hot backup takes a snapshot of the entire physical structure of a database (all the datafiles,controlfiles,redo logs,and archive logs);if the database is not shut down,and any changes are made during the copy process,an inconsistent backup will result.

(True/False)

4.8/5

(80)

Question 17

Copying redo log files from a cold backup back into a database is only necessary when redo log files have been lost.

(True/False)

4.9/5

(76)

Question 18

____ failure is much more likely than any other failure situation,such as dropping a table that should not be dropped.

(Multiple Choice)

4.9/5

(65)

Question 19

When managing a database,how can you plan for potential disaster and recovery?

(Essay)

4.9/5

(76)

Question 20

Showing 1 - 20 of 86

A(n)____ standby database can potentially pass log entries to a standby database server,log entry by log entry.In other words,each transaction is applied to the standby immediately after application to the primary database.

How does a cold backup work?

Restoration can utilize entries in both redo log files and archive log files to complete a recovery.

Placing a tablespace into backup mode forces all change activity for that tablespace to be copied to the redo logs.

If records are not available in archive log files,they are likely to be stored in undo logs.

You should never multiplex controlfiles.

____________________ recovery implies that a file (the datafile)is out of date for that tablespace.

The objective of a(n)____________________ backup is to obtain a snapshot of all data in the database.

With respect to a backup strategy,what is the acceptable loss upon failure?

A(n)____________________ is a little like a Unix pipe where data can simply be pushed onto the pipe and pulled off the pipe at the other end of it.

You should always ____________________ controlfile so you have a copy that can simply be plugged into a shutdown database.

A(n)____________________ database is a backup database,which can be used to replace a primary customer facing database virtually in seconds,and even automatically,in the event of a primary database failure.

The ____________________ contain pointers to datafiles,dictating where datafiles should be in relation to redo log entries.

____ logs are files that are copied from redo logs when a redo log file is switched out for recycling.

Redo logs should always be ____.

The shorter the time between successive checkpoints,the more transactional changes to a database you could lose.

A hot backup takes a snapshot of the entire physical structure of a database (all the datafiles,controlfiles,redo logs,and archive logs);if the database is not shut down,and any changes are made during the copy process,an inconsistent backup will result.

Copying redo log files from a cold backup back into a database is only necessary when redo log files have been lost.

____ failure is much more likely than any other failure situation,such as dropping a table that should not be dropped.

When managing a database,how can you plan for potential disaster and recovery?

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