Dbafreespace view shows free space in a certain

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: DBA_FREE_SPACE view shows free space in a certain tablespace. Incorrect Answers: 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 QUESTION 15: 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 Explanation: Answer A is correct....
View Full Document

Ask a homework question - tutors are online