Multiple choice technology databases

CELL_OFFLOAD_PROCESSING parameter effect can be also achieved by OPT_PARAM hint

  1. True

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

The OPT_PARAM hint can override initialization parameters at the statement level, including CELL_OFFLOAD_PROCESSING. This provides a way to control cell offload behavior for specific queries without changing session or system settings. Using OPT_PARAM('CELL_OFFLOAD_PROCESSING', 'FALSE') in a query hint achieves the same effect as setting the parameter to FALSE at session level.

Keep practicing — related questions