Interested to Buy Any Domain ? << Click Here >> for more details...
What are the three types of anomalies in database and
Explain?
- 9 Answers
- 94416 Views
- I also Faced
- E-Mail Answers
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
Give the syntax of exception handling used in DBMS?
What is ole db in ssis?
What do you mean by foreign key and primary key?
What is difference between clustered, non-clustered and unique index?
Explain file manager?
Which is the best graph database?
What are the most common databases?
1. How to test Database? Please, give me all details for "SQL,Msaccess, Mysql Database? 2.For which functionalities database used? 3.How to convert Guest to Admin by Mysql database?
What is odm in database?
What are indexes in oracle?
what is the role of auditor in auditing data oriented applications?
What is the role of tester in discovery(in Checklist)?
sparse lookup and where its options we find in OCI and db2?
What is a database lookup?
What are different types of blocks used in stored procedure?
