UTpaper

Free mock tests & test series

Question 26Asked in UGC NET Computer Science, August 2016 (Paper II & III, Selected Questions)

Relational database schema normalization is NOT for :

  1. AReducing the number of joins required to satisfy a query
  2. BEliminating uncontrolled redundancy of data stored in the database
  3. CEliminating number of anomalies that could otherwise occur with inserts and deletes
  4. DEnsuring that functional dependencies are enforced
Show answerHide answer

Correct answer: (A) Reducing the number of joins required to satisfy a query

Explanation

Relational database schema normalization is not for reducing the number of joins required to satisfy a query (normalization usually increases joins). Its goals are eliminating redundancy and anomalies and enforcing functional dependencies.

From UGC NET Computer Science PYQ, August 2016 (Paper II & III, Selected Questions)

This is question 26 of UGC NET Computer Science PYQ, August 2016 (Paper II & III, Selected Questions). 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.