WGU C175/D426 DATA MANAGEMENT |\ |\ |\ |\
FOUNDATIONS OA 2025 UPDATED EXAM |\ |\ |\ |\ |\
ACTUAL EXAM 2 LATEST VERSIONS |\ |\ |\ |\ |\
QUESTIONS AND CORRECT VERIFIED |\ |\ |\ |\
ANSWERS |\
In what two ways does a DBMS environment increase
|\ |\ |\ |\ |\ |\ |\ |\ |\
effectiveness in working with data? - CORRECT ANSWERS ✔✔- |\ |\ |\ |\ |\ |\ |\ |\ |\
Enables Data Sharing |\ |\
- Storage of vast volumes of data
|\ |\ |\ |\ |\ |\
A company posts an internet-based newsletter about their
|\ |\ |\ |\ |\ |\ |\ |\
products. What advantage will this company gain from the
|\ |\ |\ |\ |\ |\ |\ |\ |\
relational database management system that will store customer
|\ |\ |\ |\ |\ |\ |\ |\
information? - CORRECT ANSWERS ✔✔Improved query response |\ |\ |\ |\ |\ |\ |\
time
What is the method of organizing attributes into tables? -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
CORRECT ANSWERS ✔✔Data NORMALIZATION |\ |\ |\
What should a company expect from implementing a business
|\ |\ |\ |\ |\ |\ |\ |\ |\
intelligence system? - CORRECT ANSWERS ✔✔- Financial:
|\ |\ |\ |\ |\ |\ |\
Increased profitability |\
- Productivity: Increased throughput, decreased workloads
|\ |\ |\ |\ |\
- Trust: greater satisfaction
|\ |\ |\
- Risk: improved visibility
|\ |\ |\
,What is a relational model? - CORRECT ANSWERS ✔✔A database
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
model based on mathematical principles
|\ |\ |\ |\
What are the 3 mathematical concepts of the relational model? -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
CORRECT ANSWERS ✔✔- Domain |\ |\ |\
- Tuple
|\
- Relation
|\
Define: Domain - CORRECT ANSWERS ✔✔Set of values = 'Data
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
Type'
Define: Tuple - CORRECT ANSWERS ✔✔Finite sequence of values
|\ |\ |\ |\ |\ |\ |\ |\ |\
pulled from a fixed domain = 'Row'
|\ |\ |\ |\ |\ |\
Define: Relation - CORRECT ANSWERS ✔✔A named set of tuples,
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
all from same domain = 'Table'
|\ |\ |\ |\ |\
A tuple position is called a: - CORRECT ANSWERS ✔✔Attribute
|\ |\ |\ |\ |\ |\ |\ |\ |\
How is cardinality depicted in a diagram for many, one, and zero?
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
- CORRECT ANSWERS ✔✔- Many = Crow's Foot
|\ |\ |\ |\ |\ |\ |\ |\
- One = a bar across the end of a relationship (--||--)
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
- Zero = Circle
|\ |\ |\
, Difference between Unary and Binary: - CORRECT ANSWERS ✔✔-
|\ |\ |\ |\ |\ |\ |\ |\ |\
Unary: One entity involved in relationship (one box, one line)
|\ |\ |\ |\ |\ |\ |\ |\ |\
- Binary: Two entities (two boxes combined by one line)
|\ |\ |\ |\ |\ |\ |\ |\ |\
If an entity is mandatory, how is it depicted in an ER diagram? -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
CORRECT ANSWERS ✔✔With a single vertical line through the
|\ |\ |\ |\ |\ |\ |\ |\ |\
relationship line |\
What does an 'M' mean when shown on an entity in an ER
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
diagram? - CORRECT ANSWERS ✔✔Mandatory
|\ |\ |\ |\
What does a 'PI' mean when shown on an entity in an ER
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
diagram? - CORRECT ANSWERS ✔✔Primary Identifier - used for
|\ |\ |\ |\ |\ |\ |\ |\ |\
attribute(s) that uniquely identify the whole entity|\ |\ |\ |\ |\ |\
How are maxima and minima depicted in an ER diagram? -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
CORRECT ANSWERS ✔✔Maxima is the first letter/number shown
|\ |\ |\ |\ |\ |\ |\ |\
(outside of the entity) and Minima is the letter next to it in
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
parentheses
Define: Singular Attribute - CORRECT ANSWERS ✔✔Each entity
|\ |\ |\ |\ |\ |\ |\ |\
instance has at most ONE attribute instance
|\ |\ |\ |\ |\ |\
Define: Plural Attribute - CORRECT ANSWERS ✔✔Each entity
|\ |\ |\ |\ |\ |\ |\ |\
instance can have MANY attribute instances
|\ |\ |\ |\ |\
Define: Unique Attribute - CORRECT ANSWERS ✔✔Each attribute
|\ |\ |\ |\ |\ |\ |\ |\
instance describes only ONE entity instance
|\ |\ |\ |\ |\
FOUNDATIONS OA 2025 UPDATED EXAM |\ |\ |\ |\ |\
ACTUAL EXAM 2 LATEST VERSIONS |\ |\ |\ |\ |\
QUESTIONS AND CORRECT VERIFIED |\ |\ |\ |\
ANSWERS |\
In what two ways does a DBMS environment increase
|\ |\ |\ |\ |\ |\ |\ |\ |\
effectiveness in working with data? - CORRECT ANSWERS ✔✔- |\ |\ |\ |\ |\ |\ |\ |\ |\
Enables Data Sharing |\ |\
- Storage of vast volumes of data
|\ |\ |\ |\ |\ |\
A company posts an internet-based newsletter about their
|\ |\ |\ |\ |\ |\ |\ |\
products. What advantage will this company gain from the
|\ |\ |\ |\ |\ |\ |\ |\ |\
relational database management system that will store customer
|\ |\ |\ |\ |\ |\ |\ |\
information? - CORRECT ANSWERS ✔✔Improved query response |\ |\ |\ |\ |\ |\ |\
time
What is the method of organizing attributes into tables? -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
CORRECT ANSWERS ✔✔Data NORMALIZATION |\ |\ |\
What should a company expect from implementing a business
|\ |\ |\ |\ |\ |\ |\ |\ |\
intelligence system? - CORRECT ANSWERS ✔✔- Financial:
|\ |\ |\ |\ |\ |\ |\
Increased profitability |\
- Productivity: Increased throughput, decreased workloads
|\ |\ |\ |\ |\
- Trust: greater satisfaction
|\ |\ |\
- Risk: improved visibility
|\ |\ |\
,What is a relational model? - CORRECT ANSWERS ✔✔A database
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
model based on mathematical principles
|\ |\ |\ |\
What are the 3 mathematical concepts of the relational model? -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
CORRECT ANSWERS ✔✔- Domain |\ |\ |\
- Tuple
|\
- Relation
|\
Define: Domain - CORRECT ANSWERS ✔✔Set of values = 'Data
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
Type'
Define: Tuple - CORRECT ANSWERS ✔✔Finite sequence of values
|\ |\ |\ |\ |\ |\ |\ |\ |\
pulled from a fixed domain = 'Row'
|\ |\ |\ |\ |\ |\
Define: Relation - CORRECT ANSWERS ✔✔A named set of tuples,
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
all from same domain = 'Table'
|\ |\ |\ |\ |\
A tuple position is called a: - CORRECT ANSWERS ✔✔Attribute
|\ |\ |\ |\ |\ |\ |\ |\ |\
How is cardinality depicted in a diagram for many, one, and zero?
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
- CORRECT ANSWERS ✔✔- Many = Crow's Foot
|\ |\ |\ |\ |\ |\ |\ |\
- One = a bar across the end of a relationship (--||--)
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
- Zero = Circle
|\ |\ |\
, Difference between Unary and Binary: - CORRECT ANSWERS ✔✔-
|\ |\ |\ |\ |\ |\ |\ |\ |\
Unary: One entity involved in relationship (one box, one line)
|\ |\ |\ |\ |\ |\ |\ |\ |\
- Binary: Two entities (two boxes combined by one line)
|\ |\ |\ |\ |\ |\ |\ |\ |\
If an entity is mandatory, how is it depicted in an ER diagram? -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
CORRECT ANSWERS ✔✔With a single vertical line through the
|\ |\ |\ |\ |\ |\ |\ |\ |\
relationship line |\
What does an 'M' mean when shown on an entity in an ER
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
diagram? - CORRECT ANSWERS ✔✔Mandatory
|\ |\ |\ |\
What does a 'PI' mean when shown on an entity in an ER
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
diagram? - CORRECT ANSWERS ✔✔Primary Identifier - used for
|\ |\ |\ |\ |\ |\ |\ |\ |\
attribute(s) that uniquely identify the whole entity|\ |\ |\ |\ |\ |\
How are maxima and minima depicted in an ER diagram? -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
CORRECT ANSWERS ✔✔Maxima is the first letter/number shown
|\ |\ |\ |\ |\ |\ |\ |\
(outside of the entity) and Minima is the letter next to it in
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
parentheses
Define: Singular Attribute - CORRECT ANSWERS ✔✔Each entity
|\ |\ |\ |\ |\ |\ |\ |\
instance has at most ONE attribute instance
|\ |\ |\ |\ |\ |\
Define: Plural Attribute - CORRECT ANSWERS ✔✔Each entity
|\ |\ |\ |\ |\ |\ |\ |\
instance can have MANY attribute instances
|\ |\ |\ |\ |\
Define: Unique Attribute - CORRECT ANSWERS ✔✔Each attribute
|\ |\ |\ |\ |\ |\ |\ |\
instance describes only ONE entity instance
|\ |\ |\ |\ |\
