WGU C175/D426 DATA MANAGEMENT FOUNDATIONS OA | ACTUAL EXA
2 LATEST VERSIONS 104 QUESTIONS AND CORRECT VERIFIED ANSWERS
1. In what two ways does a DBMS en- - Enables Data Sharing
vironment increase effectiveness in - Storage of vast volumes of data
working with data?
2. A company posts an internet-based Improved query response time
newsletter about their products. What
advantage will this company gain
from the relational database manage-
ment system that will store customer
information?
3. What is the method of organizing at- Data NORMALIZATION
tributes into tables?
4. What should a company expect from - Financial: Increased profitability
implementing a business intelligence - Productivity: Increased throughput, decreased
system? workloads
- Trust: greater satisfaction
- Risk: improved visibility
5. What is a relational model? A database model based on mathematical princi-
ples
6. What are the 3 mathematical con- - Domain
cepts of the relational model? - Tuple
- Relation
7. Define: Domain Set of values = 'Data Type'
8. Define: Tuple Finite sequence of values pulled from a fixed do-
main = 'Row'
9. Define: Relation
, WGU C175/D426 DATA MANAGEMENT FOUNDATIONS OA | ACTUAL EXA
2 LATEST VERSIONS 104 QUESTIONS AND CORRECT VERIFIED ANSWERS
A named set of tuples, all from same domain =
'Table'
10. A tuple position is called a: Attribute
11. How is cardinality depicted in a dia- - Many = Crow's Foot
gram for many, one, and zero? - One = a bar across the end of a relationship
(--||--)
- Zero = Circle
12. Difference between Unary and Bina- - Unary: One entity involved in relationship (one
ry: box, one line)
- Binary: Two entities (two boxes combined by one
line)
13. If an entity is mandatory, how is it de- With a single vertical line through the relationship
picted in an ER diagram? line
14. What does an 'M' mean when shown Mandatory
on an entity in an ER diagram?
15. What does a 'PI' mean when shown on Primary Identifier - used for attribute(s) that
an entity in an ER diagram? uniquely identify the whole entity
16. How are maxima and minima depict- Maxima is the first letter/number shown (outside
ed in an ER diagram? of the entity) and Minima is the letter next to it in
parentheses
17. Define: Singular Attribute Each entity instance has at most ONE attribute in-
stance
18. Define: Plural Attribute Each entity instance can have MANY attribute in-
stances
2 LATEST VERSIONS 104 QUESTIONS AND CORRECT VERIFIED ANSWERS
1. In what two ways does a DBMS en- - Enables Data Sharing
vironment increase effectiveness in - Storage of vast volumes of data
working with data?
2. A company posts an internet-based Improved query response time
newsletter about their products. What
advantage will this company gain
from the relational database manage-
ment system that will store customer
information?
3. What is the method of organizing at- Data NORMALIZATION
tributes into tables?
4. What should a company expect from - Financial: Increased profitability
implementing a business intelligence - Productivity: Increased throughput, decreased
system? workloads
- Trust: greater satisfaction
- Risk: improved visibility
5. What is a relational model? A database model based on mathematical princi-
ples
6. What are the 3 mathematical con- - Domain
cepts of the relational model? - Tuple
- Relation
7. Define: Domain Set of values = 'Data Type'
8. Define: Tuple Finite sequence of values pulled from a fixed do-
main = 'Row'
9. Define: Relation
, WGU C175/D426 DATA MANAGEMENT FOUNDATIONS OA | ACTUAL EXA
2 LATEST VERSIONS 104 QUESTIONS AND CORRECT VERIFIED ANSWERS
A named set of tuples, all from same domain =
'Table'
10. A tuple position is called a: Attribute
11. How is cardinality depicted in a dia- - Many = Crow's Foot
gram for many, one, and zero? - One = a bar across the end of a relationship
(--||--)
- Zero = Circle
12. Difference between Unary and Bina- - Unary: One entity involved in relationship (one
ry: box, one line)
- Binary: Two entities (two boxes combined by one
line)
13. If an entity is mandatory, how is it de- With a single vertical line through the relationship
picted in an ER diagram? line
14. What does an 'M' mean when shown Mandatory
on an entity in an ER diagram?
15. What does a 'PI' mean when shown on Primary Identifier - used for attribute(s) that
an entity in an ER diagram? uniquely identify the whole entity
16. How are maxima and minima depict- Maxima is the first letter/number shown (outside
ed in an ER diagram? of the entity) and Minima is the letter next to it in
parentheses
17. Define: Singular Attribute Each entity instance has at most ONE attribute in-
stance
18. Define: Plural Attribute Each entity instance can have MANY attribute in-
stances
