1Z0-006 Entity-Relationship Modeling 3

Question 1

An entity that cannot be uniquely identified by its own attributes alone and depends on another entity is called a:

Accepted Answer

Weak entity

Answer

A weak entity lacks sufficient attributes to form its own primary key and relies on its owner (strong) entity for full identification.

Question 2

In ER modeling, 'participation constraint' refers to:

Accepted Answer

Whether every entity instance must participate in a relationship (total) or participation is optional (partial)

Answer

Participation constraints specify whether all (total) or only some (partial) entity instances must participate in a given relationship.

Question 3

What does a '1' on one side and an 'M' on the other side of a relationship line signify?

Accepted Answer

One-to-many relationship

Answer

A 1:M (one-to-many) relationship means one instance on the '1' side can be associated with multiple instances on the 'M' side.

Question 4

Which of the following is TRUE about a recursive (unary) relationship?

Accepted Answer

It is a relationship where an entity type is associated with itself

Answer

A unary (recursive) relationship associates instances of a single entity type with each other, such as an Employee who manages other Employees.

Question 5

When an ER diagram shows a relationship with an attribute (e.g., 'Date' on a WORKS_FOR relationship), what does this indicate?

Accepted Answer

The attribute describes a property of the relationship itself, not either entity alone

Answer

Relationship attributes capture information that only makes sense in the context of the association between two entities, not either entity individually.

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

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

1Z0-006 Entity-Relationship Modeling 3