Question 93 While observing the index statistics, you find that the index is highly fragmented, thereby resulting in poor database performance. Which option would you use to reduce the fragmentation without affecting the users who are currently using the index?
change the block space utilization parameters using ALTER INDEX command
deallocate the unused space in the index using ALTER INDEX..DEALLOCATE UNUSED command
rebuild the index using ALTER INDEX..REBUILD ONLINE command
validate the index structure
Want to practice for 1Z0-031 - Oracle9i Database: Fundamentals I ?