Exam 15: Backup and Recovery

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

A database must be in ____________________ to duplicate redo logs to archive logs.

(Short Answer)
4.9/5
(35)

A(n)computer ____________________ differs from a cluster in that there is no common shared storage area.

(Short Answer)
4.9/5
(33)

RMAN stands for ____________________.

(Short Answer)
4.7/5
(43)

____ logs are copies of old redo log files,copied just before redo log files are reused.

(Multiple Choice)
4.9/5
(43)

How fast does data change in an OLTP database and in a data warehouse? How does this affect recoverability?

(Essay)
4.7/5
(38)

____________________ is the process of executing procedures in Oracle Database to update the recovered backup files to an up to date state.

(Short Answer)
4.8/5
(34)

A(n)____ backup or recovery requires a database to be completely shut down for the backup,and sometimes the recovery process as well.

(Multiple Choice)
4.8/5
(34)

____ is the process of making some kind of copies of parts of a database,or an entire database.

(Multiple Choice)
4.7/5
(31)

What can be done to avoid Oracle Database-induced failures?

(Essay)
4.9/5
(37)

A ____ is a point in time where all buffers are flushed to disk.

(Multiple Choice)
4.9/5
(35)

Typically,many database installations will use a combination of both disk and tape backup storage.

(True/False)
4.9/5
(37)

Oracle backup and recovery is actually broken up into ____ separate actions.

(Multiple Choice)
4.7/5
(37)

OLTP databases are often required to be available on a 24-hour basis.

(True/False)
4.7/5
(26)

Restoration of a recovered backup is a simple process of applying redo log entries to the datafile,until the datafile "catches up" to the time indicated by the archive log.

(True/False)
4.7/5
(46)

If you ever need to restore from a cold backup,you would need to restore at least all the datafiles and controlfiles.

(True/False)
5.0/5
(37)

The redo log buffer is always larger than the database buffer cache.

(True/False)
4.8/5
(39)

A(n)____________________ tablespace is a physical copy of a tablespace (containing data),plus an export utility dump of metadata (from the SYSTEM tablespace).

(Short Answer)
4.9/5
(40)

An abort shutdown of a database,or a power failure,kills all processes and clears all memory buffers immediately,regardless of what is executing in the database.

(True/False)
4.8/5
(34)

Flashback technology relies generally on a combination of undo data,and ____.

(Multiple Choice)
4.9/5
(41)

Recovery of a controlfile does not actually involve any kind of recovery process,but rather one of restoration or rebuilding of the controlfile.

(True/False)
4.8/5
(29)
Showing 61 - 80 of 86
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)