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 are the types of indexes that are present inside a database?
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
Is database a hardware or software?
What is the relationship that exists inside in E-R diagram?
Explain natural key?
What is ase database?
How do you pass parameter in stored procedure?
i applied prompt on country when i run report it shows list of all countries but want it to show only four countries name
List various types of log-based recovery in DBMS.
define primary key index, bitmap index, hash index,virtual indwx
What is database collection?
Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:
What is sharded database?
What are the concurrency problems a database faces?
Explain the various types of normalization.