:: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Categories >> Software >> Databases >> Databases AllOther


 Oracle interview questions  Oracle Interview Questions (2041)
 SQL Server interview questions  SQL Server Interview Questions (1082)
 MS Access interview questions  MS Access Interview Questions (25)
 MySQL interview questions  MySQL Interview Questions (194)
 Postgre interview questions  Postgre Interview Questions (6)
 Sybase interview questions  Sybase Interview Questions (22)
 DB Architecture interview questions  DB Architecture Interview Questions (5)
 DB Administration interview questions  DB Administration Interview Questions (213)
 DB Development interview questions  DB Development Interview Questions (54)
 SQL PLSQL interview questions  SQL PLSQL Interview Questions (777)
 Databases AllOther interview questions  Databases AllOther Interview Questions (107)
What are the three types of anomalies in database and  
 Question Submitted By :: Databases-AllOther
I also faced this Question!!     Answer Posted By  
# 1
there are basically three types of anomalies in database:
1. insertion anommalies
2. updation anomalies
3. deletion anomalies
Is This Answer Correct ?    117 Yes 14 No
# 2
Anomalies are problems that arise in the data due to a flaw
in the database design. There are three types of anomalies….
*Insertion Anomalies:Insertion anomalies occur when we
try to insert data into a flawed table.
*Deletion Anomalies:- Deletion anomalies occur when we
delete data from a flawed schema.
*Update Anomalies:- Update anomalies occur when we
change data in a flawed schema.
Is This Answer Correct ?    91 Yes 12 No
Irshad Ahmad
# 3
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 ?    16 Yes 1 No
# 4
Three Anomalies are:-
Insertion Anomalies.
Deletion Anomalies.
Modification Anomalies.
Is This Answer Correct ?    26 Yes 14 No
Shashank Shekhar
# 5
insertion anomalies
update anomalies
deletion anomalies
Is This Answer Correct ?    8 Yes 2 No
Melkamu Wondie
# 6
Update anomalies-data inconsistency that results from data redundancy and partial update.
Deletion anomalies-unintended loss of data due to the deletion of other data.
Insertion anomalies-the inability to add data to the database due to the absence of other data.
Is This Answer Correct ?    0 Yes 0 No
Mue Timothy
# 7
there are 3 types of irregularity in a database i.e.

insertion irregularity
updation irregularity
deletion irregularity
Is This Answer Correct ?    16 Yes 23 No
Sanket Mishra

Other Databases AllOther Interview Questions
  Question Asked @ Answers
Which is the best sorting method if i have to sort the students of Harvard University according to their first name? CybAge 1
What is the default identifier of structure in C? CybAge 3
How do you select an index for a table   1
CLI stands for? IBM 3
In TeraData We have 5 SQL queries, without using BTEQ how can we execute those queries? CTS 1
what is primary key,unique key, foreign key? can u teach me in simple language? CMC 44
Can we have a function Overloading with same number of arguments but with different return types of function CybAge 8
what is difference between delete and truncet ? Fidelity 7
If we execute an query in MLOAD it's ran successfully, my questions is after successfully ran MLOAD. In error tables we can see anything there! is it possible than what are they? CTS 3
How can we join three tables in SQL server 2000 Intelligroup 1
can anyone please tell what are the roles and responsibilities of a teradata developer in detail???   1
For more Databases AllOther Interview Questions Click Here 

Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
Copyright © 2013  All Rights Reserved.   ::