Bookmark

Forum | Directory | Blog |

Oracle PL-SQL Interview Questions and Answers

» Oracle Database » Oracle PL-SQL

Oracle PL-SQL questions updated at 24 May 10 in Category Oracle and visited 57878 Times

Select Question To View Answers

	Download Oracle PL-SQL Interview Questions And Answers PDF

Oracle PL-SQL Questions and Answers:

41 :: What are the modes of parameters that can be passed to a procedure?

IN,OUT,IN-OUT parameters.

Is This Answer Correct?

1 Yes

0 No

42 :: What are the two parts of a procedure?

Procedure Specification and Procedure Body.

Is This Answer Correct?

1 Yes

0 No

43 :: Give the structure of the procedure?

PROCEDURE name (parameter list.....)
is
local variable declarations
BEGIN
Executable statements.
Exception.
exception handlers
end;

Is This Answer Correct?

1 Yes

0 No

44 :: Give the structure of the function?

FUNCTION name (argument list .....) Return datatype is
local variable declarations
Begin
executable statements
Exception
execution handlers
End;

Is This Answer Correct?

1 Yes

0 No

45 :: Explain how procedures and functions are called in a PL/SQL block?

Function is called as part of an expression.
sal := calculate_sal ('a822');
procedure is called as a PL/SQL statement
calculate_bonus ('A822');

Is This Answer Correct?

1 Yes

0 No

Oracle PL-SQL Interview Questions and Answers

« previous 1 2 3 4 5 6 7 8910 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 19 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

Subscribe for email:

Delivered by Feed Burner

Please Like our Facebook Page!

Please give us a +1 !