In addition to overall storage allocation for objects

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: In addition to overall storage allocation for objects in the database, Oracle allows you to manage how the objects use the space they are given. Space usage is determined at the block level with the PCTFREE and PCTUSED options. Incorrect Answers: B: Block space utilization can be specified only at the segment level, not in the data dictionary. C: Block space utilization can be specified only at the segment level, not at the tablespace. D: Block space utilization can be specified at the segment level only, not at the tablespace. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 350-351 Chapter 7: Managing the Physical Database Structure QUESTION 16: Which type of index should be created to spread the distribution of index upon across the Actualtests.com - The Power of Knowing 1Z0-023 index tree? A. B-tree indexes. B. Bitmap indexes. C. Reverse-key indexes. D. Function-based indexes. Answer: C Explanation: Answer C is correct. Reverse-key indexes is the same as a regular B-tree index, except one thing - the data from the column being indexed is stored in reverse order....
View Full Document

Ask a homework question - tutors are online