WGU C175/D426 DATA MANAGEMENT
FOUNDATIONS OA UPDATED ACTUAL
Exam Questions and CORRECT Answers
In what two ways does a DBMS environment increase effectiveness in working with data? -
CORRECT ANSWER - - 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 ANSWER - Improved query response time
What is the method of organizing attributes into tables? - CORRECT ANSWER - Data
NORMALIZATION
What should a company expect from implementing a business intelligence system? - CORRECT
ANSWER - - Financial: Increased profitability
- Productivity: Increased throughput, decreased workloads
- Trust: greater satisfaction
- Risk: improved visibility
What is a relational model? - CORRECT ANSWER - A database model based on
mathematical principles
What are the 3 mathematical concepts of the relational model? - CORRECT ANSWER --
Domain
- Tuple
- Relation
Define: Domain - CORRECT ANSWER - Set of values = 'Data Type'
, Define: Tuple - CORRECT ANSWER - Finite sequence of values pulled from a fixed
domain = 'Row'
Define: Relation - CORRECT ANSWER - A named set of tuples, all from same domain =
'Table'
A tuple position is called a: - CORRECT ANSWER - Attribute
How is cardinality depicted in a diagram for many, one, and zero? - CORRECT
ANSWER - - Many = Crow's Foot
- One = a bar across the end of a relationship (--||--)
- Zero = Circle
Difference between Unary and Binary: - CORRECT ANSWER - - 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 ANSWER -
With a single vertical line through the relationship line
What does an 'M' mean when shown on an entity in an ER diagram? - CORRECT
ANSWER - Mandatory
What does a 'PI' mean when shown on an entity in an ER diagram? - CORRECT
ANSWER - Primary Identifier - used for attribute(s) that uniquely identify the whole
entity
How are maxima and minima depicted in an ER diagram? - CORRECT ANSWER -
Maxima is the first letter/number shown (outside of the entity) and Minima is the letter next to it
in parentheses
FOUNDATIONS OA UPDATED ACTUAL
Exam Questions and CORRECT Answers
In what two ways does a DBMS environment increase effectiveness in working with data? -
CORRECT ANSWER - - 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 ANSWER - Improved query response time
What is the method of organizing attributes into tables? - CORRECT ANSWER - Data
NORMALIZATION
What should a company expect from implementing a business intelligence system? - CORRECT
ANSWER - - Financial: Increased profitability
- Productivity: Increased throughput, decreased workloads
- Trust: greater satisfaction
- Risk: improved visibility
What is a relational model? - CORRECT ANSWER - A database model based on
mathematical principles
What are the 3 mathematical concepts of the relational model? - CORRECT ANSWER --
Domain
- Tuple
- Relation
Define: Domain - CORRECT ANSWER - Set of values = 'Data Type'
, Define: Tuple - CORRECT ANSWER - Finite sequence of values pulled from a fixed
domain = 'Row'
Define: Relation - CORRECT ANSWER - A named set of tuples, all from same domain =
'Table'
A tuple position is called a: - CORRECT ANSWER - Attribute
How is cardinality depicted in a diagram for many, one, and zero? - CORRECT
ANSWER - - Many = Crow's Foot
- One = a bar across the end of a relationship (--||--)
- Zero = Circle
Difference between Unary and Binary: - CORRECT ANSWER - - 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 ANSWER -
With a single vertical line through the relationship line
What does an 'M' mean when shown on an entity in an ER diagram? - CORRECT
ANSWER - Mandatory
What does a 'PI' mean when shown on an entity in an ER diagram? - CORRECT
ANSWER - Primary Identifier - used for attribute(s) that uniquely identify the whole
entity
How are maxima and minima depicted in an ER diagram? - CORRECT ANSWER -
Maxima is the first letter/number shown (outside of the entity) and Minima is the letter next to it
in parentheses
