Bookmark

Forum | Directory | Blog |

Oracle PL-SQL Interview Questions and Answers

» Oracle Database » Oracle PL-SQL

Oracle PL-SQL questions updated at 19 Jun 13 in Category Oracle and visited 58016 Times

Select Question To View Answers

	Download Oracle PL-SQL Interview Questions And Answers PDF

Oracle PL-SQL Questions and Answers:

26 :: Write the order of precedence for validation of a column in a table?
I. done using Database triggers.
ii. done using Integarity Constraints

I & ii.
Exception :

Is This Answer Correct?

1 Yes

0 No

27 :: What is an Exception? What are types of Exception?

Exception is the error handling part of PL/SQL block. The types are Predefined and user defined. Some of Predefined exceptions are.
CURSOR_ALREADY_OPEN
DUP_VAL_ON_INDEX
NO_DATA_FOUND
TOO_MANY_ROWS
INVALID_CURSOR
INVALID_NUMBER
LOGON_DENIED
NOT_LOGGED_ON
PROGRAM-ERROR
STORAGE_ERROR
TIMEOUT_ON_RESOURCE
VALUE_ERROR
ZERO_DIVIDE
OTHERS.

exception is an identifier and error handling part of pl/sql types := 1)predifined
2) user defined.

Is This Answer Correct?

1 Yes

0 No

28 :: What is Pragma EXECPTION_INIT? Explain the usage?

The PRAGMA EXECPTION_INIT tells the complier to associate an exception with an oracle error. To get an error message of a specific oracle error.
e.g. PRAGMA EXCEPTION_INIT (exception name, oracle error number)

Is This Answer Correct?

2 Yes

0 No

29 :: What is Raise_application_error?

Raise_application_error is a procedure of package DBMS_STANDARD which allows to issue an user_defined error messages from stored sub-program or database
trigger.

Is This Answer Correct?

1 Yes

0 No

30 :: What are the return values of functions SQLCODE and SQLERRM?

SQLCODE returns the latest code of the error that has occurred.
SQLERRM returns the relevant error message of the SQLCODE.

Is This Answer Correct?

2 Yes

0 No

Oracle PL-SQL Interview Questions and Answers

« previous 1 2 3 4 567 8 9 10 11 next »

Select appropriate Question to view its more answers in this category of Oracle PL-SQL.

Do you find any Answer incorrect or incomplete? Please e-mail us or place your comment and mention the number of question or if you have correct answer then open the appropriate question by clicking on question and then place your answer in comment regarding particular question in this category "Oracle PL-SQL Interview Questions and Answers" To ensure quality, each change is checked by our team, before it enters the main website database. If you desire so, the changes will be credited to your name.

Subscribe your email to receive free updates:

Enter your email address and get free web tutorials, job hunting tips, career advices, job vacancies and interview questions updates directly delivered to your email inbox

Hot Oracle PL-SQL Frequently Asked Questions

►	How to avoid using cursors? What to use instead of cursor and in what cases to do so?

►	What is difference b/w stored procedures and application procedures, stored function and application function?

►	Explian rowid, rownum?what are the psoducolumns we have?

►	How we can create a table in PL/SQL block. insert records into it? is it possible by some procedure or function? please give example?

►	In a Distributed Database System Can we execute two queries simultaneously? Justify?

Hot Oracle PL-SQL Frequently Asked Questions

Hot Interview Categories in Oracle

►	Oracle Database Frequently Asked Interview Questions and Answers

►	Oracle DBA Frequently Asked Interview Questions and Answers

►	Oracle PL-SQL Frequently Asked Interview Questions and Answers

►	Oracle GL Frequently Asked Interview Questions and Answers

►	Oracle ETL Frequently Asked Interview Questions and Answers

Comments (On Oracle PL-SQL Interview Questions and Answers)

Your email is required but won't be published any where else. Personal information will be kept confidential; we do not sell or release private information.

Webmaster Said:

Jun 20 2013

Your comments will be instantly published after webmaster review. All visitors can submit their comments on Oracle PL-SQL Interview Questions and Answers no registration is required to post your comments. You are welcome to share your ideas, experiences, suggestions questions and answers, but please be respectful of others when commenting. Insulting, self-promotional, website promotion, marketing, SEO Techniques, SMS-style and off-topic comments will not be published. Share your comments regarding Oracle PL-SQL Interview Questions and Answers
Thank you.

Rate this Interview Question and Answer page by placing your comments here please...

c programming Said:

Dec 06 2010

Good work. It has helped me a lot. Thanks.

priyank Said:

Dec 28 2012

KNOE TO LEARN PL\SQL

Sharique Ahmad Said:

May 19 2013

Hi, I am Sharique

Feel Free To Leave Your Comment

Enter Your Name: [Required]

Email Address: [Required] (will not be published)

Website: [Optional]

Enter Image Verification Code: [Must Required] Entering this code helps stop the bad guys.

Comments: [Required]

Limit: HTML Tags <center> are allowed
Subscribe for newsletter/Feeds?

In order to link this page as Reference, click on below text area and pres (CTRL-C) to copy the code in clipboard or pres right click then copy the following lines after that past into your website or Blog.

Get Reference Link To This Page: (copy below code by (CTRL-C) and paste into your website or Blog)

HTML Rendering of above code:

[ Free Web Directory ] [ Global Web Forum ] [ Contact ] [ Links ] [ Site Map ] [ Statistics ] [ Services ] [ Privacy ]
Learn [ HTML ] [ XML ] [ JavaScript ] [ CSS ] [ SQL ]

Home