

The Relational Model and Normalization - Technical MCQs
Q1: For some relations, changing the data can have undesirable consequences called:A referential integrity constraints.
B modification anomalies.
C normal forms.
D transitive dependencies.
ANS:B - modification anomalies. Modification anomaly comes when we, say, modify an attribute value and this modification has an undesired effect on the database. Suppose we changed an Attribute Value Dep_name in department table from marketing to research and, in case, this modification leads you to change the attribute value DName to 'Marketing' in Manager table as well (Because Dep_name in Department Table was a PK and DName in Manager table was an FK). |


For help Students Orientation
Mcqs Questions
One stop destination for examination, preparation, recruitment, and more. Specially designed online test to solve all your preparation worries. Go wherever you want to and practice whenever you want, using the online test platform.