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.
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
Which type of index should be created to spread the distribution of index upon across the
Actualtests.com - The Power of Knowing 1Z0-023
A. B-tree indexes.
B. Bitmap indexes.
C. Reverse-key indexes.
D. Function-based indexes.
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
- Fall '09
- Oracle Database, Jason S. Couchman, DBA Certification Exam, Certification Exam Guide