WGU C175/D426 DATA MANAGEMENT
FOUNDATIONS OA 2025 UPDATED EXAM |
ACTUAL EXAM 2 LATEST VERSIONS 400
QUESTIONS AND CORRECT VERIFIED
ANSWERS WITH RATIONALES (100%
CORRECT) A+ GRADED ASSURED
4 Actions to Correct Referential Integrity Violation: - CORRECT ANSWER: 1. RESTRICT -
rejects an insert, update, or delete
2. SET NULL - sets invalid foreign keys to null
3. SET DEFAULT - sets invalid foreign keys to a default primary value
4. CASCADE - propagates primary key changes to foreign keys
4 Ways Referential Integrity can be violated: - CORRECT ANSWER: 1. Primary key is updated
2. Foreign key is updated
3. Row containing primary key is DELETED
4. Row containing foreign key is INSERTED
A _____ attribute is one that cannot be subdivided - CORRECT ANSWER: Atomic
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
A derived attribute _____. - CORRECT ANSWER: need not be physically stored within the
database
,A foreign key must: - CORRECT ANSWER: Match a primary key in a related table
A pet owner can have many pets; a specific pet is linked to one pet owner. What is the binary
relationship described? - CORRECT ANSWER: One-To-Many
A record consists of a: - CORRECT ANSWER: set of one or more fields
A special operator used to check for similar character strings is: - CORRECT ANSWER: LIKE
A table can be logically connected to another table by defining a _____. - CORRECT ANSWER:
common attribute
A table is perceived as a ______. - CORRECT ANSWER: Two-dimensional structure
A tuple position is called a: - CORRECT ANSWER: Attribute
An attribute (or group of attributes) that uniquely identifies each entity in a table is called: -
CORRECT ANSWER: A superkey
CHAR vs. VARCHAR - CORRECT ANSWER: - CHAR: Fixed number of characters
- VARCHAR: Variable length of characters
Data warehouses are refreshed periodically with a 5-step process: - CORRECT ANSWER: 1.
Extraction
2. Cleanse
3. Integrate
4. Restructure
5. Load
, Database models were developed to _____? - CORRECT ANSWER: model real-world events or
conditions
Define: Affinity Grouping - CORRECT ANSWER: Evaluating relationships between data
elements that demonstrate some kind of affinity between objects
Define: Classification (Data Mining) - CORRECT ANSWER: - Organizing data into predefined
classes
Define: Clustering & Segmentation - when is it helpful? - CORRECT ANSWER: - Taking large
entity and dividing into smaller groups of entities
- Useful when unsure of what looking for
Define: Detail; How it applies to operational and analytical DB? - CORRECT ANSWER: - A
database that keeps record of individual transactions; line items
- Operational: Detailed
- Analytical: Detailed
Define: Domain - CORRECT ANSWER: Set of values = 'Data Type'
Define: Estimation (Data Mining) - CORRECT ANSWER: - Assigning a numeric value to an
object
Define: Functional Dependency - CORRECT ANSWER: Each value of a column relates to at
MOST one value of another column
Dependence of one column on another
Define: History; How it applies to operational and analytical DB? - CORRECT ANSWER: -
Whether DB is current or tracks all data
FOUNDATIONS OA 2025 UPDATED EXAM |
ACTUAL EXAM 2 LATEST VERSIONS 400
QUESTIONS AND CORRECT VERIFIED
ANSWERS WITH RATIONALES (100%
CORRECT) A+ GRADED ASSURED
4 Actions to Correct Referential Integrity Violation: - CORRECT ANSWER: 1. RESTRICT -
rejects an insert, update, or delete
2. SET NULL - sets invalid foreign keys to null
3. SET DEFAULT - sets invalid foreign keys to a default primary value
4. CASCADE - propagates primary key changes to foreign keys
4 Ways Referential Integrity can be violated: - CORRECT ANSWER: 1. Primary key is updated
2. Foreign key is updated
3. Row containing primary key is DELETED
4. Row containing foreign key is INSERTED
A _____ attribute is one that cannot be subdivided - CORRECT ANSWER: Atomic
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
A derived attribute _____. - CORRECT ANSWER: need not be physically stored within the
database
,A foreign key must: - CORRECT ANSWER: Match a primary key in a related table
A pet owner can have many pets; a specific pet is linked to one pet owner. What is the binary
relationship described? - CORRECT ANSWER: One-To-Many
A record consists of a: - CORRECT ANSWER: set of one or more fields
A special operator used to check for similar character strings is: - CORRECT ANSWER: LIKE
A table can be logically connected to another table by defining a _____. - CORRECT ANSWER:
common attribute
A table is perceived as a ______. - CORRECT ANSWER: Two-dimensional structure
A tuple position is called a: - CORRECT ANSWER: Attribute
An attribute (or group of attributes) that uniquely identifies each entity in a table is called: -
CORRECT ANSWER: A superkey
CHAR vs. VARCHAR - CORRECT ANSWER: - CHAR: Fixed number of characters
- VARCHAR: Variable length of characters
Data warehouses are refreshed periodically with a 5-step process: - CORRECT ANSWER: 1.
Extraction
2. Cleanse
3. Integrate
4. Restructure
5. Load
, Database models were developed to _____? - CORRECT ANSWER: model real-world events or
conditions
Define: Affinity Grouping - CORRECT ANSWER: Evaluating relationships between data
elements that demonstrate some kind of affinity between objects
Define: Classification (Data Mining) - CORRECT ANSWER: - Organizing data into predefined
classes
Define: Clustering & Segmentation - when is it helpful? - CORRECT ANSWER: - Taking large
entity and dividing into smaller groups of entities
- Useful when unsure of what looking for
Define: Detail; How it applies to operational and analytical DB? - CORRECT ANSWER: - A
database that keeps record of individual transactions; line items
- Operational: Detailed
- Analytical: Detailed
Define: Domain - CORRECT ANSWER: Set of values = 'Data Type'
Define: Estimation (Data Mining) - CORRECT ANSWER: - Assigning a numeric value to an
object
Define: Functional Dependency - CORRECT ANSWER: Each value of a column relates to at
MOST one value of another column
Dependence of one column on another
Define: History; How it applies to operational and analytical DB? - CORRECT ANSWER: -
Whether DB is current or tracks all data
