COMPUTER APPLICATIONS
DATABASE MANAGEMENT SYSTEMS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Data integrity
|
|
|
Data anomaly
|
|
|
Data redundancy
|
|
|
Data inconsistency
|
Detailed explanation-1: -Data redundancy occurs when the same piece of data exists in multiple places, whereas data inconsistency is when the same data exists in different formats in multiple tables.
Detailed explanation-2: -Data inconsistency is a situation where there are multiple tables within a database that deal with the same data but may receive it from different inputs. Inconsistency is generally compounded by data redundancy.
Detailed explanation-3: -Data inconsistency problems can occur as a result of referential integrity constraint violations. Referential integrity describes the condition where all references to data in pages are valid. Db2 provides referential integrity by enforcing referential constraints on the data.
Detailed explanation-4: -Data inconsistency exists when different versions of the same data appear in different places. A query is a specific request issued to the DBMS for data manipulation, e.g. to read or update the data. Simply put, a query is a question.