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
What are database connection details?
What is the advantage of varchar2 over char?
On startup, the transaction log of a database has filled and recovery has suspended, what can I do?
Can a database table exist without a primary key?
What do you mean by foreign key and primary key?
Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
What the various ways to tune a teradata query
What are the advantages of normalizing a database.
What is the purpose of TNS?
Explain partial key?
Give the syntax of exception handling used in DBMS?
Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.
What is the difference between data source and database?
how to configure oracle 10g in java1.5 and tell me know how to set class path in system?
What is database client?