What are the three types of anomalies in database and
Explain?
- 9 Answers
- 92575 Views
- I also Faced
- E-Mail Answers
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 does non-cluster index functions?
Explain file manager?
What does currency type mean in database?
aht is the difference b/w network & hierarchial & relational dbms????
if i want to display the name of students such that to which city they belong must have count greaer than two
What is ole db used for?
What are different types of blocks used in stored procedure?
What is replicaset?
What are different types of clusters present?
How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?
Write a query to get maximum and second maximum in oracle?
Explain database partitioning. What is its importance?
What is a driver in database?
can we delete autodiff back up that we have set through sql server agent.
what is the role of auditor in auditing data oriented applications?
