Multiple choice technology databases

In which section is a user-defined exception trapped?

  1. Declaration

  2. Execution

  3. Exception

  4. Header
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The Exception section (also called exception handler) is where user-defined and predefined exceptions are trapped and handled using WHEN clauses. The Declaration section declares variables and exceptions, the Execution section contains the main logic, and there is no 'Header' section in PL/SQL block structure.

Keep practicing — related questions