Question

Define view. What are the types of view? Write syntax to create view of each 03 type. Give an example of view in dbms

Answer 1

a database view is a searchable object in a database that is defined by a query. Though a view doesn't store data, some refer to a views as “virtual tables,” you can query a view like you can a table. A view can combine data from two or more table, using joins, and also just contain a subset of information.