Sams Teach Yourself SQL in 24 Hours, Third Edition By Ronald R. Plew, Ryan K. Stephens
Table of Contents
Hour 20. Creating and Using Views and Synonyms
The following workshop is composed of a series of quiz questions and practical exercises. The quiz questions are designed to test your overall understanding of the current material. The practical exercises are intended to afford you the opportunity to apply the concepts discussed during the current hour, as well as build upon the knowledge acquired in previous hours of study. Please take time to complete the quiz questions and exercises before continuing. Refer to Appendix C,"Answers to Quizzes and Exercises," for answers.
Quiz
1:
Can a row of data be deleted from a view that was created from multiple tables?
2:
When creating a table, the owner is automatically granted the appropriate privileges on that table. Is this true when creating a view?
3:
What clause is used to order data when creating a view?
4:
What option can be used, when creating a view from a view, to check integrity constraints?
5:
You try to drop a view and receive an error because there are one or more underlying views. What must you do to drop the view?
Exercises
1:
Write a statement to create a view based on the total contents of the EMPLOYEE_TBL table.
2:
Write a statement that creates a summarized view containing the average pay rate and average salary for each city in the EMPLOYEE_TBL table.
3:
Write statements that drop the two views that you created in Exercises 1 and 2.
