The intentional process of introducing redundant data into a normalized database structure to optimize read query performance is called what? MCQ with Answer and Explanation
The intentional process of introducing redundant data into a normalized database structure to optimize read query performance is called what?
A. Normalization
B. Fragmentation
C. Decomposition
D. Denormalization
Answer: Option D
Solution (By JKSSB Mock Tests)
Denormalization is a strategy applied to normalized databases where redundant data is selectively added to speed up complex read queries by minimizing costly table joins.
Explanation:
SUM(), AVG(), and COUNT() are aggregate functions operating on multiple rows, whereas LENGTH() is a scalar function acting on a single text value.
No comments yet. Be the first to start the discussion!