1Z0-006 Data Modeling 4

Question 1

A table stores OrderID, ProductID, ProductName, and Quantity. OrderID+ProductID form the primary key. ProductName depends only on ProductID. Which normal form is violated?

Accepted Answer

2NF, because ProductName is partially dependent on the composite key

Answer

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

Question 2

Which ERD notation uses 'crows foot' symbols combined with a vertical bar and circle to show minimum and maximum cardinality?

Accepted Answer

IE (Information Engineering) / Crow's Foot notation

Answer

Information Engineering (Crow's Foot) notation uses symbols at each end of a relationship line to indicate minimum (optional/mandatory) and maximum (one/many) cardinality.

Question 3

What is a self-referencing (recursive) relationship in an ERD?

Accepted Answer

A relationship where an entity relates to itself

Answer

A recursive relationship occurs when an entity has a relationship with itself, such as an EMPLOYEE who manages other EMPLOYEEs.

Question 4

In Oracle SQL Developer Data Modeler, what is the difference between a 'logical' and a 'relational' model?

Accepted Answer

A logical model uses entity/attribute terminology; a relational model maps these to tables/columns with keys

Answer

The logical model uses abstract entity and attribute concepts, while the relational model transforms these into tables, columns, primary keys, and foreign keys for implementation.

Question 5

Which of the following best describes entity integrity?

Accepted Answer

No primary key column can contain a NULL value

Answer

Entity integrity requires that primary key columns never contain NULL, ensuring every row can be uniquely identified.

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

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

1Z0-006 Data Modeling 4