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 57972 Times

Select Question To View Answers

	Download Oracle PL-SQL Interview Questions And Answers PDF

Oracle PL-SQL Questions and Answers:

46 :: What is Overloading of procedures?

The Same procedure name is repeated with parameters of different datatypes and parameters in different positions, varying number of parameters is called overloading of procedures.
e.g. DBMS_OUTPUT put_line
What is a package ? What are the advantages of packages ?

Is This Answer Correct?

1 Yes

0 No

47 :: What are two parts of package?

The two parts of package are PACKAGE SPECIFICATION & PACKAGE BODY. Package Specification contains declarations that are global to the packages and local to the schema.
Package Body contains actual procedures and local declaration of the procedures and cursor declarations.

Is This Answer Correct?

1 Yes

0 No

48 :: What is difference between a Cursor declared in a procedure and Cursor declared in a package specification?

A cursor declared in a package specification is global and can be accessed by other procedures or procedures in a package.
A cursor declared in a procedure is local to the procedure that can not be accessed by other procedures.

Is This Answer Correct?

1 Yes

0 No

49 :: How packaged procedures and functions are called from the following?
a. Stored procedure or anonymous block
b. an application program such a PRC C, PRO COBOL
c. SQL *PLUS

a. PACKAGE NAME.PROCEDURE NAME (parameters);
variable := PACKAGE NAME.FUNCTION NAME (arguments);
EXEC SQL EXECUTE
b.
BEGIN
PACKAGE NAME.PROCEDURE NAME (parameters)
variable := PACKAGE NAME.FUNCTION NAME (arguments);
END;
END EXEC;
c. EXECUTE PACKAGE NAME.PROCEDURE if the procedures does not have any out/in-out parameters. A function can not be called.

Is This Answer Correct?

1 Yes

0 No

50 :: Name the tables where characteristics of Package, procedure and functions are stored?

User_objects, User_Source and User_error.

Is This Answer Correct?

2 Yes

1 No

Oracle PL-SQL Interview Questions and Answers

« previous 1 2 3 4 5 6 7 8 91011 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 !

Oracle PL-SQL Interview Questions and Answers

Oracle PL-SQL Questions and Answers:

46 :: What is Overloading of procedures?

47 :: What are two parts of package?

48 :: What is difference between a Cursor declared in a procedure and Cursor declared in a package specification?

49 :: How packaged procedures and functions are called from the following? a. Stored procedure or anonymous block b. an application program such a PRC *C, PRO* COBOL c. SQL *PLUS

50 :: Name the tables where characteristics of Package, procedure and functions are stored?

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

Hot Interview Categories in Oracle

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

Webmaster Said:

c programming Said:

priyank Said:

Sharique Ahmad Said:

49 :: How packaged procedures and functions are called from the following?
a. Stored procedure or anonymous block
b. an application program such a PRC C, PRO COBOL
c. SQL *PLUS