What are views, functions, stored procedures

Question

Accepted Answer

Views, functions, and stored procedures are database objects used to manipulate and retrieve data.

Views are virtual tables that display data from one or more tables in a specific way.
Functions are reusable code blocks that perform a specific task and return a value.
Stored procedures are precompiled SQL statements that can be executed with parameters.
All three objects can improve performance and simplify complex queries.
Examples include creating a view to display only certain columns from a table, creating a function to calculate the average of a set of numbers, and creating a stored procedure to update multiple tables at once.

Top Quosphere InfoSolutions BI Consultant interview questions & answers