SQL / database quiz

Who might use a database?

• School

• Police

• Employer

• All of the above

What is an advantage of a database?

• You can input information

• It saves files

• Its different to excel

• Can search and find information easily in large datasets

Short text, date, long text and number are all examples of what?

• Field

• Different Data types

• Record

• Header

A column in a database is better known as a...

• Field

• Record

• Query

• Form

A row in a database is better known as

• Field

• Record

• Query

• Form

A query is used to...

• Sort by alphabetical

• Delete records

• Search the database for information

• create a form

A _________ is a computerized filing system that is used to organize and maintain a collection of information for future use.

• Query

• Report

• Database

• Spreadsheet

Which data type would be most suitable for the 'Age' field?

• Integer (whole number)

• Float (decimal number)

• String (sequence of characters)

• Boolean (true or false)

The best data type to choose for a name in a database would be...

• Integer (whole number)

• Float (decimal number)

• String (characters joined together)

• Boolean (true or false)

What does SQL stand for...

• Structured query language

• silly query language

• simple quest language