What are the three types of anomalies in database and
Explain?
Answer Posted / mue timothy
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 ? | 12 Yes | 5 No |
Post New Answer View All Answers
hai if any one having any project sample table structure please froward to my mail id tauseefwst@yahoo.com
Write a query to retrieve for many to many relationships?
What happens when shared and exclusive locks are applied on data item?
How to do Data size testing? Who does this testing (Developer or tester)?
How default key is different from primary key?
Which three commands cause a transaction to end?
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
please tell me the informatica telecom projects interview question? like if they ask about project explanation and the difficulties and the solutions taken to solve the issues for telecom projects,e.g i am workin for a vodafone project handlin postpaid section,pls tell me wat wud be the process if i work in this ? thanks
What are the advantages of views in a database?
Explain entity ?
issues involved in modeling and building data werahouses
During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?
define primary key index, bitmap index, hash index,virtual indwx
Explain partial key?
What do you mean by cluster and non cluster index?