Loading

Quipoin Menu

Learn • Practice • Grow

sql / SQL Denormalization
mcq
Direction: Choose the correct option

Q1.

What is denormalization?
A. Adding indexes
B. Removing redundancy
C. Normalizing data
D. Adding redundancy for performance
Direction: Choose the correct option

Q2.

CREATE TABLE order_summary AS SELECT o.order_id, o.order_date, c.name, c.email FROM orders o JOIN customers c ON o.customer_id = c.id;
What is this an example of?
A. Indexing
B. Denormalization
C. Normalization
D. Partitioning
Direction: Choose the correct option

Q3.

ALTER TABLE customers ADD total_spent DECIMAL;
Why add this column?
A. Store pre-calculated aggregate
B. Add constraint
C. Create index
D. Normalize data
Direction: Choose the correct option

Q4.

What are risks of denormalization?
A. Less storage
B. Data redundancy, update anomalies
C. Faster queries
D. Better integrity
Direction: Choose the correct option

Q5.

When is denormalization appropriate?
A. Data warehouses, reporting systems
B. Transaction processing
C. OLTP systems
D. Frequent updates