CLOUD COMPUTING
DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Update Anomalies
|
|
|
Creation Anomalies
|
|
|
Insertion Anomalies
|
|
|
Deletion Anomalies
|
Detailed explanation-1: -There are three types of anomalies: update, deletion, and insertion anomalies.
Detailed explanation-2: -Data anomalies are inconsistencies in the data stored in a database as a result of an operation such as update, insertion, and/or deletion. Such inconsistencies may arise when have a particular record stored in multiple locations and not all of the copies are updated.
Detailed explanation-3: -Update Anomaly. Insert Anomaly. Delete Anomaly.
Detailed explanation-4: -1-Update Anomaly: Let say we have 10 columns in a table out of which 2 are called employee Name and employee address. 2-Insertion Anomaly: Let’s say we have a table that has 4 columns. 3-Deletion Anomaly: This anomaly indicates unnecessary deletion of important information from the table. More items •28-Nov-2019