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:Is there a limit to the number of columns in a table that can be defined as unique?
2:What does a check constraint do?
3:When inserting data into the database, which record must be inserted first, the parent or the child?
4:When deleting data from the database, which record must be deleted first, the parent or the child?

Exercises

1:You created the CUST, STOCK, and MEDIA tables today. Perform the DESCRIBE command on each of these tables. Next, determine ...

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.