Unformatted text preview: DBA_FREE_SPACE view shows free space in a certain tablespace.
A: DBA_EXTENTS view gives information about the number of extents allocated to a table, the
datafiles in which they are stored, and how large each extent is.
B: V$FREESPACE view does not exist in Oracle.
D: DBA_TABLESPACE view shows information about tablespaces, but it does not contain
information about free space in the tablespace.
E: DBA_FREE_EXTENTS view does not exist in Oracle.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 401
Chapter 8: Managing Database Objects I
Which statement about using PCTFREE and PCTUSED is true?
A. Block space utilization can be specified only at the segment level.
B. Block space utilization can be specified only in the data dictionary.
C. Block space utilization parameters can only be specified at the tablespace.
D. Block space utilization can be specified both at the tablespace level and segment level.
Answer A is correct....
View Full Document
- Fall '09
- Oracle Database, Jason S. Couchman, DBA Certification Exam, Certification Exam Guide