Multiple choice technology databases

Types of PL/SQL exceptions are

  1. Named System Exceptions

  2. Unnamed System Exceptions

  3. Implicit Exceptions

  4. Explicit Exceptions

  5. User-defined Exceptions
Reveal answer Fill a bubble to check yourself
A,B,E Correct answer
Explanation

PL/SQL exceptions are categorized into three types: Named System Exceptions (pre-defined by Oracle), Unnamed System Exceptions (handled via Pragma EXCEPTION_INIT), and User-defined Exceptions (declared by the developer for specific business logic). 'Implicit' and 'Explicit' refer to how they are raised, not their type.

Keep practicing — related questions