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.” For today's exercises we will create an entirely new database and tables, and insert some rows into the tables by following the information provided. We will then realize that our table structure is in error, so we will take corrective action. The tables will be based upon other tables and drop tables. We will also do some SELECT statements.

Quiz

1:	True or false: The ALTER DATABASE statement is often used to modify an existing table's structure.
2:	True or false: ...