Discuss the features of a database VIEW. Specifically, address the following: What is a VIEW and what are its uses? Does a view occupy space in the database? In other words, does a view contain any data? When we execute a SELECT statement on a view, where does the data come from? When we execute an INSERT, UPDATE or DELETE on a view, what data gets affected? If we drop a view, what happens to its base tables?

Discuss the features of a database VIEW. Specifically, address the following: What is a VIEW and what are its uses? Does a view occupy space in the database? In other words, does a view contain any data?

"Order a similar paper and get 100% plagiarism free, professional written paper now!"

Order Now