Oracle
1Z0-064 · Question #75
Which two statements are true about gathering statistics? (Choose two.)
The correct answer is A. If an application has only SQL statements with bind variables, it is better to drop existing B. If end users query newly inserted data, it is possible to get a suboptimal execution plan even if the. See the full explanation below for the reasoning.
Question
Which two statements are true about gathering statistics? (Choose two.)
Options
- AIf an application has only SQL statements with bind variables, it is better to drop existing
- BIf end users query newly inserted data, it is possible to get a suboptimal execution plan even if the
- CIf concurrent statistics gathering is done by using parallel execution, the Resource Manager
- DFor each session that is accessing a global temporary table, the optimizer uses only the shared
How the community answered
(26 responses)- A77% (20)
- C15% (4)
- D8% (2)
Community Discussion
No community discussion yet for this question.