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:True or false: Normalization is the process of grouping data into logically related groups.
2:True or false: Having no duplicate or redundant data in a database and having a completely normalized database is always the best way to go.
3:True or false: If data is in the third normal form, it is automatically in the first and second normal forms.
4:What is a major advantage of a denormalized database?
5:What is the main disadvantage of denormalization?
6:

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.