ICC Database Management 2

Question 1

Which database normalization form eliminates transitive dependencies among non-key attributes?

Accepted Answer

Third Normal Form (3NF)

Answer

Third Normal Form (3NF) requires that non-key attributes depend only on the primary key, eliminating transitive dependencies.

Question 2

In a permit tracking database, a foreign key constraint ensures which of the following?

Accepted Answer

Referential integrity between related tables

Answer

A foreign key constraint enforces referential integrity by ensuring values in the child table exist in the referenced parent table.

Question 3

A building department wants to prevent duplicate permit numbers in its database. Which constraint should be applied?

Accepted Answer

UNIQUE constraint

Answer

A UNIQUE constraint ensures no two rows in a column or combination of columns share the same value.

Question 4

What is a database transaction's ACID property that ensures partial updates are not committed on failure?

Accepted Answer

Atomicity

Answer

Atomicity guarantees that a transaction is treated as a single unit — either all operations succeed or none are committed.

Question 5

An ICC code enforcement officer needs read-only access to inspection records. Which SQL command grants this permission?

Accepted Answer

GRANT SELECT ON inspections TO officer_role

Answer

GRANT SELECT provides read-only access, allowing the user to query data without modifying it.

(ICC) International Code Council Practice Test