CompTIA
Exam Vouchers
Save money on CompTIA exams
| Question of the day
Sign up to receive
interactive practice questions
for MCSE, CompTIA
Cisco and other exams
| TestKing
Get MCSE, MCSD, CCNA, CCNP,A+, N+ and many more | * ExamSheets *
Guide for Success!
Actual Questions & Answers
MCSE, MCSD, A+ ,CCNA, CCNP
Oracle 8i, Oracle 9i Online practice tests
Certification sites Online university Online college Online education Distance learning Software forum Server administration forum Programming resources
|
|  |
| Author |
Need help on 1Z0-001 question!
|
sid456
Senior Member
Registered: Apr 2000
Location:
Country: China
State:
Certifications: MCSE
Working on: OCP Developer
Total Posts: 122
|
|
 Need help on 1Z0-001 question!
In which section of a PL/SQL block is a
user-defined exception raised?
a. execution
b. declarative
c. heading
d. exception handling
Your help please!
Report this post to a moderator
|
|
 02-08-02 11:58 AM
|
|
aneesh_bhatia
Senior Member
M
Registered: Feb 2001
Location: Houston
Country: United States
State:
Certifications: OCP Developer 6/6i, OCP DBA 8i
Working on:
Total Posts: 109
|
|
 Re: Need help on 1Z0-001 question!
quote:
Originally posted by sid456
In which section of a PL/SQL block is a
user-defined exception raised?
a. execution
b. declarative
c. heading
d. exception handling
Your help please!
D: Exception Handling Section 
Report this post to a moderator
|
|
|
02-08-02 12:19 PM
|
|
metto666
Junior Member
Registered: Oct 2001
Location:
Country: Egypt
State:
Certifications:
Working on: Oracle "OCP DEVELOPER"
Total Posts: 21
|
|
 Here is The Right Answer.
In which section of a PL/SQL block is a
user-defined exception raised?
The Answer is :
a. execution
Mohamed Metwally
Report this post to a moderator
|
|
|
02-08-02 01:25 PM
|
|
siddharth_k
Junior Member
Registered: Dec 2001
Location:
Country: India
State:
Certifications: Oracle
Working on:
Total Posts: 12
|
|
|
|
02-09-02 05:58 AM
|
|
Ian_J
Member
Registered: Jun 2001
Location: London
Country: United Kingdom
State:
Certifications: OCP 8i DBA
Working on:
Total Posts: 38
|
|
|
|
02-09-02 06:53 AM
|
|
siddharth_k
Junior Member
Registered: Dec 2001
Location:
Country: India
State:
Certifications: Oracle
Working on:
Total Posts: 12
|
|
|
i believe exception block lies within execution block now ... its upto you to decide..
the general structure is something like
decln
begin
exception
exception handler
end
...
so its upto you to decide
Report this post to a moderator
|
|
|
02-09-02 11:51 AM
|
|
metto666
Junior Member
Registered: Oct 2001
Location:
Country: Egypt
State:
Certifications:
Working on: Oracle "OCP DEVELOPER"
Total Posts: 21
|
|
 Hey u Must to Study Well !!!!!!
Hello ,
Here is Exception Types :
1- Predefined oracle server error
" Don't Declare and Allow The Oracle server to raise Them Implicitly"
2- Non-Predefined Oracle Server error
"Declare Within The Declarative Section and allow the oracle server to raise them Implicitly"
3- User-Defined Error
"A condition that The Developer Determines is Abnormal, Declare Within The Declarative Section And Raise Explicitly"
EX for The User-Defined Exceptions :
Declare
e_invalid_product Exception;
Begin
..........
Raise e_invalid_product;
Exception
When e_invalid_product THEN ........
End;
So We Raise it in The Execution Section.
Mohamed Metwally
Report this post to a moderator
|
|
|
02-09-02 01:33 PM
|
|
odonata
Senior Member
Registered: Jan 2002
Location:
Country: USA
State:
Certifications: OCP (App. Dev.)
Working on: Java
Total Posts: 226
|
|
Read the Question Carefull - this is a great question!
keywords here is the USER-DEFINED and WHERE it is RAISED.
So, as Ian_j and metto wrote, definitely execution section!
Report this post to a moderator
|
|
|
02-09-02 02:27 PM
|
|
siddharth_k
Junior Member
Registered: Dec 2001
Location:
Country: India
State:
Certifications: Oracle
Working on:
Total Posts: 12
|
|
|
|
02-10-02 04:00 AM
|
|
|
Oracle exam notes
Forum Rules:
Who Can Read The Forum? Any registered user or guest.
Who Can Post New Topics? Any registered user.
Who Can Post Replies? Any registered user.
Changes: Messages can be edited by their author.
Posts: HTML code is OFF. Smilies are ON. vB code is ON. [IMG] code is ON. |
|
ExamNotes forum archive
|
