MCQ IN COMPUTER SCIENCE & ENGINEERING

Detailed explanation-1: -Data redundancy can occur within an organization intentionally or accidentally. If done intentionally, the same data is kept in different locations with the organization making a conscious effort to protect it and ensure its consistency. This data is often used for backups or disaster recovery.

Detailed explanation-2: -Duplication of data is called data redundancy. Duplication of data should be checked always as data redundancy takes up the free space available in the computer memory. Data redundancy occurs when the same piece of data is stored in two or more separate places and is a common occurrence.

Detailed explanation-3: -A common example of data redundancy is when a name and address are both present in different columns within a table. If the link between these data points is defined in every single new database entry it would lead to unnecessary duplication across the entire table.

Detailed explanation-4: -Redundancy helps avoid single-point failure. For instance, if we have two instances running and one of them fails then, then the system can switch over to another one. Replication : Sharing information to ensure consistency between redundant resources. Save this answer.

Detailed explanation-5: -Wasteful data redundancy occurs when the data doesn’t have to be repeated but it is duplicated due to inefficient coding or process complexity. Positive Data redundancy: This type of data redundancy works to safeguard data and promote consistency.