Font size
S
M
L
XL
WorksheetsN5 Database Development (full)
Total questions: 86
Worksheet time: 30mins
Name
Class
Date
1.
What is a database?
a)
A command centre for information
b)
An organised collection of structured information.
c)
A flat file of information
d)
Heirarchical information
2.
In a database, what is an entity?
a)
A record
b)
An attribute
c)
A table
d)
A field
3.
In a database, what is an attribute?
a)
A record
b)
An entity
c)
A table
d)
A field
4.
In a database, what is a table?
a)
A record
b)
An attribute
c)
An entity
d)
A field
5.
In a database, what is a field?
a)
A record
b)
An attribute
c)
A table
d)
An entity
6.
In a database, what is a record?
a)
A collection of related fields about the same item.
b)
A collection of records about a topic.
c)
A single piece of data.
7.
In a database, what is a table?
a)
A collection of related fields about the same item.
b)
A collection of records about a topic.
c)
A single piece of data.
8.
In a database, what is a field?
a)
A collection of related fields about the same item.
b)
A collection of records about a topic.
c)
A single piece of data.
9.
In a database, what is an attribute?
a)
A collection of related fields about the same item.
b)
A collection of records about a topic.
c)
A single piece of data.
10.
In a database, what is an entity?
a)
A collection of related fields about the same item.
b)
A collection of records about a topic.
c)
A single piece of data.
11.
In a database, what is a record?
a)
A row
b)
A table
c)
An entity
d)
A column
12.
In a database, what is a row?
a)
A record
b)
An attribute
c)
An entity
d)
A field
13.
In a database, what is a column?
a)
A record
b)
A table
c)
An entity
d)
A field
14.
In a database, what is a row?
a)
A collection of related fields about the same item.
b)
A collection of records about a topic.
c)
A single piece of data.
15.
In a database, what is a column?
a)
A collection of related fields about the same item.
b)
A collection of records about a topic.
c)
A single piece of data.
16.
In a database, what are the 5 attribute types?
a)
Boolean, Date, Integer, String, Time
b)
Boolean, Date, Integer, Text, Time
c)
Boolean, Date, Number, Text, Time
d)
Boolean, Date, Real, String, Time
17.
In a database, what are the 5 field types?
a)
Boolean, Date, Integer, String, Time
b)
Boolean, Date, Real, Text, Time
c)
Boolean, Date, Number, Text, Time
d)
Boolean, Date, Real, String, Time
18.
Which attribute type needs a size?
a)
Boolean
b)
Text
c)
Date
d)
Time
e)
Integer
19.
Which field type needs a size?
a)
Boolean
b)
Text
c)
Date
d)
Time
e)
Integer
20.
Why do we need a primary key field?
a)
To make sure every record in an entity is unique.
b)
We don't need a primary key field.
c)
No-one knows.
21.
Why do we need a primary key field?
a)
To make sure every row in a table is unique.
b)
We don't need a primary key field.
c)
No-one knows.
22.
What is special about a primary key field?
a)
It is always a number.
b)
It has to be a text field.
c)
There are only 3 different values.
d)
Every record in the table has a different value for the primary key field.
23.
What can we do if there are no fields in a table with a unique value in each record?
a)
Add a new field with a different value in every record.
b)
Change one of the fields to be different in every row.
c)
Give up, the table is invalid.
d)
Add a boolean field.
24.
What does a validation rule do?
a)
Makes sure the data is right.
b)
Makes sure the data makes sense (is possible).
c)
Makes sure the data is the right type.
d)
Nothing
25.
True or False: A validation rule makes sure the data is correct.
a)
True
b)
False
26.
True or False: A validation rule makes sure the data is possible.
a)
True
b)
False
27.
True or False: A validation rule makes sure the data makes sense.
a)
True
b)
False
28.
Which one is the best primary key for an adult?
a)
Name
b)
Postcode
c)
National Insurance Number
d)
Date of Birth
29.
Which one is a good primary key for an international flight?
a)
Name
b)
Postcode
c)
National Insurance Number
d)
Passport Number
e)
Date of Birth
30.
Which validation rule do we use to check a field has data in it?
(a)
31.
Which validation rule do we use to check a field is not empty?
(a)
32.
Which validation rule do we use to make a field required?
(a)
33.
What is another name for a field with a presence check?
a)
An empty field
b)
A null field
c)
A required field
34.
Which validation rule do we use to check a text field is not too long?
(a)
35.
Which validation rule do we use to check the user's data will fit in a text field?
(a)
36.
Which validation rule only allows certain values in a text field?
(a)
37.
Which validation rule only allows certain values in a number field?
(a)
38.
Which validation rule checks a numeric value is not too big?
(a)
39.
Which validation rule checks a numeric value is not too small?
(a)
40.
Which validation rule makes the user pick from a list of values?
(a)
41.
What is a data dictionary?
a)
A list of the data in a database.
b)
A set of information that describes the contents, format, and structure of a database.
c)
A glossary of the terms in a database,
d)
All the data in a database.
42.
In a data dictionary, what is the code for a primary key?
(a)
43.
Does a data dictionary include field type information?
a)
Yes, for all attributes.
b)
Yes, but only for number types
c)
Yes, but not for text attributes
d)
No
44.
Does a data dictionary include field size information?
a)
Yes, for all attributes.
b)
Yes, but only for text types
c)
Yes, but not for number attributes
d)
No
45.
Does a data dictionary include whether a presence check is needed?
a)
Yes, in the Required column
b)
No
46.
Does a data dictionary include validation?
a)
Yes, both the type and the rule.
b)
Yes, just the type.
c)
Yes, just the rule.
d)
No.
47.
Which SQL command searches for records?
(a)
48.
Which SQL clause has the search criteria in?
(a)
49.
Which SQL clause has the sort order in?
(a)
50.
Which SQL clause has the entity in?
(a)
51.
Which SQL clause has the table in?
(a)
52.
What does the FROM clause do?
a)
List which tables (entities) to look for the data in.
b)
State the search criteria.
c)
State the sort order of the result data.
53.
What does the FROM clause do?
a)
List which tables to look for the data in.
b)
State the search criteria.
c)
State the sort order of the result data.
54.
What does the FROM clause do?
a)
List which entities to look for the data in.
b)
State the search criteria.
c)
State the sort order of the result data.
55.
What does the WHERE clause do?
a)
List which tables (entities) to look for the data in.
b)
State the search criteria.
c)
State the sort order of the result data.
56.
What does the ORDER BY clause do?
a)
List which tables (entities) to look for the data in.
b)
State the search criteria.
c)
State the sort order of the result data.
57.
What are search criteria?
a)
The tables (entities) to look in.
b)
What to look for.
c)
The order to sort in.
58.
Which fields does a SELECT query output?
a)
All fields.
b)
The fields in the list after the word SELECT.
c)
The fields needed for the search criteria.
d)
The fields to be sorted.
59.
Name one of the three logical operators.
(a)
60.
In a WHERE clause, what does AND mean?
a)
Only return records where both conditions are TRUE
b)
Only return records where none of the conditions is TRUE.
c)
Only return records where one or more of the conditions is TRUE.
61.
In computing science, what is a condition?
a)
The weather
b)
A statement
c)
A question
d)
A list
e)
An illness
62.
In a WHERE clause, what does OR mean?
a)
Only return records where both conditions are TRUE
b)
Only return records where none of the conditions is TRUE.
c)
Only return records where one or more of the conditions is TRUE.
63.
What does ascending mean?
a)
Going up
b)
Going Down
64.
What does descending mean?
a)
Going up
b)
Going Down
65.
Which SQL statement adds a record to a table?
(a)
66.
Which SQL statement removes records from a table?
(a)
67.
Which SQL command finds records?
(a)
68.
Which SQL command edits records in a table?
(a)
69.
What does the SELECT SQL statement do?
a)
Finds records.
b)
Removes records
c)
Adds records.
d)
Edits records.
70.
What does the DELETE SQL statement do?
a)
Finds records.
b)
Removes records
c)
Adds records.
d)
Edits records.
71.
What does the INSERT SQL statement do?
a)
Finds records.
b)
Removes records
c)
Adds records.
d)
Edits records.
72.
What does the UPDATE SQL statement do?
a)
Finds records.
b)
Removes records
c)
Adds records.
d)
Edits records.
73.
Which field do we use as the criteria to delete a single record?
a)
The Primary Key Field
b)
A foreign key field.
c)
Any field.
d)
We can’t delete just one record.
74.
What is a relational database?
a)
A relational database is made up of two or more tables that are joined together.
b)
A relational database is made up of a single table.
c)
A relational database is made up of two tables that are joined together.
75.
What do we call the join between two tables in a relational database?
a)
A relationship
b)
A link
c)
A primary key
d)
A foreign key
76.
What is a foreign key?
a)
A field with the primary key from another table in it.
b)
A second field that could be a primary key in a table.
c)
A field with countries in it.
77.
What does every table in a relational database have to have?
a)
A foreign key
b)
A name field
c)
A primary key
d)
A date field
78.
In databases, what is a relationship?
a)
A foreign key
b)
A join between two tables.
c)
Primary keys
79.
What is referential integrity?
a)
All foreign key values are in the primary key of the one side table.
b)
Some foreign key values are in the primary key of the one side table.
c)
Some foreign key values are not in the primary key of the one side table.
80.
True or False: The foreign key is always in the many side table.
a)
True
b)
False
81.
True or False: Entities (tables) are linked using a foreign key (many side) and a primary key (one side).
a)
True
b)
False
82.
True or False: Both tables in a relationship need a primary key?
a)
True
b)
False
83.
True or False: A foreign key can have a value that is not in the primary key of the one side table yet.
a)
True
b)
False
84.
Which side of a relationship must have a foreign key field?
a)
Many
b)
One
85.
What do we call a link between a primary key in one table and a foreign key in another table?
a)
A relationship
b)
A primary key
c)
A foreign key
86.
What do we call the rule that states that every value in a foreign key must be in the primary key of the referenced table?
a)
Referential Integrity
b)
A relationship
c)
Link Integrity
d)
The Join Rule
Reset
