🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← Quiz: Normalization: all 10 questions

Quiz: Normalization · Question 10 of 10

A reporting team deliberately keeps the customer name inside the orders table to make dashboards faster. This is:

A reporting team deliberately keeps the customer name inside the orders table to make dashboards faster. This is:

  1. A.A 1NF violation that must be fixed
  2. B.An insert anomaly
  3. C.Denormalization — a conscious trade-off for read speed
  4. D.BCNF
Answer & explanation

Correct answer: Denormalization — a conscious trade-off for read speed

Denormalization is done on purpose, accepting some repetition.

Can you get the rest right without peeking?

Take the timed Quiz: Normalization quiz free. Pass it to earn XP and count towards your certificate.

Start the quiz →