Day 8
Quiz
| 1: | True or false: Normalization is the process of grouping data into logically related groups. |
| A1: | True. |
| 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. |
| A2: | False. Sometimes it is better to denormalize your database a bit to improve performance by decreasing the number of join operations required to retrieve data. |
| 3: | True or false: If data is in the third normal form, it is automatically in the first and second normal forms. |
| A3: | True. |
| 4: | What is a major advantage of a denormalized database? |
| A4: | A denormalized database will typically perform better than a normalized database because fewer join operations are required to retrieve data from tables. ... |
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.
