Write short note of VIEW in DBMS?

Answer 1

a view is derived from table,it is a virtual table.views are introduced for easyness.they take care about the information stored i.e data abstraction and security in dbms.views are part of data base.

Answer 2

In a database management system (DBMS), a view is a virtual table that is based on the result set of a SELECT query. Views allow users to access and manipulate data without directly querying the underlying tables. They provide a security mechanism by restricting access to specific columns or rows, as well as simplifying complex queries by predefining them as views.