SQL Interview Questions #35: What is denormalization in RDB?

SQL code copied to buffer

Task 35:

What is denormalization Relational Database? Choose all correct facts about it.

Denormalization is fixing a poorly designed database by putting everything into one big table, the opposite of complicated normalization.

Denormalization puts all data in the same table for faster reads and updates.

Denormalization intentionally adds redundancy to a normalized RDBMS schema to improve read performance by reducing joins. This speeds up retrieval but risks data inconsistencies if updates aren't managed carefully.

Denormalization strategically deviates from normalization in an RDBMS to boost read performance by minimizing joins through controlled redundancy (e.g., pre-calculated fields). The trade-off is more storage and complex write consistency.

Denormalization makes the database less strict, relaxing constraints and relationships for easier data insertion and application flexibility.

Mark all correct answers and click the "Check!" button

Support SQLtest.online

This project has only one funding source: your donations. The monthly maintenance cost is $100.

Last month I added a new MariaDB database with a preloaded University DB, 9 new questions, and refactored many questions and lessons.

With your support, I plan to continue this work: write new lessons and tasks, and improve existing lessons.

To keep the project running next month, we need to collect at least this amount by the end of this month. Anything above it goes to new lessons, exercises, and features.

Received: $29.58 Goal: $100.00

Progress: 30%

T-SQL Fundamentals by Itzik Ben-Gan

Master Transact-SQL's fundamentals, and write correct, robust code for querying and modifying data with modern Microsoft data technologies, including SQL Server 2022, Azure SQL Database, and Azure SQL Managed Instance.

Login

Register