SQL

Discuss the features of a database VIEW.  Specifically, address the following:

1.       What is a VIEW and what are its uses?

2.       Does a view occupy space in the database? In other words, does a view contain any data?

3.       When we execute a SELECT statement on a view, where does the data come from?

4.       When we execute an INSERT, UPDATE or DELETE on a view, what data gets affected?

5.       If we drop a view, what happens to its base tables?