NEW
Font size
S
M
L
XL
WorksheetsDatabases
Total questions: 50
Worksheet time: 27mins
Name
Class
Date
1.
A row in a database.
a)
Record
b)
Field
c)
Entity
d)
Table
2.
A column in a database.
a)
Field
b)
Record
c)
Entity
d)
Validation
3.
A rule to make sure that only reasonable and sensible data is entered.
a)
Filter
b)
Query
c)
Validation
d)
Verification
4.
Text, Number, Boolean and Date/Time are all examples of...
a)
Data Types
b)
Filters
c)
Sorts
d)
Validations
5.
A method of only displaying records in a table that match specific criteria...
a)
Filter
b)
Validation
c)
Sort
d)
Verification
6.
A method for checking data entered e.g. Proof Reading or Double Entry.
a)
Verification
b)
Filter
c)
Data Types
d)
Query
7.
A database search that can be saved as a separate file.
a)
Query
b)
Validation
c)
Filter
d)
Verification
8.
A unique identifying field.
a)
Primary Key
b)
Integer
c)
Verification
d)
Boolean
9.
A data type that can only hold 2 values e.g. Yes/No or True/False.
a)
Boolean
b)
Integer
c)
Real
d)
String
10.
Which of these is not a type of validation?
a)
Proof Reading
b)
Range
c)
Limit
d)
Presence
11.
What program is used in class for Databases?
a)
Word
b)
Excel
c)
Access
d)
Powerpoint
12.
A sports club needs to store information about each member. The individual information about each member is called a:
a)
Field
b)
File
c)
Table
d)
Record
13.
What is a database?
a)
A piece of software to do calculations
b)
A device to load information onto the computer.
c)
A structured collection of information
d)
A calculator
14.
One of the members of the Sports Club has decided to resign. What would the secretary do with the record for that member on the database?
a)
Amend the record
b)
Delete the field
c)
Delete the record
d)
Delete the file
15.
A car sales business wants to find all its customers in Paisley what database tool will it use?
a)
Report
b)
Search
c)
Query
d)
Form
16.
The Sports Club has had an Open Day and has gained a new member. How will they add their details to the database?
a)
Add another field
b)
Amend a record
c)
Add a new record
d)
Delete a record
17.
The whole database is called:
a)
The file
b)
The field
c)
The record
d)
The table
18.
All the information about one object or one thing is called a:
a)
Record
b)
Field
c)
File
d)
Table
19.
One specific piece of information about a person or thing is called:
a)
Field
b)
File
c)
Record
d)
Table
20.
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?
a)
Table
b)
Form
c)
Query
d)
Sort
21.
A gym has a database with all their members they want to include email addresses in the database, what will they do?
a)
Add a record
b)
Add a field
c)
Edit a record
d)
Delete a field
22.
The school also keep their sports data in a database. The javelin contest is to be sorted by the longest thrown javelin at the top. How will they sort it?
a)
Distance in ascending order
b)
Distance in descending order
23.
If the user must input data in a specific format, such as (919) 387-2181, this is an example of a/an:
a)
table
b)
row
c)
input mask
d)
currency
24.
Ashley is creating a database for several customers. How will she list the Customer ID?
a)
Yes/No
b)
Date
c)
Number
d)
Currency
25.
In a database, what is one piece of information called?
a)
Field
b)
Record
c)
Table
d)
Entry
26.
Declan is creating a database for several customers. What is the data type for the field customer names?
a)
Yes/No
b)
Text
c)
Number
d)
Currency
27.
Sarah is creating a database for several customers. What is the data type for the field total sales?
a)
Yes/No
b)
Text
c)
Number
d)
Currency
28.
Which are examples of database data types?
a)
Field size, format, input mask, caption
b)
Text, memo, number, currency
c)
Table, entry, field, record
d)
Filter, search, sort, query
29.
What is a database?
a)
A collection of images
b)
A large base that includes information.
c)
A collection of data that can be sorted and searched using search algorithms.
d)
A category of information
30.
What is a field?
a)
A query in a database
b)
A category of information in a database table.
c)
A collection of information about a specific person.
d)
A collection of data that can be sorted and searched using search algorithms.
31.
What is a relational database?
a)
A flat database.
b)
A database of your relatives.
c)
A database that contains multiple tables related through common fields.
d)
None of the above
32.
What is a common field?
a)
A field that is larger than others.
b)
A record in a database
c)
A field of common family.
d)
A field, contained in two or more tables, that forms a relationship between the tables
33.
One to one database
a)
Each record in Table A can have many matching records in Table B.
b)
There are no matches
c)
Each record in Table A can have only one matching record in Table B.
d)
Each record in Table A is unique.
34.
The most common type of database
a)
One to one
b)
One to many
c)
Many to many
d)
Baseball bases
35.
The definition of a database is..
a)
Something that stores, sorts & search information
b)
Something that collects, filters & displays information
36.
Which is an example of an online database?
a)
Google
b)
School
c)
Library
d)
Corner shop
37.
Which is an example of a local database?
a)
Google
b)
School
c)
Library
d)
Corner shop
38.
What is SQL?
a)
A language used by databases
b)
A query in a database
c)
A way to manipulate data
d)
A search in a database
39.
What is a DBMS?
a)
Database Management System
b)
Database Movement System
c)
Database Management Solution
d)
Database Movement Solution
40.
Which of these is not a form of data validation?
a)
Range
b)
Input Mask (Format)
c)
Presence
d)
Boolean
41.
Which of these is a form of data validation?
a)
Range
b)
Text
c)
Number
d)
Boolean
42.
What type of data validation would you use for exam results, where the maximum mark is 50?
a)
Range
b)
Presence
c)
Format
d)
Check digit
43.
What type of data validation would you use for date of births?
a)
Range
b)
Presence
c)
Input mask (Format)
d)
Check digit
44.
Arrange information in alphabetical/sequential order, A-Z, least to greatest, 1-10.
a)
ascend
b)
descend
c)
data
d)
table
45.
Arrange information in reverse order; z-a, greatest to least, 10-1.
a)
greater than
b)
less than
c)
ascend
d)
descend
46.
Which of the following is NOT an example of a database?
a)
telephone book
b)
Real Estate listing
c)
Online library card catalog
d)
DVD
47.
A tool used to organize, store, retrieve, and communicate groups of related information.
a)
Spreadsheet
b)
Word
c)
Presentations
d)
Database
48.
Identify the primary key from the following
a)
name
b)
mark
c)
telephone number
d)
Gender
49.
Which datatype can store both text and numbers
a)
Boolean
b)
Image
c)
number
d)
Text
50.
Which datatype would be the best choice to store" have you passed your driving test.
a)
text
b)
boolean
c)
memo
d)
number
Reset
