Data

What is data redundancy in the context of a database design?

• Storing data in a single location

• Encrypting data in the database

• Storing data in multiple places

• Deleting data from the database

What is the main disadvantage of data redundancy?

• Better data security

• Improved data reliability

• Increase in data corruption

• Faster data access

What is the purpose of data normalization in reducing data redundancy?

• To create data inconsistency

• To standardize data fields

• To increase data corruption

• To reduce data security

What is the highest level of data abstraction?

• View level

• Conceptual level

• Logical level

• Physical level

What is the purpose of data independence in database systems?

• To achieve user interaction

• To directly interact with data

• To hide data from users

• To ensure users and data do not directly interact

What is the middle level of 3-level data abstraction architecture?

• Conceptual level

• Logical level

• View level

• Physical level

What is the lowest level of data abstraction?

• Conceptual level

• Logical level

• View level

• Physical level

What is the purpose of master data in reducing data redundancy?

• To standardize data fields

• To increase data corruption

• To ensure consistent updates of redundant data

• To create data inconsistency

What is data inconsistency in the context of a database design?

• Different files contain different data of a particular object or person

• Encrypting data in the database

• Storing data in multiple places

• Deleting data from the database

What is the advantage of data redundancy in database systems?

• Better data security

• Improved data reliability

• Increase in data corruption

• Faster data access