What are the three types of anomalies in database and
Explain?
Answer Posted / irshad ahmad
Anomalies are problems that arise in the data due to a flaw
in the database design. There are three types of anomalies….
*Insertion Anomalies:Insertion anomalies occur when we
try to insert data into a flawed table.
*Deletion Anomalies:- Deletion anomalies occur when we
delete data from a flawed schema.
*Update Anomalies:- Update anomalies occur when we
change data in a flawed schema.
| Is This Answer Correct ? | 146 Yes | 21 No |
Post New Answer View All Answers
WHAT IS CARDINALITIES OF JOIN?
where can i free download sqlserver2008..i can install sqlserver2008 without visual studio 2008 and work on it
What is database collection?
Explain normalization in one line?
Can you tell any two advantages of stored procedures?
What is redis good for?
Explain database partitioning.
What are the various ways to execute a query in teradata?
What is a database call?
How to shrink a database?
Write a query to get maximum and second maximum in oracle?
what is the role of auditor in auditing data oriented applications?
What is ole db provider for sql server?
how to send multiple records which matches all the condition in the lookup transformation ? (if lookup matches the codition for duplicate values)
Explain inner and outer joins with examples.