Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


What are the features of Stored Procedures in MYSQL?



What are the features of Stored Procedures in MYSQL?..

Answer / hrindows@gmail.com

 Stored Procedure increases the performance of the applications. Once stored procedures are created, they are compiled and stored in the database.
 Stored procedure reduces the traffic between application and database server. Because the application has to send only the stored procedure's name and parameters instead of sending multiple SQL statements.






 Stored procedures are reusable and transparent to any applications.
 A procedure is always secure. The database administrator can grant permissions to applications that access stored procedures in the database without giving any permission on the database tables.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

Is mysql workbench a dbms?

0 Answers  


What is an index? How can an index be declared in mysql?

0 Answers  


What is mysqli procedural?

0 Answers  


How do you stop an access query?

0 Answers  


What is the phantom problem?

0 Answers  






What are the column comparisons operators?

0 Answers  


How do I stop a query in mysql workbench?

0 Answers  


How do I uninstall mysql connector?

0 Answers  


What is the size of mysql database?

0 Answers  


what are the different tables present in mysql? : Mysql dba

0 Answers  


What is difference between oracle sql and mysql?

0 Answers  


What are the ways in which you can retrieve data in the result set of mysql using php?

0 Answers  






Categories