Difference in stored procedure and functions ACiD properties, normalization

Question

Accepted Answer

Stored procedures and functions differ in their usage and capabilities. ACID properties ensure data integrity, normalization reduces redundancy.

Stored procedures are precompiled SQL queries that can perform multiple operations, while functions are reusable code blocks that return a single value.
Stored procedures can have input and output parameters, while functions can only return a single value.
ACID properties (Atomicity, Consistency, Isolation, Durability) ensure data integrity in database transactions.
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
Examples: Stored procedure - sp_GetCustomerDetails, Function - fn_CalculateTotal

Popular interview questions of Senior Executive