Data Dictionary Quiz

What is a data dictionary?

• A. A table that stores all the data in a database.

• B. A table that decides what data is going to be stored in each table of a database.

• C. A table that only stores user information.

• D. A table that only stores system logs.

Why are data dictionaries used?

• A. To store large amounts of data.

• B. To ensure data integrity and consistency.

• C. To delete unnecessary data.

• D. To create user interfaces.

What do data dictionaries help to define?

• A. Data types, constraints, and relationships.

• B. User roles and permissions.

• C. Network configurations.

• D. Software versions.

What is one of the benefits of using data dictionaries?

• A. They increase the speed of data processing.

• B. They reduce the risk of data entry errors and inconsistencies.

• C. They allow for unlimited data storage.

• D. They provide real-time data analytics.

What is the primary key for the customer's table in the provided data dictionary example?

• A. Customer Name

• B. Customer ID

• C. HolsBegin

• D. Date

What is a common reason for mistakes when data is copied manually?

• The person doing the copying may misread the original data

• The data is always accurate

• The data is automatically corrected

• The data is always entered by a computer

What is an input error?

• When data is automatically corrected

• When long codes with no human meaning are prone to errors

• When data is always accurate

• When data is entered by a computer

What is a transposition error?

• When data is omitted or excluded

• When two characters are accidentally swapped

• When data is automatically corrected

• When data is entered by a computer

What is an omission error?

• When data is omitted or excluded

• When data is automatically corrected

• When data is always accurate

• When data is entered by a computer

What does a presence check ensure?

• That data has been entered into a data field

• That data is always accurate

• That data is automatically corrected

• That data is entered by a computer