What is a view and what are its


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?

Request for Solution File

Ask an Expert for Answer!!
Data Structure & Algorithms: What is a view and what are its
Reference No:- TGS01034171

Expected delivery within 24 Hours