NEW
Font size
S
M
L
XL
WorksheetsBTEC unit 2 databases - key terms
Total questions: 15
Worksheet time: 10mins
Name
Class
Date
1.
A row in a database.
a)
Record
b)
Field
c)
Entity
d)
Table
2.
A unique identifying field.
a)
Primary Key
b)
Integer
c)
Verification
d)
Boolean
3.
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
4.
Which of the following describes a relational database?
a)
Access
b)
A database that has a table
c)
There are two or more tables that are linked using the primary keys
d)
There are more than one table that have duplicate data
5.
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
6.
One specific piece of information about a person or thing is called:
a)
Field
b)
File
c)
Record
d)
Table
7.
Which of these could be a primary key?
a)
Centre number
b)
Surname
c)
Teacher name
d)
Students addresses
8.
How many records are in this database?
a)
8
b)
5
c)
10
d)
12
9.
What is the primary key in this database?
a)
Emp_Id
b)
Last Name
c)
Gender
d)
Title
10.
SQL stands for
a)
Structured Query Language
b)
Sequenced Query Language
c)
Structured Question Language
d)
Structured Query Learning
11.
A DBMS is a
a)
Database management system
b)
Database multi system
c)
Data set management system
d)
Database merger system
12.
What is a foreign key?
a)
The primary key in one table used to link to another table
b)
Two fields combined together to make one key
c)
A unique identifier
13.
These two words mean the same thing - entity and ….
a)
table
b)
field
c)
record
d)
row
14.
These two words mean the same thing - field and ...
a)
column
b)
attribute
c)
record
d)
table
15.
Select is an operation that returns..
a)
all records from a table that meet the criteria
b)
all the data from a combination of two tables
c)
records that appear in two tables
Reset
