QuizzesDenormalisation — Concept Check
intermediate
mysql

Denormalisation — Concept Check

Questions on Denormalisation. Strategically add redundant data (precomputed totals, copied columns) to reduce JOIN overhead on read-heavy workloads; balance query speed against write complexity and consistency.

7 minutes 7 questions Pass at 70%
Time Limit
7 minutes - timer starts when you begin
Change Answers Freely
Revisit and change any answer before submitting
Full Review After Submit
Correct answers and explanations shown for every question
Auto-submit on timeout
Quiz submits automatically when time runs out

Questions in this quiz

7 questions on Denormalisation — Concept Check. Work through them here, then start the quiz to answer them and see your score.

  1. 1.A database application frequently performs SUM operations on large tables, causing performance issues. Which denormalization technique can help improve read performance?

    • ANormalize the tables to eliminate redundancy.
    • BIncrease the hardware resources to handle the load.
    • CUse precomputed aggregates with triggers to keep them updated.
    • DUse indexes on all columns involved in the SUM operations.
  2. 2.A reporting system requires fast access to historical sales data, but real-time accuracy is not critical. Which approach should be used?

    • APerform real-time aggregation on the raw data.
    • BUse summary tables updated periodically for fast queries.
    • CUse generated columns for real-time updates.
    • DNormalize the sales data to reduce redundancy.
  3. 3.A developer copies customer names to the orders table to avoid frequent JOINs. What is a potential downside of this approach?

    • AIt violates the principle of data normalization, leading to data integrity issues.
    • BThe copied data may become stale if the customer's name changes.
    • CIt requires additional storage space, slowing down queries.
    • DIt increases the complexity of JOIN operations.
  4. 4.A database uses materialized views to improve query speed. How does this affect data consistency?

    • AMaterialized views are always consistent with the source data.
    • BMaterialized views automatically update with the source data.
    • CMaterialized views eliminate the need for data consistency checks.
    • DMaterialized views require synchronization to maintain consistency.
  5. 5.A team decides to store precomputed totals in their orders table. What must they ensure for data consistency?

    • ATriggers or application logic must update totals on data changes.
    • BIndexes on totals ensure consistency across the database.
    • CData normalization will handle consistency without additional logic.
    • DPrecomputed totals automatically update with line-item changes.
  6. 6.An e-commerce platform stores customer emails in the orders table. What is a benefit of this approach?

    • AIt avoids JOIN operations for retrieving historical order data.
    • BIt reduces the overall storage requirements for the database.
    • CIt ensures the email is always up-to-date with the customer record.
    • DIt simplifies the normalization process of the database.
  7. 7.What is the primary trade-off of denormalization in database design?

    • AElimination of data redundancy at the cost of slower read queries.
    • BSimplified database schema but increased storage requirements.
    • CIncreased data integrity but reduced query performance.
    • DFaster read queries but increased complexity in maintaining data consistency.