WGU D427 Database Management Applications
2026/2027 | WGU D427 Database Management
Applications OA Study Guide, Practice Questions &
Answers, Objective Assessment Exam Prep, SQL,
Relational Databases, Database Design, Queries,
Tables, Keys, Joins, Normalization & Detailed
Rationales
WGU D427 Database Management Applications study and exam-prep
material for Western Governors University students preparing for the
D427 Objective Assessment (OA). The course focuses on practical
relational database concepts and SQL skills, including database design,
relational models, tables, primary and foreign keys, relationships,
normalization, SQL syntax, SELECT queries, filtering, sorting, joins,
aggregate functions, subqueries, data manipulation, database
constraints and query interpretation. This resource is designed for
WGU D427 practice questions and answers, OA preparation, SQL
problem-solving, comprehensive database review and detailed
rationales, helping students reinforce both conceptual database
knowledge and practical SQL application.
,Question 1: Which SQL clause is used to filter rows before any
grouping or aggregation occurs?
A. HAVING
B. WHERE
C. GROUP BY
D. ORDER BY
CORRECT ANSWER: B. WHERE
Rationale: The WHERE clause filters individual rows based on a specified
condition before grouping or aggregation takes place. The HAVING clause
is used to filter groups after aggregation, while GROUP BY organizes rows
into groups and ORDER BY sorts the final result set.
Question 2: Which SQL statement is classified as a Data
Manipulation Language (DML) command?
A. CREATE
B. ALTER
C. INSERT
D. DROP
CORRECT ANSWER: C. INSERT
Rationale: INSERT is a DML command used to add new rows to a table.
CREATE, ALTER, and DROP are Data Definition Language (DDL)
commands that define or modify the structure of database objects, not the
data itself.
Question 3: What is the primary purpose of a foreign key in a
relational database?
A. To uniquely identify each row within its own table
B. To establish a link between two tables based on a referenced key
C. To automatically generate sequential numeric values
D. To encrypt sensitive data in a column
CORRECT ANSWER: B. To establish a link between two tables
based on a referenced key
Rationale: A foreign key is a column or set of columns in one table that
references the primary key or unique key of another table. This creates a
relationship between the two tables and enforces referential integrity,
,ensuring that values in the foreign key column correspond to existing
values in the referenced table.
Question 4: Which constraint ensures that a column cannot contain
NULL values?
A. UNIQUE
B. CHECK
C. NOT NULL
D. DEFAULT
CORRECT ANSWER: C. NOT NULL
Rationale: The NOT NULL constraint enforces that a column must contain
a value for every row and cannot be left empty. The UNIQUE constraint
prevents duplicate values, CHECK validates values against a condition, and
DEFAULT provides a value when none is specified.
Question 5: Which SQL statement retrieves all columns from a
table named Customer?
A. SELECT ALL FROM Customer;
B. SELECT * FROM Customer;
C. GET * FROM Customer;
D. SELECT ALL COLUMNS Customer;
CORRECT ANSWER: B. SELECT * FROM Customer;
Rationale: The asterisk (*) is a wildcard in SQL that represents all columns
in the specified table. The SELECT statement with * retrieves every column
and every row from the Customer table.
Question 6: What does the DISTINCT keyword accomplish in a
SELECT statement?
A. Sorts the result set in ascending order
B. Removes duplicate rows from the result set
C. Limits the number of rows returned
D. Groups rows with identical values
CORRECT ANSWER: B. Removes duplicate rows from the result set
Rationale: DISTINCT eliminates duplicate rows from the output of a query,
returning only unique combinations of values. ORDER BY handles sorting,
LIMIT restricts row count, and GROUP BY creates groups for aggregation.
, Question 7: Which SQL command is used to remove all rows from a
table while preserving the table structure?
A. DROP TABLE
B. DELETE FROM
C. TRUNCATE TABLE
D. REMOVE TABLE
CORRECT ANSWER: C. TRUNCATE TABLE
Rationale: TRUNCATE TABLE removes all rows from a table quickly
without logging individual row deletions, and the table structure remains
intact. DROP TABLE removes the entire table including its structure.
DELETE FROM can remove rows but logs each deletion and does not reset
auto-increment counters.
Question 8: In an Entity-Relationship diagram, what shape
represents an entity?
A. Diamond
B. Oval
C. Rectangle
D. Triangle
CORRECT ANSWER: C. Rectangle
Rationale: In standard ER diagram notation, rectangles represent entities,
which are objects or concepts about which data is stored. Diamonds
represent relationships, ovals represent attributes, and lines connect entities
to relationships.
Question 9: Which normal form eliminates transitive
dependencies?
A. First Normal Form (1NF)
B. Second Normal Form (2NF)
C. Third Normal Form (3NF)
D. Boyce-Codd Normal Form (BCNF)
CORRECT ANSWER: C. Third Normal Form (3NF)
Rationale: Third Normal Form requires that all non-prime attributes are
non-transitively dependent on the primary key. 1NF eliminates repeating
groups, 2NF eliminates partial dependencies on a composite key, and
2026/2027 | WGU D427 Database Management
Applications OA Study Guide, Practice Questions &
Answers, Objective Assessment Exam Prep, SQL,
Relational Databases, Database Design, Queries,
Tables, Keys, Joins, Normalization & Detailed
Rationales
WGU D427 Database Management Applications study and exam-prep
material for Western Governors University students preparing for the
D427 Objective Assessment (OA). The course focuses on practical
relational database concepts and SQL skills, including database design,
relational models, tables, primary and foreign keys, relationships,
normalization, SQL syntax, SELECT queries, filtering, sorting, joins,
aggregate functions, subqueries, data manipulation, database
constraints and query interpretation. This resource is designed for
WGU D427 practice questions and answers, OA preparation, SQL
problem-solving, comprehensive database review and detailed
rationales, helping students reinforce both conceptual database
knowledge and practical SQL application.
,Question 1: Which SQL clause is used to filter rows before any
grouping or aggregation occurs?
A. HAVING
B. WHERE
C. GROUP BY
D. ORDER BY
CORRECT ANSWER: B. WHERE
Rationale: The WHERE clause filters individual rows based on a specified
condition before grouping or aggregation takes place. The HAVING clause
is used to filter groups after aggregation, while GROUP BY organizes rows
into groups and ORDER BY sorts the final result set.
Question 2: Which SQL statement is classified as a Data
Manipulation Language (DML) command?
A. CREATE
B. ALTER
C. INSERT
D. DROP
CORRECT ANSWER: C. INSERT
Rationale: INSERT is a DML command used to add new rows to a table.
CREATE, ALTER, and DROP are Data Definition Language (DDL)
commands that define or modify the structure of database objects, not the
data itself.
Question 3: What is the primary purpose of a foreign key in a
relational database?
A. To uniquely identify each row within its own table
B. To establish a link between two tables based on a referenced key
C. To automatically generate sequential numeric values
D. To encrypt sensitive data in a column
CORRECT ANSWER: B. To establish a link between two tables
based on a referenced key
Rationale: A foreign key is a column or set of columns in one table that
references the primary key or unique key of another table. This creates a
relationship between the two tables and enforces referential integrity,
,ensuring that values in the foreign key column correspond to existing
values in the referenced table.
Question 4: Which constraint ensures that a column cannot contain
NULL values?
A. UNIQUE
B. CHECK
C. NOT NULL
D. DEFAULT
CORRECT ANSWER: C. NOT NULL
Rationale: The NOT NULL constraint enforces that a column must contain
a value for every row and cannot be left empty. The UNIQUE constraint
prevents duplicate values, CHECK validates values against a condition, and
DEFAULT provides a value when none is specified.
Question 5: Which SQL statement retrieves all columns from a
table named Customer?
A. SELECT ALL FROM Customer;
B. SELECT * FROM Customer;
C. GET * FROM Customer;
D. SELECT ALL COLUMNS Customer;
CORRECT ANSWER: B. SELECT * FROM Customer;
Rationale: The asterisk (*) is a wildcard in SQL that represents all columns
in the specified table. The SELECT statement with * retrieves every column
and every row from the Customer table.
Question 6: What does the DISTINCT keyword accomplish in a
SELECT statement?
A. Sorts the result set in ascending order
B. Removes duplicate rows from the result set
C. Limits the number of rows returned
D. Groups rows with identical values
CORRECT ANSWER: B. Removes duplicate rows from the result set
Rationale: DISTINCT eliminates duplicate rows from the output of a query,
returning only unique combinations of values. ORDER BY handles sorting,
LIMIT restricts row count, and GROUP BY creates groups for aggregation.
, Question 7: Which SQL command is used to remove all rows from a
table while preserving the table structure?
A. DROP TABLE
B. DELETE FROM
C. TRUNCATE TABLE
D. REMOVE TABLE
CORRECT ANSWER: C. TRUNCATE TABLE
Rationale: TRUNCATE TABLE removes all rows from a table quickly
without logging individual row deletions, and the table structure remains
intact. DROP TABLE removes the entire table including its structure.
DELETE FROM can remove rows but logs each deletion and does not reset
auto-increment counters.
Question 8: In an Entity-Relationship diagram, what shape
represents an entity?
A. Diamond
B. Oval
C. Rectangle
D. Triangle
CORRECT ANSWER: C. Rectangle
Rationale: In standard ER diagram notation, rectangles represent entities,
which are objects or concepts about which data is stored. Diamonds
represent relationships, ovals represent attributes, and lines connect entities
to relationships.
Question 9: Which normal form eliminates transitive
dependencies?
A. First Normal Form (1NF)
B. Second Normal Form (2NF)
C. Third Normal Form (3NF)
D. Boyce-Codd Normal Form (BCNF)
CORRECT ANSWER: C. Third Normal Form (3NF)
Rationale: Third Normal Form requires that all non-prime attributes are
non-transitively dependent on the primary key. 1NF eliminates repeating
groups, 2NF eliminates partial dependencies on a composite key, and
