Multiple choice technology databases

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

  1. The predicate evaluation is on a virtual column.

  2. The tablespace is not completely stored on Exadata Cell.

  3. A scan is performed on a flashback table.

  4. The command is CREATE INDEX using nosort.
Reveal answer Fill a bubble to check yourself
A,B,C,D Correct answer
Explanation

Virtual column predicates cannot be offloaded because they require computation. If the tablespace is not fully on Exadata Cell, offload is impossible. Flashback table scans require database-level processing. CREATE INDEX with nosort needs database-side sorting operations that cannot be pushed to storage cells.

Keep practicing — related questions