TOC Database Management & SQL 3

Question 1

Which normal form eliminates transitive dependencies between non-key attributes?

Accepted Answer

Third Normal Form (3NF)

Answer

3NF requires that no non-key attribute depends on another non-key attribute, removing transitive dependencies.

Question 2

A PRIMARY KEY constraint in a relational database ensures which two properties?

Accepted Answer

Uniqueness and NOT NULL

Answer

A PRIMARY KEY enforces both uniqueness (no duplicate values) and NOT NULL (every row must have a value).

Question 3

Which type of database relationship exists when one employee can hold many certifications, but each certification belongs to only one employee?

Accepted Answer

One-to-Many

Answer

One-to-Many means one record on the parent side links to multiple records on the child side.

Question 4

What is the purpose of a FOREIGN KEY constraint?

Accepted Answer

To enforce referential integrity between two tables

Answer

A FOREIGN KEY ensures that a value in one table corresponds to an existing value in a referenced table, maintaining referential integrity.

Question 5

In database design, what does 'atomicity' mean in the context of First Normal Form?

Accepted Answer

Each column contains only a single, indivisible value

Answer

1NF atomicity means each column cell holds a single, indivisible value — no repeating groups or arrays.

(TOC) Talent Optimization Consultant Practice Test