Multiple choice technology databases

___ exception is raised ___ whenever your PL/SQL program violates an Oracle rule or exceeds a system-dependent limit

  1. internal, explicitly

  2. internal, implicitly

  3. user-defined, explicitly

  4. user-defined, implicitly
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Internal exceptions (like NO_DATA_FOUND or ZERO_DIVIDE) are raised implicitly by the Oracle runtime engine whenever a program violates a database rule. User-defined exceptions, conversely, are typically raised explicitly by the programmer using the RAISE statement.

Keep practicing — related questions