RDBMS Interview Question:

What are stored-procedures? And what are the advantages of using them?

Submitted by: Administrator

Stored procedures are database objects that perform a user defined operation. A stored procedure can have a set of compound SQL statements. A stored procedure executes the SQL commands and returns the result to the client. Stored procedures are used to reduce network traffic.
Submitted by: Administrator