nerdexam
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)
  • A
    9% (6)
  • B
    85% (56)
  • C
    5% (3)
  • D
    2% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-117 Practice