D enable deferrable option exists not enable deferred

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: 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 QUESTION 36: In the event of an Instance failure, which files store committed data, NOT written to the datafiles? A. Control files B. Online redo logs C. Network segment D. Archived redo logs Answer: B Explanation: Answer B is correct. Online redo logs are used to recover committed data, not written to the datafiles, after an instance failure. Incorrect Answers: 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.

Ask a homework question - tutors are online