WGU C170 Data Management
ACTUAL EXAM QUESTIONS WITH
CORRECT SOLUTIONS||100%
GUARANTEED PASS||UPDATED
2026/2027 SYLLABUS||<<RECENT
VERSION>>
A process based on repetition of steps and procedures. - ANSWER ✓ iterative
process
A relationship in which one entity occurrence must have a corresponding
occurrence in another entity. For example, an EMPLOYEE works in a DIVISION.
(A person cannot be an employee without being assigned to a company's division.)
- ANSWER ✓ mandatory participation
An attribute that can have many values for a single entity occurrence. For
example, an EMP_DEGREE attribute might store the string "BBA, MBA, PHD" to
indicate three different degrees held. - ANSWER ✓ multivalued attributes
A relationship in which the primary key of the related entity does not contain a
primary key component of the parent entity. - ANSWER ✓ non-identifying
relationship
In ER modeling, an attribute that does not require a value; therefore, it can be left
empty. - ANSWER ✓ optional attribute
In ER modeling, a condition in which one entity occurrence does not require a
corresponding entity occurrence in a particular relationship. - ANSWER ✓
optional participation
, An ER term for entities that participate in a relationship. For example, in the
relationship "PROFESSOR teaches CLASS," the teaches relationship is based on
the participants PROFESSOR and CLASS. - ANSWER ✓ participants
A relationship found within a single entity type. For example, an EMPLOYEE is
married to an EMPLOYEE or a PART is a component of another PART. -
ANSWER ✓ recursive relationship
See strong entity. - ANSWER ✓ regular entity
The organization of a relational database as described by the database
administrator. - ANSWER ✓ relational schema
The number of entities or participants associated with a relationship. A
relationship degree can be unary, binary, ternary, or higher. - ANSWER ✓
relationship degree
In ER modeling, an attribute that must have a value. In other words, it cannot be
left empty. - ANSWER ✓ required attribute
An attribute that cannot be subdivided into meaningful components. Compare to
composite attribute. - ANSWER ✓ simple attribute
An attribute that can have only one value. - ANSWER ✓ single-valued attribute
A relationship that occurs when two entities are existence-dependent; from a
database design perspective, this relationship exists whenever the primary key of
the related entity contains the primary key of the parent entity. - ANSWER ✓
strong (identifying) relationship
An entity that is existence-independent, that is, it can exist apart from all of its
related entities. Also called a regular entity. - ANSWER ✓ strong entity
An ER term used to describe an association (relationship) between three entities.
For example, a DOCTOR prescribes a DRUG for a PATIENT. - ANSWER ✓
ternary relationship
, An ER term used to describe an association within an entity. For example, an
EMPLOYEE might manage another EMPLOYEE. - ANSWER ✓ unary
relationship
An entity that displays existence dependence and inherits the primary key of its
parent entity. For example, a DEPENDENT requires the existence of an
EMPLOYEE. - ANSWER ✓ weak entity
A relationship in which the primary key of the related entity does not contain a
primary key component of the parent entity. - ANSWER ✓ weak relationship
An alternative name for a column or table in a SQL statement. - ANSWER ✓
alias
The SQL command used to make changes to table structure. When the command
is followed by a keyword (ADD or MODIFY), it adds a column or changes column
characteristics. - ANSWER ✓ ALTER TABLE
The SQL logical operator used to link multiple conditional expressions in a
WHERE or HAVING clause. It requires that all conditional expressions evaluate
to true. - ANSWER ✓ AND
The process through which a DBMS verifies that only registered users can access
the database. - ANSWER ✓ authentication
A SQL aggregate function that outputs the mean average for a specified column or
expression. - ANSWER ✓ AVG
In SQL, a special comparison operator used to check whether a value is within a
range of specified values. - ANSWER ✓ BETWEEN
A branch of mathematics that uses the logical operators OR, AND, and NOT. -
ANSWER ✓ Boolean algebra
A nested ordering sequence for a set of rows, such as a list in which all last names
are alphabetically ordered and, within the last names, all first names are ordered. -
ANSWER ✓ cascading order sequence
ACTUAL EXAM QUESTIONS WITH
CORRECT SOLUTIONS||100%
GUARANTEED PASS||UPDATED
2026/2027 SYLLABUS||<<RECENT
VERSION>>
A process based on repetition of steps and procedures. - ANSWER ✓ iterative
process
A relationship in which one entity occurrence must have a corresponding
occurrence in another entity. For example, an EMPLOYEE works in a DIVISION.
(A person cannot be an employee without being assigned to a company's division.)
- ANSWER ✓ mandatory participation
An attribute that can have many values for a single entity occurrence. For
example, an EMP_DEGREE attribute might store the string "BBA, MBA, PHD" to
indicate three different degrees held. - ANSWER ✓ multivalued attributes
A relationship in which the primary key of the related entity does not contain a
primary key component of the parent entity. - ANSWER ✓ non-identifying
relationship
In ER modeling, an attribute that does not require a value; therefore, it can be left
empty. - ANSWER ✓ optional attribute
In ER modeling, a condition in which one entity occurrence does not require a
corresponding entity occurrence in a particular relationship. - ANSWER ✓
optional participation
, An ER term for entities that participate in a relationship. For example, in the
relationship "PROFESSOR teaches CLASS," the teaches relationship is based on
the participants PROFESSOR and CLASS. - ANSWER ✓ participants
A relationship found within a single entity type. For example, an EMPLOYEE is
married to an EMPLOYEE or a PART is a component of another PART. -
ANSWER ✓ recursive relationship
See strong entity. - ANSWER ✓ regular entity
The organization of a relational database as described by the database
administrator. - ANSWER ✓ relational schema
The number of entities or participants associated with a relationship. A
relationship degree can be unary, binary, ternary, or higher. - ANSWER ✓
relationship degree
In ER modeling, an attribute that must have a value. In other words, it cannot be
left empty. - ANSWER ✓ required attribute
An attribute that cannot be subdivided into meaningful components. Compare to
composite attribute. - ANSWER ✓ simple attribute
An attribute that can have only one value. - ANSWER ✓ single-valued attribute
A relationship that occurs when two entities are existence-dependent; from a
database design perspective, this relationship exists whenever the primary key of
the related entity contains the primary key of the parent entity. - ANSWER ✓
strong (identifying) relationship
An entity that is existence-independent, that is, it can exist apart from all of its
related entities. Also called a regular entity. - ANSWER ✓ strong entity
An ER term used to describe an association (relationship) between three entities.
For example, a DOCTOR prescribes a DRUG for a PATIENT. - ANSWER ✓
ternary relationship
, An ER term used to describe an association within an entity. For example, an
EMPLOYEE might manage another EMPLOYEE. - ANSWER ✓ unary
relationship
An entity that displays existence dependence and inherits the primary key of its
parent entity. For example, a DEPENDENT requires the existence of an
EMPLOYEE. - ANSWER ✓ weak entity
A relationship in which the primary key of the related entity does not contain a
primary key component of the parent entity. - ANSWER ✓ weak relationship
An alternative name for a column or table in a SQL statement. - ANSWER ✓
alias
The SQL command used to make changes to table structure. When the command
is followed by a keyword (ADD or MODIFY), it adds a column or changes column
characteristics. - ANSWER ✓ ALTER TABLE
The SQL logical operator used to link multiple conditional expressions in a
WHERE or HAVING clause. It requires that all conditional expressions evaluate
to true. - ANSWER ✓ AND
The process through which a DBMS verifies that only registered users can access
the database. - ANSWER ✓ authentication
A SQL aggregate function that outputs the mean average for a specified column or
expression. - ANSWER ✓ AVG
In SQL, a special comparison operator used to check whether a value is within a
range of specified values. - ANSWER ✓ BETWEEN
A branch of mathematics that uses the logical operators OR, AND, and NOT. -
ANSWER ✓ Boolean algebra
A nested ordering sequence for a set of rows, such as a list in which all last names
are alphabetically ordered and, within the last names, all first names are ordered. -
ANSWER ✓ cascading order sequence
