Oracle
1Z0-117 · Question #107
When would bind peeking be done for queries that vary only in values used in the WHERE clause?
The correct answer is B. When the column used in the WHERE clause has evenly distributed data and index exists on that column. See the full explanation below for the reasoning.
Question
When would bind peeking be done for queries that vary only in values used in the WHERE clause?
Options
- AWhen the column used in the WHERE clause has evenly distributed data and histogram exists on that column.
- BWhen the column used in the WHERE clause has evenly distributed data and index exists on that column.
- CWhen the column used in the WHERE clause has non uniform distribution of data, uses a bind variable,
- DWhen the column used in the WHERE clause has non uniform distribution of data and histogram exists for
How the community answered
(66 responses)- A9% (6)
- B85% (56)
- C5% (3)
- D2% (1)
Community Discussion
No community discussion yet for this question.