Oracle Database 11g: Program with PL/SQL — Question 55

Which type of exceptions is qualified as nonpredefined Oracle server errors?

Answer options

• A. the exceptions that are explicitly raised by the program and can be caught by the exception handler
• B. the exceptions that are raised implicitly by the Oracle server and can be caught by the exception handler
• C. an exception that the developer determines as abnormal, are in the declarative section and raised explicitly
• D. an exception that is raised automatically when the PL/SQL program violates a database rule or exceeds a system-dependent limit

Correct answer: B

Explanation

The correct answer is B because nonpredefined Oracle server errors refer to exceptions raised automatically by the server, which can still be handled by the exception handler. Options A and C pertain to exceptions explicitly raised by the program, while D describes exceptions related to violations of rules or limits, not specifically categorized as nonpredefined errors.