Which type of exceptions is qualified as no predefined Oracle server errors?

The correct answer is B. the exceptions that are raised implicitly by the Oracle server and can be caught by the exception. Non-predefined exceptions are similar to predefined exceptions; however, they are not defined as PL/SQL exceptions in the Oracle server. They are standard Oracle errors. You can create exceptions with standard Oracle errors by using the PRAGMA EXCEPTION_INIT function. Such…

Handling Exceptions

Question

Options

Athe exceptions that are explicitly raised by the program and can be caught by the exception
Bthe exceptions that are raised implicitly by the Oracle server and can be caught by the exception
Can exception that the developer determines as abnormal, are in the declarative section and raised
Dan exception that is raised automatically when the PL/SQL program violates a database rule or

How the community answered

(56 responses)

A
14% (8)
B
77% (43)
C
5% (3)
D
4% (2)

Explanation

Non-predefined exceptions are similar to predefined exceptions; however, they are not defined as PL/SQL exceptions in the Oracle server. They are standard Oracle errors. You can create exceptions with standard Oracle errors by using the PRAGMA EXCEPTION_INIT function. Such exceptions are called nonpredefined exceptions. You can trap a nonpredefined Oracle server error by declaring it first. The declared exception is raised implicitly. e_MissingNull EXCEPTION; PRAGMA EXCEPTION_INIT(e_MissingNull, -1400); INSERT INTO employees (id) VALUES (NULL); WHEN e_MissingNull then DBMS_OUTPUT.put_line('ORA-1400 occurred');

Topics

#non-predefined exceptions#Oracle server errors#implicit exceptions#exception types

Community Discussion

No community discussion yet for this question.

Full 1Z0-144 Practice