1Z0-006 Relational Data Model 2

Question 1

Which normal form eliminates partial dependencies on a composite primary key?

Accepted Answer

Second Normal Form (2NF)

Answer

2NF removes partial dependencies, meaning every non-key attribute must depend on the entire composite primary key, not just part of it.

Question 2

A table has columns: OrderID, ProductID, ProductName, Quantity. OrderID+ProductID is the PK. ProductName depends only on ProductID. Which normal form is violated?

Accepted Answer

2NF

Answer

ProductName depends only on ProductID (part of the composite key), creating a partial dependency that violates 2NF.

Question 3

Which constraint ensures a column cannot contain duplicate values but can contain NULLs?

Accepted Answer

UNIQUE

Answer

A UNIQUE constraint prevents duplicate values but, unlike PRIMARY KEY, allows multiple NULL values in Oracle.

Question 4

In the relational model, what term describes the set of all allowed values for a column?

Accepted Answer

Domain

Answer

A domain defines the set of permissible values for an attribute, such as positive integers or valid date ranges.

Question 5

Which type of relationship requires a junction (bridge) table to be implemented in a relational database?

Accepted Answer

Many-to-many

Answer

A many-to-many relationship cannot be directly represented in relational tables and requires a junction table containing foreign keys from both sides.

(1Z0-006) Oracle Database Foundations Associate Practice Test

(1Z0-006) Oracle Database Foundations Associate Practice Test

1Z0-006 Relational Data Model 2