Difference between stored procedure and function. What are limitations of struct over class Coding question related to inheritance

Question

Accepted Answer

Stored procedures are precompiled SQL queries stored in the database, while functions are reusable code blocks that return a value.

Stored procedures are used for performing specific tasks in the database, while functions are used to return a single value.
Stored procedures can contain multiple SQL statements, while functions contain a single SQL statement.
Stored procedures can have input and output parameters, while functions can only have input parameters.
Stored procedures can modify data in the database, while functions cannot.
Structs in C++ are value types, while classes are reference types.
Structs cannot inherit from other structs, but classes can inherit from other classes.
Structs do not support virtual functions or polymorphism, while classes do.
Inheritance in object-oriented programming allows a class to inherit properties and behavior from another class.

Popular interview questions of Software Engineer