Online index rebuild functionality has been extended to include which four index structures? (Choose four.)
A. Bitmap indexes
B. Reverse key indexes
C. Function-based indexes
D. Key-compressed indexes on regular tables
E. Key-compressed indexes on IOT (including secondary indexes)
Answer: B, C, D, E
Explanation:
It’s possible to rebuild reverse key, function-based, key-compressed indexes on regular tables and on IOT (including secondary indexes).
Incorrect Answers
A: Oracle9i does not currently support online index rebuilding for bitmap or partitioned local and global indexes.
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 74-83
Chapter 2: Availability Enhancements
Oracle 9i New Features, Robert Freeman, p. 46-53
Chapter 2: Oracle9i Architecture Changes
No comments:
Post a Comment