Hour 4, "The Normalization Process"
Quiz Answers
| 1: | True or false: Normalization is the process of grouping data into logical related groups. |
| A1: | True. |
| 2: | True or false: Having no duplicate or redundant data in a database, and having everything in the database normalized, is always the best way to go. |
| A2: | False. Not always; normalization can and does slow performance because more tables must be joined which results in more I/O and CPU time. |
| 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 versus a normalized database? |
| A4: | Improved performance. |
| 5: | What are some major disadvantages of denormalization? |
| A5: | Having redundant and ... |
Get Sams Teach Yourself SQL in 24 Hours, Second 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.
