Multiple choice technology databases

In a PL/SQL block structure, which parts are optional?

  1. DELCARE and BEGIN

  2. DECALRE and EXCEPTION

  3. EXCEPTION and END

  4. BEGIN and END
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In a PL/SQL block, only the DECLARE and EXCEPTION sections are optional. Every PL/SQL block must have BEGIN and END keywords to define the executable section. The DECLARE section (for declarations) and EXCEPTION section (for error handlers) can be omitted if not needed.

Keep practicing — related questions