Nulls, if used improperly, can create problems because they can represent ____.
a.
a default value
b.
a known, but missing, attribute value
c.
zero
d.
an unsortable value
2 The referential integrity rule requires that ____.
a.
every null foreign key value must reference an existing primary key value
b.
an attribute has a corresponding value
c.
every non-null foreign key value reference an existing primary key value
d.
you delete a row in one table whose primary key does not have a matching foreign key value in another table
3. According to E.F. Codd, another word for the term “relation” is ____.
a.
datafile
b.
data index
c.
table
d.
data query
5. A table can be logically connected to another table by defining a ____.
a.
hyperlink
b.
common attribute
c.
primary key
d.
logic key
7. A primary key that consists of more than one field is called a ____ key.
a.
composite
b.
secondary
c.
group
d.
foreign
8. A field that consists of integer values is a ____ type field.
a.
Date/Time
b.
Yes/No
c.
Memo
d.
Numeric