Explain The Benefits Of Running Stored Procedure On A Database Engine

1.	Explain The Benefits Of Running Stored Procedure On A Database Engine?
Answer» Stored procedures can run DIRECTLY run on a data base ENGINE. In industries where automation is the key a stored procedure can run entirely on the data base provided to it and this runs on a specialized data base server. Network communication can be avoided. Also this procedure is useful for execution of complex SQL STATEMENTS. Stored procedures can run directly run on a data base engine. In industries where automation is the key a stored procedure can run entirely on the data base provided to it and this runs on a specialized data base server. Network communication can be avoided. Also this procedure is useful for execution of complex SQL statements.

Explain The Benefits Of Running Stored Procedure On A Database Engine?

Answer»

Stored procedures can run DIRECTLY run on a data base ENGINE. In industries where automation is the key a stored procedure can run entirely on the data base provided to it and this runs on a specialized data base server. Network communication can be avoided. Also this procedure is useful for execution of complex SQL STATEMENTS.

Stored procedures can run directly run on a data base engine. In industries where automation is the key a stored procedure can run entirely on the data base provided to it and this runs on a specialized data base server. Network communication can be avoided. Also this procedure is useful for execution of complex SQL statements.

Discussion

No Comment Found

Related InterviewSolutions

Explain About The Return Statement?
Explain About The Implementation Of Stored Procedures?
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?
State About The Security Aspects Of Stored Procedures?
Explain About Recursive Stored Procedures?
Explain About The Implementation Of Business Logic In Stored Procedures?
What Is The Difference Between A User Defined Function And A Stored Procedure?
What Are External Procedures ? Why And When They Are Used?
How One Call Ddl Statement Using Stored Procedures In Oracle?
Does Storing Of Data In Stored Procedures Increase The Access Time? Explain?