What are the three types of anomalies in database and
Explain?
Answer Posted / rajabmatalingana@yahoo.com
Anomalies are problems which arises when changes are made to
the database.
There are three types of anomalies:
>INSERTIN-This problem occurs due to inability to represent
a certain information example;when information about new
cannot be inserted in a DB,
>DELETION-This occurs due to loss of useful information
Example;when we delete information in a DB we will loss
relevant information.
>UPDATE-This type occurs due to redundant information make
difficult to update
| Is This Answer Correct ? | 43 Yes | 8 No |
Post New Answer View All Answers
how can we view column head in first page but not in remaining pages?
Differentiate between extension & intension?
Under which circumstance should you create an index on a table?
Explain file manager?
Differentiate between delete and truncate table?
How default key is different from primary key?
What is odm in database?
Which database does facebook use?
HOW PASS PARAMETERS FOLLOWING ORDER RPG-CL-RPG?
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
Display the employees whose salary is less than average salary.
What is table scan and index scan?
What is the role of driver manager?
How many types of locks are present in a database?
What is a sequence? Explain it with one example?