Font size
WorksheetsDatabase Basics v2 N5
Total questions: 20
Worksheet time: 10mins
Which field type can only be one of two possibilities?
Boolean (Yes/No)
Graphic (OLE Object)
Date
Time
Which field type can hold a picture?
Boolean (Yes/No)
Graphic (OLE Object)
Date
Time
How many fields are shown here?
5
7
11
35
How many records are shown here?
5
7
11
35
How have the results shown been sorted?
On the 'Id' field in Descending order
On the 'Id' field in Ascending order
On the 'City' field in Descending order
On the 'City' field in Ascending order
At which Stage of the Database Development Process would you identify the User Requirements and Functional Requirements?
Analysis Stage
Design Stage
Implementation Stage
Testing Stage
Evaluation Stage
At which Stage of the Database Development Process would you create an Entity Relationship Diagram?
Analysis Stage
Design Stage
Implementation Stage
Testing Stage
Evaluation Stage
At which Stage of the Database Development Process would you create a Data Dictionary?
Analysis Stage
Design Stage
Implementation Stage
Testing Stage
Evaluation Stage
At which Stage of the Database Development Process would you plan what your queries will be by stating Tables, Fields, Search Criteria and Sort Order?
Analysis Stage
Design Stage
Implementation Stage
Testing Stage
Evaluation Stage
At which Stage of the Database Development Process would you create database tables including fields and validation?
Analysis Stage
Design Stage
Implementation Stage
Testing Stage
Evaluation Stage
At which Stage of the Database Development Process would you create SQL queries?
Analysis Stage
Design Stage
Implementation Stage
Testing Stage
Evaluation Stage
At which Stage of the Database Development Process would you check that your SQL operations have worked correctly?
Analysis Stage
Design Stage
Implementation Stage
Testing Stage
Evaluation Stage
At which Stage of the Database Development Process would you write a paragraph discussing how accurate the output is from your database?
Analysis Stage
Design Stage
Implementation Stage
Testing Stage
Evaluation Stage
At which Stage of the Database Development Process would you write a paragraph discussing the "Fitness for Purpose" of your database?
Analysis Stage
Design Stage
Implementation Stage
Testing Stage
Evaluation Stage
When evaluating the "Fitness for Purpose" of your database, which two other stages must you refer back to?
Analysis Stage
Design Stage
Implementation Stage
Testing Stage
What is cardinality?
A description of whether the relationship between entities in one-to-one, one-to-many or many-to-many
A verb to describe the relationship between entities e.g. "has" or "attends"
A type of validation where a drop-down menu restricts the choices in the foreign key field
Which type of validation forces an entry in that field for each record?
Presence Check
Range Check
Length Check
Restricted Choice
Which type of validation forces the value entered for a number, date or time field to meet certain limits?
Presence Check
Range Check
Length Check
Restricted Choice
Which type of validation forces the value entered for a text field to meet a restriction on the number of characters that can be entered?
Presence Check
Range Check
Length Check
Restricted Choice
Which type of validation forces the value entered for a field to be chosen from a list of valid options?
Presence Check
Range Check
Length Check
Restricted Choice
