Database-Management-System
October 4, 2023Nielit Scentist-B [02-12-2018]
October 4, 2023Database-Management-System
| Question 682 |
In RDBMS, different classes of relations are created using __________ technique to prevent modification anomalies.
| Functional Dependencies | |
| Data integrity | |
| Referential integrity | |
| Normal forms |
Question 682 Explanation:
Normal forms in order to reduce data redundancy and improve data integrity. Normal forms to prevent modification anomalies.
Example anomalies:
1. Insertion anomaly
2. Deletion and Updation anomaly
Example anomalies:
1. Insertion anomaly
2. Deletion and Updation anomaly
Correct Answer: D
Question 682 Explanation:
Normal forms in order to reduce data redundancy and improve data integrity. Normal forms to prevent modification anomalies.
Example anomalies:
1. Insertion anomaly
2. Deletion and Updation anomaly
Example anomalies:
1. Insertion anomaly
2. Deletion and Updation anomaly