What are the three types of anomalies in database and
Explain?
- 9 Answers
- 92553 Views
- I also Faced
- E-Mail Answers
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
List various types of log-based recovery in DBMS.
Is redis in memory database?
What is redis good for?
what is tkprof tool and how it is used???
Explain entity ?
First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9
What is sharded database?
Explain transaction manager?
What is aws documentdb?
What are different types of blocks used in stored procedure?
What is the concept of Virtual field?
diff b/w inter process and in process
What is the difference between primary and candidate key?
What is ole db in ssis?
What will happen non-clustered index will be created on clustered index?
