SQL Interview Questions
SQL Function Vs Procedure View Vs Materialised View View: View is just a named query. It doesn't store anything. When there is a query on view, it runs the query of the view definition. Actual data comes from table. Materialised views: Stores data physically and get updated periodically. While querying MV, it gives data from MV.