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
can u combine pipeline parallelism and partition parallalism? how and whan?
How many indexes can be created on a table?
On startup, the transaction log of a database has filled and recovery has suspended, what can I do?
Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
What is a database string?
What the various ways to tune a teradata query
what is the role of auditor in auditing data oriented applications?
Write a query to get maximum and second maximum in oracle?
What is the Lock Based Protocol used for?
What is the difference between data source and database?
how can you perform lookup range in lookup stage expalin in detail?
What do you mean by cluster and non cluster index?
What is database schema name?
What is a Database?
Can you tell any two advantages of stored procedures?