Benefit/s  of stored procedures is/are?Question 21Select one or more:a.No clear benefitsb.Create your own functionc.Reduces network trafficd.Code re-use

The benefits of stored procedures are:

a. No clear benefits: This option suggests that there may not be any clear advantages to using stored procedures. However, this is not a commonly chosen option as stored procedures do offer several benefits.

b. Create your own function: This option implies that stored procedures allow you to create your own custom functions. Stored procedures can encapsulate complex logic and calculations, making them reusable and easily accessible.

c. Reduces network traffic: This option highlights one of the key benefits of using stored procedures. By executing the logic on the database server itself, rather than sending multiple queries over the network, stored procedures can significantly reduce network traffic. This can lead to improved performance and efficiency.

d. Code re-use: This option emphasizes another advantage of stored procedures. Once a stored procedure is created, it can be called and reused by multiple applications or queries. This promotes code reusability, simplifies maintenance, and ensures consistency in the logic implemented.

In summary, the benefits of stored procedures include the ability to create custom functions, reduce network traffic, and promote code reusability.

The benefits of stored procedures are:

a. No clear benefits: This option suggests that there may not be any clear advantages to using stored procedures. However, this is not a commonly chosen option as stored procedures do offer several benefits.

b. Create your own function: This option implies that stored procedures allow you to create your own custom functions. This can be useful when you need to perform specific tasks or calculations repeatedly.

c. Reduces network traffic: This option highlights one of the main benefits of stored procedures. By executing complex database operations on the server side, rather than sending multiple queries over the network, stored procedures can significantly reduce network traffic. This can lead to improved performance and efficiency.

d. Code re-use: This option emphasizes another advantage of stored procedures. Once a stored procedure is created, it can be called and executed multiple times from different parts of an application. This promotes code re-use, as developers can avoid duplicating code and instead utilize the same stored procedure for various tasks.

In summary, the benefits of stored procedures include the ability to create custom functions, reduce network traffic, and promote code re-use.