Multiple choice technology databases

Identify two factors that you consider for compiling a PL/SQL program unit for interpreted mode?

  1. PL/SQL program needs to be recompiled frequently.

  2. /SQL program that spends most of the time executing SQL

  3. PL/SQL program , which performs computation-intensive procedural operations and is recompiled rarely

  4. PL/SQL program , which is called frequently with the same parameter values by multiple sessions and is recompiled rarely.
Reveal answer Fill a bubble to check yourself
A,B Correct answer
Explanation

Interpreted mode is useful when PL/SQL needs frequent recompilation (avoid native compilation overhead) or when the program spends most time executing SQL (interpretation overhead is negligible compared to SQL execution time). Native mode is better for computation-intensive procedural code that's compiled rarely.

Keep practicing — related questions