This preview shows page 1. Sign up to view the full content.
Unformatted text preview: ABLE option exists, not ENABLE DEFERRED.
E: There is no DISABLE NOVALIDATE option in Oracle, just DESABLE.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 436
Chapter 9: Managing Database Objects II
In the event of an Instance failure, which files store committed data, NOT written to the
A. Control files
B. Online redo logs
C. Network segment
D. Archived redo logs
Answer B is correct. Online redo logs are used to recover committed data, not written to the
datafiles, after an instance failure.
A: Control files are used to store structure of database to mount and open database, they do not
store committed data.
C: There is no network segment object in Oracle.
D: Archived redo logs stores ALL data, not only committed and, probably written to the
datafiles. These files can be used for instance recovery, but this answer is not completely correct
Actualtests.com - The Power of Knowing 1Z0-023
for the given question.
Oracle 8, DBA Cer...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09