Incorrect answers b lgwr will not write changes to

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: ill not write changes to the next online redo log group. Oracle instance will fail. C: Oracle instance will not hang, like it does when there is no space for archived log files, it will just crash. D: Restarting of archive process ARCH will not help in this situation, because instance will fail. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 330-332 Chapter 7: Managing the Physical Database Structure QUESTION 88: A data block is put on the free list when the _____ data space in the block falls _____ the _______ setting. A. Free, below, PCTFREE B. Free, above, PCTFREE C. Used, below, PCTUSED D. Used, above, PCTUSED Answer: C Explanation: Answer C is correct. When the used data space in the block falls below the PCTUSED setting, a data block is put on the free list of blocks and can be used for new inserts. Incorrect Answers: A: When the free data space in the block falls below the PCTFREE settings a data block will be out of the free list. B: The free data space in the block cannot fall above the PCTFREE setting, it can fall just below it. D: The used data space in th...
View Full Document

Ask a homework question - tutors are online