Predicate evaluation is not offloaded to Exadata Cell in the following cases:

  1. A fast full scan is performed on reverse key indexes.

  2. The table has row dependencies enabled or the rowscn is being fetched.

  3. The optimizer wants the scan to return rows in ROWID order.

  4. The command is CREATE INDEX using nosort.

  5. A LOB or LONG column is being selected or queried.


Correct Option: A,B,C,D,E

Find more quizzes: