Multiple choice technology web technology

What are the benefits of BIND variables? Choose all that apply

  1. Reduces parsing overhead

  2. Reduces execution overhead

  3. Forces usage of INDEX

  4. Makes code reusable
Reveal answer Fill a bubble to check yourself
A,D Correct answer
Explanation

BIND variables reduce parsing overhead because Oracle can reuse the same parsed statement for different values. They also make code reusable and prevent SQL injection. They don't reduce execution overhead (execution time depends on data volume) and don't force index usage (index choice depends on optimizer and selectivity).

Keep practicing — related questions