What do you understand by the term SQL view

Question

What do you understand by the term SQL view in DBMS? Briefly describe the utilization of views?

Answer 1

A SQL view is a virtual table built from other views or tables. Views are employed to:

(i) Hide rows or columns.
(ii) Represent the results of computed columns,
(iii) Hide difficult SQL syntax.
(iv) Layer built-in functions.
(v) Offer a level of indirection among application programs and tables.
(vi) Assign various setups of processing permissions to tables.
(vii) Assign various setups of triggers to the similar table.