WorksheetsDatabase - Half-Term Assessment
Total questions: 40
Worksheet time: 30mins
What are databases mainly used for?
To store archived data
To store and organise data
To analyse data
Which of the following statements best defines the word 'database'?
A database is a collection of data or information which is stored in a logical and structured way
A database is a collection of statistics stored only for computers.
A database does not collect data or information.
What is the difference between an entity and an attribute?
An attribute is a table in a database and an entity is a field
An attribute is a record in a database and an entity is a table
An attribute is a field in a database and an entity is a table
Why would you create a primary key?
To make each record in a database unique
To make each field in a database unique
To make each query in a database unique
Which of the following defines the term 'field' in relation to databases?
A field is all of the information about one person or one thing
A field is the collection of all the database records on one topic or subject
A field is one type or piece of information
Which software do you use to make database?
Microsoft Word
Microsoft Excel
Microsoft Publisher
Microsoft Access
Which object would you create to share the data from your database with others?
Form
Report
Query
Table
What does "SQL" stand for?
Structured Question Language
Structured Query Language
Simple Query Language
Simple Question Language
Using which word allows you to specify that more than one condition must be met in a query?
Also
And
Or
Where
Which statement allows us to add a record to a table?
Add To
Update To
Add Into
Insert Into
Less than or equal to?
>=
=>
=<
<=
Which character returns all the data found in a table?
%
#
*
/
Which word is missing from the following SQL statement?
Select * table_name
With
Where
From
And
How do we select all rows for the "Designer" table?
SELECT * FROM Designer
SELECT [All] FROM Designer
SELECT Designer.*
SELECT FROM Designer
You have to create a PIN code for your phone that is 6 characters long. What type of check is this?
Range check
Length check
Type check
What is an atomic field?
A field that contains multiple items of data
A field that is repeated
A field that contains only one item of data
What is a foreign key?
A unique identifier in a database
A primary key of one table that appears in another table
A field that should not be in a table and needs removing
A Data Model normalised to 3rd Normal Form (3NF) meets the requirements of?
1st Normal Form (1NF)
2nd Normal Form (2NF)
3rd Normal Form (3NF)
1st, 2nd and 3rd Normal Forms (1/2/3NF)
Which validation method would you use for a user to choose a gender?
Boolean
Check digit
Value lookup check
Range check
A composite key is ......
A unique identifier
A combination of two or more columns (fields) in a table that can be used to uniquely identify each row in the table
Is a field in one table that refers to the PRIMARY KEY in another table.
Is Not Null is an example of
A RANGE check
a PRESENCE check
A LENGTH check
Is Not Null And Like "###########" is an example of ....
A PRESENCE and FORMAT check
A LENGTH and RANGE check
A LENGTH and TYPE check
In the Test Plan what does R stand for?
Erroneous
Error
Extreme
Which is the most suitable to be used for a naming convention?
Table_Customer
TBL CUSTOMER
TblCustomer
