MCQ IN COMPUTER SCIENCE & ENGINEERING

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: -What is Data Inconsistency? 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-Data inconsistency exists when different and conflicting versions of the same data appear in different places.

Detailed explanation-4: -For instance, assume a hospital database. Changing the address of one patient can affect many other tables. Only one record will have correct data while the others will have false data. Hence, this is data inconsistency.

Detailed explanation-5: -Data consistency means that each user sees a consistent view of the data, including visible changes made by the user’s own transactions and transactions of other users.