Multiple choice technology databases

Identify the MANDATORY sections of a PL/SQL block

  1. DECLARE

  2. BEGIN

  3. EXCEPTION

  4. END
Reveal answer Fill a bubble to check yourself
B,D Correct answer
Explanation

In PL/SQL block structure, only the execution section (BEGIN) and its terminator (END) are mandatory. The declaration section (DECLARE) is optional and only needed when declaring variables, cursors, or exceptions. The exception handling section (EXCEPTION) is also optional.

Keep practicing — related questions