D the used data space in the block cannot fall above

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 block cannot fall above the PCTUSED setting, it can just fall below it. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 350-352 Chapter 7: Managing the Physical Database Structure QUESTION 89: Which two data dictionary views show the number of extents of a certain segment? (Choose two) Actualtests.com - The Power of Knowing 1Z0-023 A. V$EXTENTS B. DBA_EXTENTS C. DBA_SEGMENTS D. DBA_TABLESPACES Answer: B, C Explanation: Answers B and C are correct. DBA_EXTENTS view displays the segment name, type, owner, name of tablespace storing the extent, ID for the extent, file ID storing the extent, starting block ID of the extent, total bytes, and blocks of the extent. DBA_SEGMENTS view is summary view for all types of segments listed by the data dictionary views and their storage parameters. Incorrect Answers: A: There is no V$EXTENTS view in Oracle. D: DBA_TABLESPACES shows the default storage settings for the tablespaces in the database. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 352-353 Chapter 7...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online