NEW
Font size
S
M
L
XL
WorksheetsDatabase Assessment (S2)
Total questions: 10
Worksheet time: 10mins
Name
Class
Date
1.
What is a database?
a)
A database is a type of spreadsheet.
b)
A database is a type of computer virus.
c)
A database is a type of video game.
d)
A database is a structured collection of data.
2.
What is a record?
a)
A row of data that contains information about a single entity or item.
b)
A type of computer virus
c)
A type of document storage
d)
A type of musical recording
3.
Which data type is used to store letters or a mixture of letters, numbers and symbols?
a)
Text
b)
Date
c)
Boolean
d)
Number
4.
What is the purpose of the Primary Key?
a)
To calculate the average value of a column
b)
To display the data in a user-friendly format
c)
To uniquely identify each record in a database table.
d)
To organize data in alphabetical order
5.
What is meant by a simple sort?
a)
Mixing items randomly
b)
Arranging items in reverse order
c)
Arranging items in a specific order based on a single criterion or condition
d)
Selecting items based on multiple attributes
6.
What is meant by a complex search?
a)
A search query that involves multiple criteria or parameters to find specific information
b)
A search query that is simple and straightforward
c)
A search query that returns no results
d)
A search query that only uses one keyword
7.
Which of the following symbols/relational operators is used for 'greater than'?
a)
<=
b)
<
c)
==
d)
>
8.
Which of the following symbols/relational operators is used for 'less than or equal to'?
a)
<=
b)
<
c)
==
d)
=>
9.
What is a 'wildcard' search?
a)
A search that only looks for exact matches
b)
A search that ignores special characters
c)
A search that only looks for capitalized words
d)
A type of search that allows for the use of special characters to represent one or more characters in a search term
10.
Which symbol is used for a wildcard search?
a)
*
b)
!
c)
,
d)
%
Reset
