In the event that a redo log is found to be corrupt

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: a redo log is found to be corrupt by the checksum process, the DBA must backup the database. Incorrect Answers: A: There is no RECOVER REDOLOG GROUP 1 command in Oracle. B: This command should be used for cancel-based incomplete recovery. C: There is no ALTER DATABASE RECOVER REDOLOG command in Oracle. E: This command should be used for time-based incomplete recovery. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 662-663 Chapter 14: Database Failure and Recovery QUESTION 38: Which statement about 'time-based recovery' is true? A. Recovery is stopped by entering CANCEL at the recovery prompt. B. Recovery is stopped by pressing at <CTL-C> the recovery prompt. C. Recovery is stopped after the database has committed all changes up to the specified point of time. Actualtests.com - The Power of Knowing 1Z0-025 D. Recovery is stopped when the database has committed all changes up to the specified system changes number (SCN). E. Recovery is stopped when the specified method of recovery (CANCEL, TIME, or CHANGE) Answer: C Explanation: Time-based recovery will stop after the database has committed all changes up to the specified point in time. If uncommitte...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online