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
How to do Data integrity testing? Who does this testing (Developer or tester)?
What is the best database software for small businesses?
What is the advantage of varchar2 over char?
What is the role of driver manager?
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
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
What is difference between server and database?
How is image stored in database?
Explain inner and outer joins with examples.
WHAT IS NEED BY METION DATFMT AND TIMFMT IN H-SEPICITION IN RPGLE?
What is a super key?
what is transaction state, buffer management, shadow paging
Why do we need distributed database?
What are the advantages of normalizing a database.
What is a database lookup?