Incorrect answers a index segments do not cause

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: e. Incorrect Answers: A: Index segments do not cause extensive fragmentation B: Rollback segments as temporary segments will experience high to very high fragmentation. This is true in the ROLLBACK tablespace because rollback segments have potentially a very short lifespan, and Oracle can allocate and deallocate extents as necessitated by long-running transactions. But lifespan of segments and extents in the TEMPORARY tablespace is much shorter, so fragmentation for temporary segments are higher. C: Data segments do not cause big fragmentation E: Data dictionary segments are not changed very often, they have long lifespan, so they can not cause fragmentation. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 354 Chapter 7: Managing the Physical Database Structure QUESTION 14: Which data dictionary view shows the available free space in a certain tablespace? Actualtests.com - The Power of Knowing 1Z0-023 A. DBA_EXTENTS B. V$FREESPACE C. DBA_FREE_SPACE D. DBA_TABLESPACE E. DBA_FREE_EXTENTS Answer: C Explanation: Answer C is correct....
View Full Document

Ask a homework question - tutors are online