The Relational Database Model, Chapter 3

A candidate key that does not have a null value and is selected to uniquely identify all other attribute values in any given row is called a ____.
1. superkey
2. candidate key
3. primary key
4. secondary key
A ____ functionally determines all of the row's attributes.
1. superkey
2. primary key
3. foreign key
4. combined key
____ are especially useful when you are trying to determine what value(s) in related tables cause(s) referential integrity problems.
1. Inner joins
2. Natural joins
3. Outer joins
4. Equijoins
Within a table, the primary key must be unique so that it will identify each row. When this is the case, the table is said to exhibit ____ integrity.
1. referential
2. entity
3. enforced
4. key
A(n) ____ is an orderly arrangement used to logically access rows in a table.
1. entity
2. index
3. join
4. key
A table can be logically connected to another table by defining a ____.
1. hyperlink
2. common attribute
3. primary key
4. superkey
A ____ key is defined as a key that is used strictly for data retrieval purposes.
1. primary
2. foreign
3. secondary
4. data
If a foreign key contains either matching values or nulls, the table(s) that make use of such a foreign key is/are said to exhibit ____ integrity.
1. referential
2. restrictive
3. secondary
4. redundant
The key's role is based on a concept known as ____.
1. consistency
2. availability
3. determination
4. uniqueness
A superkey that does not contain a subset of attributes that is itself a superkey is called a ____.
1. candidate key
2. primary key
3. superkey
4. secondary key
The problems inherent in the many-to-many (*:*) relationship can easily be avoided by creating a ____ entity.
1. foreign
2. composite
3. related
4. logical
Each table must have a ____ key.
1. primary
2. secondary
3. foreign
4. logical
Within a table, each primary key value ____.
1. is a minimal superkey
2. is always the first field in each table
3. must be numeric
4. must be unique
The ____ can be described as a detailed system data dictionary that describes all objects within the database, including data about table names, the table's creator and creation date, the number of columns in each table, the data type corresponding to each column, index filenames, index creators, authorized users and access privileges.
1. data dictionary
2. system catalog
3. index
4. rational structure
In a relationship, when a primary key from one table is also defined in a second table, the field is referred to as a ____ in the second table.
1. a combined key
2. redundant field
3. primary key
4. foreign key
A multi-attribute key is known as a ____ key.
1. primary
2. super
3. composite
4. foreign
We can describe a link by observing that a ____.
1. primary key of one table appears again as a primary key in a related table
2. foreign key of one table appears again as a foreign key in a related table
3. primary key of one table appears again as a foreign key in a related table
4. foreign key of one table appears again as a secondary key in a related table
____________ dictates that the foreign key must contain values that match the primatry key in the related table or must contain nulls.
1. Entity integrity
2. Functional dependence
3. Referential integrity
4. Full functional dependence
The ___________ of a relation is the number of its attributes.
1. degree
2. cardinality
3. domain
4. size
The ____________ of a relation is the number of its tuples.
1. degree
2. cardinality
3. domain
4. size

The Relational Database Model, Chapter 3

Quiz