A. Creation of an index.
B. Execution of the ANALYZE command.
C. Use of the ORDER BY and GROUP BY clauses.
D. Use of insert operations involving index maintenance.
E. Use of the UNION, INTERSECT and MINUS operators.
Answer: A, C, D, E
Explanation:
All these activities can cause a sort operation. Only if you are creating an index with NOSORT option sorting will not have place.
Incorrect Answers
B: Execution of the ANALYZE command does not require sorting.
OCP: Oracle 9i Performance Tuning Study Guide, Joseph C. Johnson, p. 445-446
Chapter 8: Tuning Disk I/O
No comments:
Post a Comment