Database Quiz

What is a data dictionary?

• A list of all database users

• A collection of data types and field headings in a database

• A software for database management

• A type of database query

Which data type is used for a mixture of text and numbers, such as a postcode?

• Number

• Date/Time

• Text (or String) or Alphanumeric

• Currency

What is the use of the Autonumber data type?

• To store monetary values

• To create a key field with sequential numbers

• To store dates and times

• To link to a web address

Which data type is used for storing monetary values?

• Text

• Currency

• Date/Time

• Attachment

What does the Yes/No Boolean data type represent?

• Numeric values

• Text values

• Two possible values such as True/False

• Date values

What is the purpose of data validation in a computer system?

• To automatically check data for errors

• To manually enter data into the system

• To delete unnecessary data

• To create new data entries

What does the term "Garbage In, Garbage Out (GIGO)" imply?

• Entering incorrect data results in incorrect output

• Entering correct data results in incorrect output

• Entering incorrect data results in correct output

• Entering correct data results in no output

Which of the following is a method of data validation?

• Data Type Check

• Data Deletion

• Data Duplication

• Data Encryption

What is an example of a Data Type Check?

• Only Yes or No can be entered into a Boolean field

• All pupils have a score of 0 up to 100

• All children in a primary school are between 4 and 11 years old

• Number must fall between a lower and upper limit

What does a Range Check ensure in data validation?

• Data falls within a specified range

• Data is entered in alphabetical order

• Data is encrypted

• Data is duplicated