1Z0-149: Oracle Database Program with PL/SQLDemo

By Oracle · Question Mode

QuestionQ43

PL/SQL Language Fundamentals

Which two statements about exception handling are true?

Choose two
  • 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.
Explanation

User-defined exceptions may be declared in the declarative part of any PL/SQL anonymous block, subprogram, or package. Predefined exceptions are internally defined exceptions with names that PL/SQL declares globally in the STANDARD package. Internally defined exceptions can be associated with a declared name by using EXCEPTION_INIT, and user-defined exceptions are raised explicitly.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!