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
What is the Lock Based Protocol used for?
How does non-cluster index functions?
Explain phantom deadlock?
What is ole db provider for sql server?
What is a database string?
can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance
query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp
List the properties of a transaction.
How much does it cost to build a database?
Why merge statement is used inside the database?
What are different types of blocks used in stored procedure?
How to do Data integrity testing? Who does this testing (Developer or tester)?
Is storing images in a database a good idea?
What are the types of indexes that are present inside a database?
what is the full procedure for using store procedure in informatica7.1?