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
B
B
a c
When they say “no predefined Oracle server errors” I think they are talking about Internally Defined Exceptions.
From the book Oracle® Database PL/SQL Language Reference 11 g Release 2 (11.2) E25519-03:
———
Internally defined exceptions (ORA-n errors) are described in Oracle Database Error
Messages. The run-time system raises them implicitly (automatically).
An internally defined exception does not have a name unless either PL/SQL gives it
one (see “Predefined Exceptions” on page 11-10) or you give it one.
If you know that your database operations might raise specific internally defined
exceptions that do not have names, then give them names so that you can write
exception handlers specifically for them. Otherwise, you can handle them only with
OTHERS exception handlers.
—–
I would say answer is B – the exceptions that are raised implicitly by the Oracle server and can be caught by the exception handler.
This kind of exception cannot be directly caught, but you can write exception handlers specifically for them or you can handle them with OTHERS exception handler.
a,c,d
see to NO in the question…….
be careful Alex , and Vladimir too , predefined exception are
exactly the countrary of ………………..
Which type of exceptions is qualified as no predefined Oracle server errors?
oracle redefined exception are “normally” raised implicit from system
and handled by name because are pre defined into the standard sal dipendence.
so , exatly the countrary of B
but i don’t know what is intended with raised automatically ??? D case
exception are raise implicity and explicity
what does it means automatically ? , means implicity ?
i’ m not sure for D
certainly i am sure… not B
B
No predefined exception i.e User Defined Exception
User defines an exception in declarative sectn and raises it in Execution block. So the ans is C
The keys of this questions are that “NO” and “Oracle Server Errors”. So we’re talking about server errors which means that the answer couldn’t be C or A.
That “NO” sounds like “NOT”, which for sure means not B.
So I strongly agree with Piero and I say D.
Guys, yesterday I take the exam passed with 90% score.
This title is WRONG! The right title is
“which type of exceptions is qualified as nonpredefined oracle server errors”
nonpredefined is just one word.
I’ve answered D. Bye!
Any question:
https://it.linkedin.com/in/fabiodipierno
HI.are these questions are enough to pass the test? please let me know..
thankyou in advance.
B
Quote from Oracle Database 11g: Advanced PL/SQL course (D52601GC20):
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.
DECLARE
e_MissingNull EXCEPTION;
PRAGMA EXCEPTION_INIT(e_MissingNull, -1400);
BEGIN
INSERT INTO employees (id) VALUES (NULL);
EXCEPTION
WHEN e_MissingNull then
DBMS_OUTPUT.put_line(‘ORA-1400 occurred’);
END;
B
B
Non-predefined TimesTen error
Any other standard TimesTen error
These must be declared in the declarative section of your application.
TimesTen implicitly raises the error and you can use an exception handler to catch the error.
B
B
Yes, I now tend to agree it’s D. If I were doing the exam today I would answer D.
B
https://docs.oracle.com/cd/E21901_01/timesten.1122/e21639/exceptions.htm#TTPLS195
There are three types of exceptions.
1-(Predefined Oracle Server error) One of approximately 20 errors that occur most often in PL/SQL code.
You need not declare these exceptions. They are predefined by the Oracle server and are raised implicitly.
2-(Non-predefined Oracle Server error) Any other standard Oracle Server error.
You need to declare these within the declarative section;
the Oracle server will raise the error implicitly, and you can catch for the error in the exception handler.
3-(User-defined error) A condition that the developer determines is abnormal .
Declare in the declarative section and raise explicitly.
so the answer is B.
Non-Predefined Oracle Server Errors – Declare within the declarative section and allow the Oracle Server to raise them implicitly
B
b
Non-predefined TimesTen error Any other standard TimesTen error
These must be declared in the declarative section of your application. TimesTen implicitly raises the error and you can use an exception handler to catch the error.
https://docs.oracle.com/database/121/TTPLS/exceptions.htm#TTPLS195
ANS: B