Open In App

UGC-NET | UGC-NET CS 2017 Dec 2 | Question 19

Like Article
Like
Save
Share
Report

In RDBMS, different classes of relations are created using __________ technique to prevent modification anomalies.
(A) Functional Dependencies
(B) Data integrity
(C) Referential integrity
(D) Normal Forms


Answer: (D)

Explanation: Functional dependency is a constraint that describes the relationship between attributes in a relation.
Data integrity refers to the accuracy and consistency of data stored in a database, data warehouse, data mart or other construct.
Referential integrity is a relational database concept, which states that table relationships must always be consistent.
Normalization is a process of organizing the data in database to avoid data redundancy, insertion anomaly, update anomaly & deletion anomaly. 1NF, 2NF, 3NF and BCNF are types of normal forms.

So, option (D) is correct.

Quiz of this Question


Last Updated : 15 Mar, 2018
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads