Redirected
edited by
1,492 views
0 votes
0 votes

In RDBMS, different classes of relations are created using ________ technique to prevent modification anomolies.

  1. Functional Dependencies
  2. Data integrity
  3. Referential integrity
  4. Normal Forms
edited by

2 Answers

1 votes
1 votes

Ans.) 4

Normal forms

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.

Answer:

Related questions

1 votes
1 votes
2 answers
1
Arjun asked Nov 5, 2017
3,067 views
Which speed up could be achieved according to Amdahl's Law for infinte number of processes if $5\%$ of a program is sequential and the remaining part is ideally parallel?...
0 votes
0 votes
1 answer
2
Arjun asked Nov 5, 2017
2,519 views
Which of the given wireless technologies used in IoT, consumes the least amount of power?ZigbeeBluetoothWi-FiGSM/CDMA
0 votes
0 votes
2 answers
3
Arjun asked Nov 5, 2017
4,592 views
Which of the following is not a Clustering method?K-Means methodSelf Organizing feature map methodK- nearest neighbor methodAgglomerative method