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? SQL> GRANT CONNECTION TO DAVID;
2:	True or false (and why): Dropping a user will cause all objects owned by that user to be dropped as well.
3:	What would happen if you created a table and granted SELECT privileges on the table to PUBLIC?
4:	Is the following SQL statement correct? SQL> create user RON identified by RON;
5:	Is the following SQL statement correct? SQL> alter RON identified by RON;
6:	Is the following ...