What type of anomaly occurs when deleting a row inadvertently destroys other independent, valuable historical facts from the database? MCQ with Answer and Explanation
What type of anomaly occurs when deleting a row inadvertently destroys other independent, valuable historical facts from the database?
A. Projection Anomaly
B. Deletion Anomaly
C. Selection Anomaly
D. Insertion Anomaly
Answer: Option B
Solution (By JKSSB Mock Tests)
A Deletion Anomaly occurs when the deletion of a specific data record unintentionally deletes other distinct, unrelated information that should have been preserved.
Explanation:
The AS keyword is used to assign a temporary alias name to an expression, column, or table within an SQL statement query execution context.
No comments yet. Be the first to start the discussion!