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 ... |
Get Sams Teach Yourself SQL in 21 Days, Fourth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
