Mention the uses of stored procedures.

Stored procedures are used for various different things. Some of the uses of stored procedures are as follows:

• Stored procedures are often used as access control mechanism and for data validation.
• The logic applied in this application is centralized and is stored in the application.
• Procedures are used to process the huge amount of data for complex procedures and functionalities and for logic implementation access of their data.
• These procedures are used to store data in them and can be accessed by procedures.
• They support modular programming.
• Faster execution takes place.
• It can also be used as a security mechanism.
• They are used for reducing network traffic.