NEW
Font size
WorksheetsDatabases
Total questions: 16
Worksheet time: 8mins
What is a database?
A piece of software to do calculations
A device to load information onto the computer.
A structured collection of records
A calculator
A sports club needs to store information about each member. The all the information about each member is called a:
Field
File
Table
Record
A scout company have a database with records of all the scouts. They want to create a list of all scouts who are under 15 and their achievements. What would they use?
Report
Form
Query
Sort
The school wants to sort the data in alphabetical order by staff Surname. How will they sort it?
Ascending order
Descending order
Text, Integer, Currency, Boolean and Date/Time are all examples of...
Data Types
Filters
Sorts
Validations
The four main objects of a database consist of:
form, table, query, report
filter, table, database, query
form, data type, record, query
form, record, field, report
What does "SQL" stand for?
Structured Question Language
Structured Query Language
Simple Query Language
Simple Question Language
Which statement is used to extract data from a database?
Extract
Get
Open
Select
Which word is missing from the following SQL statement?
Select * table_name
With
Where
From
And
How would we script a SQL query to select "Description" from the Item table?
SELECT Item.Description
EXTRACT Description FROM Item
SELECT Item FROM Description
SELECT Description FROM Item
