Answer 1

Views are virtual tables which aren't saved in the memory. They are created for the user to check a table's data. When we use a select statement with some conditions, a view is created. That view contains data that is derived from the table.