Which type of exceptions is qualified as no predefined Oracle server errors?
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
|
Download Printable PDF. VALID exam to help you PASS. |
 |
Answer: B
CORRECT ANSWER ‘B’ :
Non-predefined Oracle server errors are declared within the declarative section and raised implicitly by the Oracle Server.
In my opinion the most interesting point in oracle document is predefined and non_predefined are implicity raise so for that I think B is the correct answer .
I think correct answer is C
A is not correct because it’s not said if exception predefined or not. It can be explicitly raised by the program in any case.
https://docs.oracle.com/cd/A97630_01/appdev.920/a96624/07_errs.htm
“You can also raise a predefined exception explicitly.”
B is not correct because an exception raised by Oracle Server and can be caught by exception handler.
As exception handler catches exceptions by name, it means that it was predefined exception.
D is not correct according to the following link
https://docs.oracle.com/cd/A97630_01/appdev.920/a96624/07_errs.htm
“An internal exception is raised implicitly whenever your PL/SQL program violates an Oracle rule or exceeds a system-dependent limit. Every Oracle error has a number, but exceptions must be handled by name. So, PL/SQL predefines some common Oracle errors as exceptions. For example, PL/SQL raises the predefined exception NO_DATA_FOUND if a SELECT INTO statement returns no rows.”
On point B:
Non-predefined exceptions: Each of these errors has a standard Oracle error number (ORA-#####) and error message, but not a predefined name.
– You declare your own names for these so that you can reference these names in the exception section.
(C) will come under User defined exceptions.
So the correct answer is B.