What are the three types of anomalies in database and
Explain?
Answer Posted / safiullah
there are three type of anomaly
1)insertion anomaly
2)deletion anomaly
3)modification anomaly
INSERTION ANOMALY occur when certain attribute cannot be inserted into the database without the presence of other attribute.
DELETION ANOMALY exist when certain attributes are lost because of the deletion of other attribute.
ANOMALY's MODIFICATION occur when we are not able to modifying the record in database without takecare of other facts.
Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What are indexes in oracle?
What is ole db in ssis?
how to send multiple records which matches all the condition in the lookup transformation ? (if lookup matches the codition for duplicate values)
What are the disadvantages of views in a database?
Which three commands cause a transaction to end?
How concurrency problems effect the database?
Explain file manager?
What is the best database software for small businesses?
Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
What is the relationship that exists inside in E-R diagram?
Which database is best to store images?
WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?
What is a trace file?
sparse lookup and where its options we find in OCI and db2?
What do you mean by cluster and non cluster index?