NEW
Font size
S
M
L
XL
WorksheetsDatabases - Key Fields
Total questions: 10
Worksheet time: 3mins
Name
Class
Date
1.
A primary key of one table is known as a _______ key in other tables:
a)
foreign
b)
unknown
c)
related
d)
unique
2.
Key fields can't be left blank.
a)
True
b)
False
3.
A relationship between two entities is formed when:
a)
a primary key of one entity appears as a field in another entity.
b)
some of the data from one entity is copied to the other.
c)
these entities are merged.
d)
these entities contain very similar data.
4.
Automatically incremented primary keys are usually numeric
a)
True
b)
False
5.
A foreign key is otherwise known as a secondary key.
a)
True
b)
False
6.
What can we say about the Supplier field?
a)
All of these
b)
It is a secondary key in this table
c)
It is a primary key in the Suppliers table
d)
It is a numeric field
7.
What would be the most appropriate name for this table?
a)
Inventory
b)
Suppliers
c)
List of IDs
d)
Price list
8.
You are given two tables. Identify the primary key for Magic Stuff Co that is missing, using the information in the other table.
a)
211
b)
215
c)
1003
d)
1001
9.
This is not a valid table because:
a)
ID field needs to stay in one format but the third record as an alphanumeric ID
b)
The third record's Primary key is too long
c)
The ID numbers have gaps, e.g. ID 206 is missing
10.
Identify a wrong statement:
a)
Keys can only be numeric because text keys can't be sorted.
b)
When DBMS runs a query in a table and finds a secondary key it then searches the related table and substitutes the related value instead of a key.
c)
DBMS usually uses numeric keys.
d)
ID and key are usually used interchangeably.
Reset
