DBMS MIDTERM EXAM TRUE OR FALSE (2024-25)

A well-designed database prevents redundancy but cannot avoid inconsistency.

• True

• False

Database design only focuses on how data is physically stored, not on defining relationships.

• True

• False

The primary key can contain NULL values if it is used with a foreign key.

• True

• False

A foreign key always refers to a column that is also the primary key in the same table.

• True

• False

Normalization can sometimes require creating more tables in the database.

• True

• False

First Normal Form (1NF) requires that each column in a table contains multiple values.

• True

• False

In 2NF, eliminating partial dependencies ensures that all attributes depend on the entire primary key.

• True

• False

A composite primary key consists of two or more columns that together uniquely identify a record.

• True

• False

In a database, the purpose of normalization is to increase redundancy and reduce the number of queries.

• True

• False

Third Normal Form (3NF) is achieved when there are no transitive dependencies and every non-key attribute depends only on the primary key.

• True

• False