Sams Teach Yourself SQL in 21 Days, Fourth Edition

Workshop

The Workshop provides quiz questions to help solidify your understanding of the material covered, as well as exercises to provide you with experience in using what you have learned. Try to answer the quiz and exercise questions before checking the answers in Appendix A, “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 all privileges on the table. Is this true when a view is created?
3:	What clause can be used to sort data in a CREATE VIEW statement?
4:	Is the following CREATE statement correct? SQL> create view credit_debts as (select all from debts where account_id = 4);
5:	Is the following CREATE statement correct? SQL> create unique ...