WGU C175 D426 DATA MANAGEMENT FOUNDATIONS OA
EXAM 2026/2027 | 2 Latest Versions with 300 Questions |
Verified Answers and Detailed Rationales | Already Graded
A+ | Pass Guaranteed
VERSION A (150 Questions)
Competency 1: Database Fundamentals (20 Questions)
Q1: Which of the following best describes the primary advantage of the relational
database model over hierarchical and network models?
● A. Faster data retrieval through pointer-based navigation
● B. Simplified data access using mathematical relations and SQL without
navigating complex physical structures
● C. Reduced storage requirements through elimination of redundant data
● D. Enhanced support for complex many-to-many relationships through physical
links
Correct Answer: B
Rationale: The relational model's primary advantage is data independence and
simplified access through mathematical relations (tables) and declarative SQL queries.
Unlike hierarchical models (tree structures) and network models (pointer-based sets)
that require navigating physical paths, relational databases allow users to query data
without knowing physical storage details. Option A describes network/hierarchical
advantages. Option C is incorrect as redundancy reduction comes from normalization,
not the model itself. Option D describes network model capabilities, not relational
advantages.
,Q2: A database administrator needs to ensure that when a transaction updates multiple
tables, either all changes are committed or none are committed. Which ACID property
directly addresses this requirement?
● A. Atomicity
● B. Consistency
● C. Isolation
● D. Durability
Correct Answer: A
Rationale: Atomicity ensures that a transaction is treated as a single, indivisible unit of
work—either all operations complete successfully (commit) or all fail (rollback).
Consistency (B) ensures data remains valid according to constraints. Isolation (C)
prevents interference between concurrent transactions. Durability (D) guarantees
committed changes survive system failures. The scenario describes the all-or-nothing
principle of Atomicity.
Q3: Which three characteristics correctly differentiate a Database Management System
(DBMS) from a file processing system? (Select all that apply)
● A. Data redundancy is eliminated through centralized control
● B. Data independence separates logical and physical data structures
● C. Concurrent access is managed through locking mechanisms
● D. Data is stored in flat files with application-specific formats
● E. Security is enforced through user authentication and authorization
Correct Answers: A, B, C, E
Rationale: A DBMS provides centralized control reducing redundancy (A), data
independence separating logical/physical views (B), concurrency control via locking (C),
and security through authentication/authorization (E). Option D describes file
processing systems, not DBMS. While DBMS reduces redundancy, it doesn't completely
eliminate it—some controlled redundancy may exist for performance, but the centralized
control is the key differentiator.
,Q4: In a three-schema database architecture, which mapping allows applications to
remain unaffected when the physical storage structure changes?
● A. External/Conceptual mapping
● B. Conceptual/Internal mapping
● C. External/Internal mapping
● D. Logical/Physical mapping
Correct Answer: B
Rationale: The Conceptual/Internal mapping (also called Logical/Physical mapping)
provides physical data independence. When storage structures (indexes, file
organizations) change, only this mapping requires modification—the conceptual
schema and external schemas remain unchanged. External/Conceptual mapping (A)
provides logical data independence (changes to conceptual schema). Option C doesn't
exist in standard three-schema architecture. Option D is an alternative name for B but
less precise in ANSI-SPARC terminology.
Q5: A company stores customer data where each customer has multiple phone
numbers, and each phone number belongs to one customer. In database terminology,
this represents which type of relationship?
● A. One-to-One (1:1)
● B. One-to-Many (1:M)
● C. Many-to-Many (M:N)
● D. Recursive relationship
Correct Answer: B
Rationale: One customer has many phone numbers (1 side), but each phone number
belongs to exactly one customer (M side)—this is a classic One-to-Many relationship.
One-to-One (A) would mean each customer has exactly one phone number and vice
versa. Many-to-Many (C) would require phone numbers to belong to multiple customers.
Recursive (D) involves an entity related to itself.
, Q6: Which SQL command category includes CREATE, ALTER, and DROP statements?
● A. DML (Data Manipulation Language)
● B. DCL (Data Control Language)
● C. DDL (Data Definition Language)
● D. TCL (Transaction Control Language)
Correct Answer: C
Rationale: DDL (Data Definition Language) defines database structures: CREATE
(objects), ALTER (modifications), DROP (deletion). DML (A) handles data manipulation
(SELECT, INSERT, UPDATE, DELETE). DCL (B) manages permissions (GRANT, REVOKE).
TCL (D) controls transactions (COMMIT, ROLLBACK). Understanding these categories is
essential for database administration and WGU competency assessment.
Q7: A database system must maintain referential integrity when deleting a department
record that has associated employee records. Which referential integrity action
automatically deletes all related employee records when the department is deleted?
● A. SET NULL
● B. SET DEFAULT
● C. CASCADE
● D. RESTRICT
Correct Answer: C
Rationale: CASCADE automatically propagates the deletion (or update) from parent to
child records, deleting all employees in the department. SET NULL (A) sets foreign keys
to NULL (requires nullable columns). SET DEFAULT (B) sets foreign keys to default
values. RESTRICT (D) prevents deletion if child records exist. CASCADE is useful for
maintaining integrity but requires careful use to avoid accidental mass deletions.
Q8: Which of the following best describes metadata in a database context?
EXAM 2026/2027 | 2 Latest Versions with 300 Questions |
Verified Answers and Detailed Rationales | Already Graded
A+ | Pass Guaranteed
VERSION A (150 Questions)
Competency 1: Database Fundamentals (20 Questions)
Q1: Which of the following best describes the primary advantage of the relational
database model over hierarchical and network models?
● A. Faster data retrieval through pointer-based navigation
● B. Simplified data access using mathematical relations and SQL without
navigating complex physical structures
● C. Reduced storage requirements through elimination of redundant data
● D. Enhanced support for complex many-to-many relationships through physical
links
Correct Answer: B
Rationale: The relational model's primary advantage is data independence and
simplified access through mathematical relations (tables) and declarative SQL queries.
Unlike hierarchical models (tree structures) and network models (pointer-based sets)
that require navigating physical paths, relational databases allow users to query data
without knowing physical storage details. Option A describes network/hierarchical
advantages. Option C is incorrect as redundancy reduction comes from normalization,
not the model itself. Option D describes network model capabilities, not relational
advantages.
,Q2: A database administrator needs to ensure that when a transaction updates multiple
tables, either all changes are committed or none are committed. Which ACID property
directly addresses this requirement?
● A. Atomicity
● B. Consistency
● C. Isolation
● D. Durability
Correct Answer: A
Rationale: Atomicity ensures that a transaction is treated as a single, indivisible unit of
work—either all operations complete successfully (commit) or all fail (rollback).
Consistency (B) ensures data remains valid according to constraints. Isolation (C)
prevents interference between concurrent transactions. Durability (D) guarantees
committed changes survive system failures. The scenario describes the all-or-nothing
principle of Atomicity.
Q3: Which three characteristics correctly differentiate a Database Management System
(DBMS) from a file processing system? (Select all that apply)
● A. Data redundancy is eliminated through centralized control
● B. Data independence separates logical and physical data structures
● C. Concurrent access is managed through locking mechanisms
● D. Data is stored in flat files with application-specific formats
● E. Security is enforced through user authentication and authorization
Correct Answers: A, B, C, E
Rationale: A DBMS provides centralized control reducing redundancy (A), data
independence separating logical/physical views (B), concurrency control via locking (C),
and security through authentication/authorization (E). Option D describes file
processing systems, not DBMS. While DBMS reduces redundancy, it doesn't completely
eliminate it—some controlled redundancy may exist for performance, but the centralized
control is the key differentiator.
,Q4: In a three-schema database architecture, which mapping allows applications to
remain unaffected when the physical storage structure changes?
● A. External/Conceptual mapping
● B. Conceptual/Internal mapping
● C. External/Internal mapping
● D. Logical/Physical mapping
Correct Answer: B
Rationale: The Conceptual/Internal mapping (also called Logical/Physical mapping)
provides physical data independence. When storage structures (indexes, file
organizations) change, only this mapping requires modification—the conceptual
schema and external schemas remain unchanged. External/Conceptual mapping (A)
provides logical data independence (changes to conceptual schema). Option C doesn't
exist in standard three-schema architecture. Option D is an alternative name for B but
less precise in ANSI-SPARC terminology.
Q5: A company stores customer data where each customer has multiple phone
numbers, and each phone number belongs to one customer. In database terminology,
this represents which type of relationship?
● A. One-to-One (1:1)
● B. One-to-Many (1:M)
● C. Many-to-Many (M:N)
● D. Recursive relationship
Correct Answer: B
Rationale: One customer has many phone numbers (1 side), but each phone number
belongs to exactly one customer (M side)—this is a classic One-to-Many relationship.
One-to-One (A) would mean each customer has exactly one phone number and vice
versa. Many-to-Many (C) would require phone numbers to belong to multiple customers.
Recursive (D) involves an entity related to itself.
, Q6: Which SQL command category includes CREATE, ALTER, and DROP statements?
● A. DML (Data Manipulation Language)
● B. DCL (Data Control Language)
● C. DDL (Data Definition Language)
● D. TCL (Transaction Control Language)
Correct Answer: C
Rationale: DDL (Data Definition Language) defines database structures: CREATE
(objects), ALTER (modifications), DROP (deletion). DML (A) handles data manipulation
(SELECT, INSERT, UPDATE, DELETE). DCL (B) manages permissions (GRANT, REVOKE).
TCL (D) controls transactions (COMMIT, ROLLBACK). Understanding these categories is
essential for database administration and WGU competency assessment.
Q7: A database system must maintain referential integrity when deleting a department
record that has associated employee records. Which referential integrity action
automatically deletes all related employee records when the department is deleted?
● A. SET NULL
● B. SET DEFAULT
● C. CASCADE
● D. RESTRICT
Correct Answer: C
Rationale: CASCADE automatically propagates the deletion (or update) from parent to
child records, deleting all employees in the department. SET NULL (A) sets foreign keys
to NULL (requires nullable columns). SET DEFAULT (B) sets foreign keys to default
values. RESTRICT (D) prevents deletion if child records exist. CASCADE is useful for
maintaining integrity but requires careful use to avoid accidental mass deletions.
Q8: Which of the following best describes metadata in a database context?
