ALLInterview.com :: 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                      
Google
   
 
Categories >> Software >> Databases >> Databases AllOther
 
 


 

 
 Oracle interview questions  Oracle Interview Questions (2035)
 SQL Server interview questions  SQL Server Interview Questions (1075)
 MS Access interview questions  MS Access Interview Questions (24)
 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 (53)
 SQL PLSQL interview questions  SQL PLSQL Interview Questions (768)
 Databases AllOther interview questions  Databases AllOther Interview Questions (106)
Question
What are the three types of anomalies in database and  
Explain?
 Question Submitted By :: Krishna
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What are the three types of anomalies in database and Explain?
Answer
# 1
there are basically three types of anomalies in database:
1. insertion anommalies
2. updation anomalies
3. deletion anomalies
 
Is This Answer Correct ?    94 Yes 11 No
Pooja
 
  Re: What are the three types of anomalies in database and Explain?
Answer
# 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 ?    72 Yes 11 No
Irshad Ahmad
 
 
 
  Re: What are the three types of anomalies in database and Explain?
Answer
# 3
there are 3 types of irregularity in a database i.e.

insertion irregularity
updation irregularity
deletion irregularity
 
Is This Answer Correct ?    15 Yes 21 No
Sanket Mishra
 
  Re: What are the three types of anomalies in database and Explain?
Answer
# 4
Three Anomalies are:-
Insertion Anomalies.
Deletion Anomalies.
Modification Anomalies.
 
Is This Answer Correct ?    20 Yes 13 No
Shashank Shekhar
 
  Re: What are the three types of anomalies in database and Explain?
Answer
# 5
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 ?    10 Yes 0 No
Rajabmatalingana@yahoo.com
 
  Re: What are the three types of anomalies in database and Explain?
Answer
# 6
insertion anomalies
update anomalies
deletion anomalies
 
Is This Answer Correct ?    4 Yes 1 No
Melkamu Wondie
 

 
 
 
Other Databases AllOther Interview Questions
 
  Question Asked @ Answers
 
What is the differnce between Order by and Group by   1
What is OQL?   4
can any one explain about normalization forms with clear explanation in interview point of view. thanks for ur answers.   1
What are the differences between Database Trigger and Integrity constraints ? Synergy 2
What are ACID Properties? TCS 1
Which is the best sorting method if i have to sort the students of Harvard University according to their first name? CybAge 1
hai i want to learn oracle apps and i want to put the fake exp of one year so could you please suggest me which is best institute in hyderabad to learn oracle with real time project experience?   2
Write the major components of a Database Management System?   3
Datatypes are unlimited,true or false? Infosys 2
plz suggest me the books for the preparation of NIC written exam. NIC 4
what is vlook up in ms excel and how does it used??? CybAge 1
What is sqlcode -923 ?   1
 
For more Databases AllOther Interview Questions Click Here 
 
 
 
 
 


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

ALLInterview.com   ::  KalAajKal.com