Question 102Asked in DSSSB PGT Computer Science (Technical), 11 Jul 2021

What is Denormalization in Relational Database Management System?

  1. ADenormalization is the process of increasing redundancy to improve performance
  2. BDenormalization is used to decrease redundancy in database
  3. CDenormalization is used to decrease the dependence on normal forms
  4. DDenormalization is used to develop a new schema in database
Show answerHide answer

Correct answer: (A) Denormalization is the process of increasing redundancy to improve performance

Explanation

Denormalization deliberately adds redundancy (merging tables or duplicating data) to cut joins and improve read performance.

From DSSSB PGT Computer Science PYQ (Technical), 11 Jul 2021

This is question 102 of DSSSB PGT Computer Science PYQ (Technical), 11 Jul 2021. See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.