Which type of database storage anomaly occurs when adding new data to a table is blocked because other unrelated data is missing? MCQ with Answer and Explanation
Which type of database storage anomaly occurs when adding new data to a table is blocked because other unrelated data is missing?
A. Deletion Anomaly
B. Insertion Anomaly
C. Modification Anomaly
D. Update Anomaly
Answer: Option B
Solution (By JKSSB Mock Tests)
An Insertion Anomaly occurs when certain facts cannot be recorded in a database table without falsely manufacturing or requiring the presence of other unrelated facts.
Explanation:
Second Normal Form (2NF) eliminates partial dependencies by ensuring all non-key attributes are fully functionally dependent on the entire primary key.
Explanation:
UPDATE is a DML statement because it is used to modify existing data values within rows of a database table, rather than modifying the structural schema.
No comments yet. Be the first to start the discussion!