In which three cases should you collect statistics manually? (Choose three)

In which three cases should you collect statistics manually? (Choose three)

In which three cases should you collect statistics manually? (Choose three)

A.
For large objects (LOBs)

B.
For fixed objects

C.
For external tables

D.
For undo tablespaces

E.
For schema statistics

F.
For tables that are bulk loaded

Explanation:
You must gather statistics manually for the following situations:
1. When a table is loaded using bulk operation
2. When using external tables
3. To collect system statistics
To collect statistics on fixed objects.



Leave a Reply 0

Your email address will not be published. Required fields are marked *