Exam 15: Backup and Recovery
Exam 1: Oracle Architecture Overview79 Questions
Exam 2: Tools and Architecture100 Questions
Exam 3: Creating an Oracle Instance109 Questions
Exam 4: Oracle Physical Architecture and Data Dictionary Views110 Questions
Exam 5: Basic Storage Concepts and Settings104 Questions
Exam 6: The Basics of Querying a Database109 Questions
Exam 7: Basic Table Management104 Questions
Exam 8: Advanced Table Management84 Questions
Exam 9: Constraints, indexes, and Other Specialized Objects108 Questions
Exam 10: Basic Data Management65 Questions
Exam 11: Advanced Data Management89 Questions
Exam 12: Security Management110 Questions
Exam 13: Performance Monitoring84 Questions
Exam 14: Proactive Maintenance83 Questions
Exam 15: Backup and Recovery86 Questions
Select questions type
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)
____ 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)
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
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)