|
Explanation: During a query's parse time Oracle 9i flags an index as being used in the V$OBJECT_USAGE view. You can query the V$OBJECT_USAGE view to review the index utilization data. If the index has been used within the period of time it was monitored, the USED column within this view will contain a YES value; it will contain a NO otherwise. Incorrect Answer: 2: During a query's execution time Oracle 9i does not flag an index as being used in the V$OBJECT_USAGE view. 3: Oracle 9i flags an index as being used in the V$OBJECT_USAGE view during a query's parse time, not during any kind of DML statement execution. 4: Oracle 9i flags an index as being used in the V$OBJECT_USAGE view during a query's parse time, not during execution of an INSERT statement. Reference: OCP Oracle 9i Database: New Features for Administrators, Daniel Benjamin, p. 212-214 Chapter 4: Performance and Scalability Enhancements Oracle 9i New Features, Robert Freeman, p. 56-57 Chapter 2: Oracle 9i Architecture Changes
|