MCQ IN COMPUTER SCIENCE & ENGINEERING

Detailed explanation-1: -Redundant records lead to unnecessary growth in database size, which in turn decreases the efficiency of the database and causes data corruption. Hence, the best option is to avoid preparing redundant records, unless it’s essential for backups.

Detailed explanation-2: -Normalize Database It is a process in which data is efficiently organized in a database so that duplication can be avoided. It ensures that the data across all the records provide a similar look and can be read in a particular manner.

Detailed explanation-3: -Limitations of data redundancy Creates opportunities for data corruption: Data corruption occurs when something damages or causes errors in the information during the storage, transfer, or creation process. This means that storing several copies of the same data can create more opportunities for its corruption.

Detailed explanation-4: -Fortunately, data replication can help prevent data redundancy by storing the same data in multiple locations. With data replication, companies can ensure consistency and receive the information they need at any time.

Detailed explanation-5: -Redundancy occurs when a writer unnecessarily repeats something. Writers should avoid. redundancy not only because it distracts and annoys readers but also because it adds unnecessary. length to one’s writing.