Multiple choice technology databases

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.
Reveal answer Fill a bubble to check yourself
A,B,C,D,E Correct answer
Explanation

All listed cases prevent predicate evaluation offload to Exadata Cell. Fast full scans on reverse key indexes cannot be offloaded due to index structure. Row dependencies or ROWID fetching require database-level processing. ROWID-ordered scans bypass cell offloading capabilities. CREATE INDEX with nosort requires database-side processing. LOB/LONG column queries need database-level handling due to size and complexity.

Keep practicing — related questions