What are the three types of anomalies in database and
Explain?

Answer Posted / mue timothy

Update anomalies-data inconsistency that results from data redundancy and partial update.
Deletion anomalies-unintended loss of data due to the deletion of other data.
Insertion anomalies-the inability to add data to the database due to the absence of other data.

Is This Answer Correct ?    12 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to do Data integrity testing? Who does this testing (Developer or tester)?

1606


What is the best database software for small businesses?

501


What is the advantage of varchar2 over char?

788


What is the role of driver manager?

583


please tell me the informatica telecom projects interview question? like if they ask about project explanation and the difficulties and the solutions taken to solve the issues for telecom projects,e.g i am workin for a vodafone project handlin postpaid section,pls tell me wat wud be the process if i work in this ? thanks

8018






Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool

1422


What is difference between server and database?

563


How is image stored in database?

576


Explain inner and outer joins with examples.

710


WHAT IS NEED BY METION DATFMT AND TIMFMT IN H-SEPICITION IN RPGLE?

2477


What is a super key?

622


what is transaction state, buffer management, shadow paging

2924


Why do we need distributed database?

539


What are the advantages of normalizing a database.

594


What is a database lookup?

564