how many types of stored procedure? - Stored Procedure are of two type 1-user define stored procedure 2- System define Stored procedure - Stored Procedures Interview Questions and Answers

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

DATABASE

STORED PROCEDURES

DETAILS

Question: how many types of stored procedure?

Answer: Stored Procedure are of two type
1-user define stored procedure
2- System define Stored procedure

Category	Stored Procedures Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.3) By 7817 users
Added on	7/26/2015
Views	65321
Rate it!

Question: how many types of stored procedure?

Answer:

Stored Procedure are of two type
1-user define stored procedure
2- System define Stored procedure
Source: CoolInterview.com

Answered by: Anjani k Singh | Date: 9/3/2010 |

Contact Anjani k Singh

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	How one call DDL statement using stored procedures in Oracle?	View Answer
	If get_product_name is my procedure called in my stored procedure. here in my procedure i am passing a value directly but i need to pass the value to the procedure dynamically. How it is possible?	View Answer
	What is cursors?	View Answer
	Explain about the RETURN statement?	View Answer
	Explain about the process which takes place to execute a Stored routine?	View Answer
	Explain about recursive stored procedures?	View Answer
	Explain the benefits of running stored procedure on a database engine?	View Answer
	Explain about the implementation of business logic in Stored procedures?	View Answer
	Explain about the difficulties faced by the database developer in implementing pre compiled statements?	View Answer
	Does storing of data in stored procedures increase the access time? Explain?	View Answer
	State about the security aspects of stored procedures?	View Answer
	State the different extensions for stored procedures?	View Answer
	Explain about the implementation of stored procedures?	View Answer
	What is the difference between a user defined function and a Stored procedure?	View Answer
	What are the uses of stored procedure?	View Answer
	what is the Difference between View and Stored Procedure?	View Answer
	Where the procedures are stored in database?	View Answer
	Can we use commit inside the trigger? If not then how can we save the transxaction made by the trigger?	View Answer
	How can we call stored procedures inside store procedures?	View Answer
	what is the difference between stored procedures and stored functions in ORACLE	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All Stored Procedures Interview Questions & Answers - Exam Mode / Learning Mode