Quiz1_PracticeMarch

A predicate in a relational database represents:

• A logical expression used to filter data

• The physical location of a database table

• The relationship between two tables

• The type of primary key used in a table

Cardinality in a relationship describes:

• The number of tuples in a relation

• The number of attributes in a relation

• The number of relationships between entities

• The number of rows in a relation

Which of the following statements regarding functional dependencies is true?

• A functional dependency describes the relationship between two tables

• A functional dependency describes the relationship between two attributes in the same table

• A functional dependency indicates the number of tuples in a relation

• A functional dependency specifies the primary key of a table

A composite key:

• Is a key that is composed of multiple attributes

• Is always a candidate key

• Is the same as a primary key

• Is a key that uniquely identifies each row in a table

What is the degree of a relationship in a relational database model?

• The number of tuples in the relationship

• The number of attributes in the relationship

• The number of entities participating in the relationship

• The number of rows in the relationship