Oracle Database: Advanced PL/SQL — Question 30

Which two are true about exception handling? (Choose two.)

Answer options

• A. Internally defined exceptions can be handled only by the OTHERS exception handler.
• B. All declared exceptions are raised implicitly by the runtime system.
• C. User-defined exceptions can be defined in the declarative part of any PL/SQL anonymous block, subprogram, or package.
• D. Only predefined exceptions and user-defined exceptions can have a user-declared name associated with them.
• E. Predefined exceptions are globally declared in the standard package.

Correct answer: C, E

Explanation

Option C is correct because user-defined exceptions can indeed be declared in various PL/SQL constructs. Option E is also correct as predefined exceptions are part of the standard package and accessible globally. Options A, B, and D are incorrect because they misrepresent how exceptions are managed and declared in PL/SQL.