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
Explain normalization in one line?
What is Data Modelling?
What is ole db in ssis?
how to configure oracle 10g in java1.5 and tell me know how to set class path in system?
How many types of locks are present in a database?
What is the relationship that exists inside in E-R diagram?
define primary key index, bitmap index, hash index,virtual indwx
Can you create a database in word?
How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?
Define stored procedure?
What are the advantages of normalizing a database.
Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:
How do you connect to a database?
How do you pass parameter in stored procedure?
There are three servers are run by Oracle, MS Access and .Net. What are the procedure fetching the values of two variables from two servers among these?