Multiple choice technology databases

In order to know which SQL operator or function can be referenced in predicate without violating the Exadata Cell offload, you can query OFFLOADABLE column of V$SQLFN_METADATA view. The value “NO” indicates offloading is allowed.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Querying the V$SQLFN_METADATA view's OFFLOADABLE column indicates whether an operator can be offloaded to Exadata cells. The value 'YES' indicates offloading is allowed, while 'NO' indicates it is not, making the statement false.

Keep practicing — related questions