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:	What is wrong with the following statement? DELETE COLLECTION;
2:	What is wrong with the following statement? INSERT INTO COLLECTION SELECT * FROM TABLE_2
3:	What is wrong with the following statement? UPDATE COLLECTION ("HONUS WAGNER CARD", 25000, "FOUND IT");
4:	What would happen if you issued the following statement? SQL> DELETE * FROM COLLECTION;
5:	What would happen if you issued the following statement? SQL> DELETE FROM COLLECTION;
6:	What would ...