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 a database call?
What are the various ways to execute a query in teradata?
What are different types of data models available? Explain with example?
How to do Stored procedure testing? Who does this testing (Developer or tester)?
What happens when shared and exclusive locks are applied on data item?
Difference between sql and mysql?
What is relational database with example?
What is the function of cluster index?
diff b/w inter process and in process
how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.
Explain the various types of normalization.
Define stored procedure?
Is hive a database?
What is the best database?
What are the advantages of normalizing a database.