COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Data that is repeated multiple times.
|
|
|
Data that is safe from SQL attacks.
|
|
|
Data that is weak to SQL attacks.
|
|
|
Data that has no use anymore.
|
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. Unfortunately, data redundancy can cause data inconsistency, which can provide a company with unreliable and/or meaningless information.
Detailed explanation-2: -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.
Detailed explanation-3: -In digital image compression, three basic data redundancies can be identified and exploited: coding redundancy, interpixel redundancy, and psychovisual redundancy.
Detailed explanation-4: -The Duplication of Data in computer language is known as Data Redundancy. Data duplication is a widespread phenomenon and should be prevented at all costs as it takes up space in your computer and affects its performance. Data redundancy occurs when the same data or files are stored in two or more locations.
Detailed explanation-5: -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.