GCSE ICT - Databases & Spreadsheets

What is data redundancy?

• 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.

What does data validation do?

• Checks that an input fits certain parameters such as length.
• Checks that inputted data is completely correct.
• Checks that there is no redundant data in a field.
• Checks that the correct SQL Query has been used.

A database table is used to...

• store data
• encrypt data
• retrieve data
• present data neatly

A database query is used to...

• find data based on certain criteria
• add new data
• store data
• present data neatly

A database report is used to...

• add or edit data
• store data
• find data using a search
• present data in a neat format

Which of these is NOT a proper method of validation?

• spell check
• data type check
• range check
• presence check

I control data entry. I am also used for data entry.

• table
• query
• form
• report

These hold a single peice of information about an object, person or thing

• tables
• records 
• fields
• entries

A complete description of all the fields related to one person, object or thing in a table is called

• record
• field
• table
• entry

Which data type is used to designate fields as dates and times?

• Autonumber
• Date/Time
• Number
• Text