WorksheetsSQL / database quiz
Total questions: 10
Worksheet time: 5mins
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
