This preview shows page 1. Sign up to view the full content.
Unformatted text preview: e block cannot fall above the PCTUSED setting, it can just fall
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 350-352
Chapter 7: Managing the Physical Database Structure
Which two data dictionary views show the number of extents of a certain segment?
(Choose two) Actualtests.com - The Power of Knowing 1Z0-023
Answer: B, C
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.
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
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09