DAT 380 Wk 2 – Practice Knowledge Check

The row’s range of permissible values is known as its domain.

• True
• False

RDBMSs enforce integrity rules automatically.

• True
• False

Character data can contain any character or symbol intended for mathematical manipulation.

• True
• False

_____, also known as RESTRICT, yields values for all rows found in a table that satisfy a given condition.

• UNION
• DIFFERENCE
• INTERSECT
• SELECT

A weak relationship exists if the primary key of the related entity contains at least one primary key component of the parent entity.

• True
• False

Only a single attribute, not multiple attributes, can define functional dependence.

• True
• False

_____ returns only the attributes requested, in the order in which they are requested.

• SELECT
• UNION
• PROJECT
• DIFFERENCE

A data dictionary is sometimes described as “the database designer’s database” because it records the design decisions about tables and their structures.

• True
• False

In the relational model, _____ are important because they are used to ensure that each row in a table is uniquely identifiable.

• keys
• relations
• logical structures
• indexes

A _____ relationship exists when an association is maintained within a single entity.

• ternary
• unary
• weak
• strong