Views
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. In a database, what is a view?
2. Does a database view store its own data?
3. When does creating a view become advantageous?
4. How do you retrieve the combined results once a view has been created?
5. In the EmployeeProfile example, which tables are combined by the view?
6. Which SQL statement creates a view?
7. In the EmployeeProfile example, on which condition are the Employee and Department tables joined?
8. Why is understanding views described as crucial?
9. What is the main benefit of a view for a frequently needed multi-table result?
10. Which statement about a regular database view is NOT correct?