Ab Initio Data Warehousing Question:
Download Questions PDF

What is the purpose of having stored procedures in a database?

Answer:

Main Purpose of Stored Procedure for reduse the network trafic and all sql statement executing in cursor so speed too high.

Download Ab Initio Interview Questions And Answers PDF

Previous QuestionNext Question
Why might you create a stored procedure with the with recompile option?What are Cartesian joins?