WGU D427 Database Management Applications
Exam Questions With 100% Correct Answers
Verified | Latest Update 2026/2027
80 Questions | 6 Sections | SQL Fundamentals • DDL • DML • DQL • Normalization • Advanced SQL
Section 1: SQL Fundamentals (Questions 1–15)
Q1. Which SQL statement is used to retrieve data from a database?
A. INSERT
B. UPDATE
C. SELECT ✓
D. DELETE
Correct Answer: C
Rationale: SELECT is the Data Query Language (DQL) command used to retrieve data from one or more tables.
INSERT adds new rows, UPDATE modifies existing rows, and DELETE removes rows. SELECT is part of DQL while
INSERT, UPDATE, and DELETE are DML (Data Manipulation Language) commands.
Q2. Which of the following correctly identifies the four main SQL sublanguages?
A. DDL, DML, DQL, DCL ✓
B. SELECT, INSERT, UPDATE, DELETE
C. CREATE, READ, UPDATE, DELETE
D. SQL, NoSQL, PL/SQL, T-SQL
Correct Answer: A
Rationale: SQL is divided into DDL (Data Definition Language — CREATE, ALTER, DROP), DML (Data
Manipulation Language — INSERT, UPDATE, DELETE), DQL (Data Query Language — SELECT), and DCL (Data
Control Language — GRANT, REVOKE). Option B lists DML/DQL commands only. Option C describes CRUD
operations. Option D describes SQL variants.
Q3. In a relational database, a 'primary key' serves which purpose?
A. It stores the most important data value in a row
B. It uniquely identifies each row in a table and cannot be NULL ✓
C. It links one table to another table
D. It defines the default sort order of the table
Correct Answer: B
Rationale: A primary key uniquely identifies each row (record) in a table. It must be unique across all rows and
cannot contain NULL values. Option C describes a foreign key's role (which references the primary key in another
table). Option A and D are not correct definitions — primary keys are about unique row identification, not data
importance or sort order.
Q4. Which SQL keyword is used to prevent duplicate rows in a SELECT query result?
A. UNIQUE
B. DISTINCT ✓
, C. FILTER
D. GROUP
Correct Answer: B
Rationale: DISTINCT eliminates duplicate rows from SELECT results: SELECT DISTINCT column FROM table.
UNIQUE is a constraint used in table definitions to enforce uniqueness in a column, not a SELECT filter keyword.
FILTER is used with aggregate window functions in some dialects. GROUP (BY) groups rows for aggregation but
does not directly eliminate duplicates.
Q5. What is a 'NULL' value in SQL?
A. A value of zero (0) stored in a numeric column
B. An empty string stored in a text column
C. The absence of any value — unknown or missing data ✓
D. A reserved keyword meaning 'false' in a Boolean column
Correct Answer: C
Rationale: NULL represents the absence of a value — not zero, not an empty string, but truly missing or unknown
data. NULL requires special handling: comparisons use IS NULL / IS NOT NULL rather than = NULL. Arithmetic with
NULL produces NULL. NULL != 0 and NULL != '' (empty string). This distinction is critical for writing correct WHERE
clause filters.
Q6. Which clause in a SELECT statement filters rows AFTER grouping has been performed?
A. WHERE
B. HAVING ✓
C. GROUP BY
D. ORDER BY
Correct Answer: B
Rationale: HAVING filters groups created by GROUP BY, allowing conditions on aggregate functions (e.g., HAVING
COUNT(*) > 5). WHERE filters individual rows BEFORE grouping occurs and cannot reference aggregate functions.
GROUP BY creates the groups. ORDER BY sorts the final result set. The logical execution order is: WHERE →
GROUP BY → HAVING → SELECT → ORDER BY.
Q7. A 'foreign key' in a relational table is best described as:
A. Any column that is indexed for faster retrieval
B. A column (or set of columns) that references the primary key of another table, enforcing referential
integrity ✓
C. The second column defined in a CREATE TABLE statement
D. A column containing encrypted data values
Correct Answer: B
Rationale: A foreign key establishes a referential integrity constraint between two tables: the values in the foreign
key column must match existing primary key values in the referenced table (or be NULL if allowed). This prevents
orphaned records. Foreign keys do not have to be indexed (though indexing them improves JOIN performance). They
are defined by their referencing relationship, not their position in the CREATE TABLE statement.
Q8. Which of the following is the correct SQL comment syntax for a single-line comment?
A. /* This is a comment */
B. // This is a comment
C. -- This is a comment ✓
D. # This is a comment (standard SQL)
Correct Answer: C
Rationale: Standard SQL uses -- (double dash) for single-line comments. /* ... */ is the standard multi-line (block)
comment syntax (Option A is also valid but is multi-line). // is used in languages like Java and C++, not standard SQL.
# is used in MySQL as a non-standard single-line comment but is not ANSI SQL standard. For WGU D427, -- is the
correct single-line comment syntax.
, Q9. What does 'ACID' stand for in the context of database transactions?
A. Automated, Consistent, Isolated, Durable
B. Atomicity, Consistency, Isolation, Durability ✓
C. Atomic, Committed, Integrated, Distributed
D. Atomicity, Consistency, Indexed, Data-secure
Correct Answer: B
Rationale: ACID properties ensure reliable database transactions: Atomicity (all operations in a transaction succeed
or all are rolled back), Consistency (a transaction brings the database from one valid state to another), Isolation
(concurrent transactions execute as if sequential), Durability (committed transactions persist even after system
failure). These properties are fundamental to relational database reliability.
Q10. Which SQL aggregate function returns the number of rows that match a specified
condition?
A. SUM()
B. AVG()
C. COUNT() ✓
D. MAX()
Correct Answer: C
Rationale: COUNT() returns the number of rows matching the query criteria. COUNT(*) counts all rows including
NULLs; COUNT(column) counts non-NULL values in that column. SUM() adds numeric values. AVG() returns the
arithmetic mean. MAX() returns the largest value. These aggregate functions are used with GROUP BY and are
fundamental D427 knowledge.
Q11. In SQL, what is the purpose of the ORDER BY clause?
A. To group rows with the same values together
B. To filter rows based on a condition
C. To sort the result set by one or more columns in ascending or descending order ✓
D. To join two tables together
Correct Answer: C
Rationale: ORDER BY sorts the query result set. Default sort is ASC (ascending); DESC sorts descending. Multiple
columns can be specified: ORDER BY last_name ASC, first_name DESC. ORDER BY is processed last in SQL's
logical execution order. GROUP BY groups rows for aggregation. WHERE filters rows. JOIN combines tables.
Q12. Which SQL keyword is used to combine rows from two or more tables based on a related
column?
A. MERGE
B. COMBINE
C. JOIN ✓
D. LINK
Correct Answer: C
Rationale: JOIN combines rows from two or more tables based on a related column condition. Types include INNER
JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN. MERGE is a DML command that performs
INSERT/UPDATE/DELETE in one statement (not about combining table data for reading). COMBINE and LINK are
not standard SQL keywords.
Q13. What is the difference between CHAR(n) and VARCHAR(n) data types in SQL?
A. CHAR stores numbers; VARCHAR stores text
B. CHAR is fixed-length (always uses n bytes); VARCHAR is variable-length (uses
only as many bytes as the actual string plus overhead) ✓
C. CHAR is for single characters only; VARCHAR is for multiple characters
D. There is no difference — they are interchangeable
Correct Answer: B
Exam Questions With 100% Correct Answers
Verified | Latest Update 2026/2027
80 Questions | 6 Sections | SQL Fundamentals • DDL • DML • DQL • Normalization • Advanced SQL
Section 1: SQL Fundamentals (Questions 1–15)
Q1. Which SQL statement is used to retrieve data from a database?
A. INSERT
B. UPDATE
C. SELECT ✓
D. DELETE
Correct Answer: C
Rationale: SELECT is the Data Query Language (DQL) command used to retrieve data from one or more tables.
INSERT adds new rows, UPDATE modifies existing rows, and DELETE removes rows. SELECT is part of DQL while
INSERT, UPDATE, and DELETE are DML (Data Manipulation Language) commands.
Q2. Which of the following correctly identifies the four main SQL sublanguages?
A. DDL, DML, DQL, DCL ✓
B. SELECT, INSERT, UPDATE, DELETE
C. CREATE, READ, UPDATE, DELETE
D. SQL, NoSQL, PL/SQL, T-SQL
Correct Answer: A
Rationale: SQL is divided into DDL (Data Definition Language — CREATE, ALTER, DROP), DML (Data
Manipulation Language — INSERT, UPDATE, DELETE), DQL (Data Query Language — SELECT), and DCL (Data
Control Language — GRANT, REVOKE). Option B lists DML/DQL commands only. Option C describes CRUD
operations. Option D describes SQL variants.
Q3. In a relational database, a 'primary key' serves which purpose?
A. It stores the most important data value in a row
B. It uniquely identifies each row in a table and cannot be NULL ✓
C. It links one table to another table
D. It defines the default sort order of the table
Correct Answer: B
Rationale: A primary key uniquely identifies each row (record) in a table. It must be unique across all rows and
cannot contain NULL values. Option C describes a foreign key's role (which references the primary key in another
table). Option A and D are not correct definitions — primary keys are about unique row identification, not data
importance or sort order.
Q4. Which SQL keyword is used to prevent duplicate rows in a SELECT query result?
A. UNIQUE
B. DISTINCT ✓
, C. FILTER
D. GROUP
Correct Answer: B
Rationale: DISTINCT eliminates duplicate rows from SELECT results: SELECT DISTINCT column FROM table.
UNIQUE is a constraint used in table definitions to enforce uniqueness in a column, not a SELECT filter keyword.
FILTER is used with aggregate window functions in some dialects. GROUP (BY) groups rows for aggregation but
does not directly eliminate duplicates.
Q5. What is a 'NULL' value in SQL?
A. A value of zero (0) stored in a numeric column
B. An empty string stored in a text column
C. The absence of any value — unknown or missing data ✓
D. A reserved keyword meaning 'false' in a Boolean column
Correct Answer: C
Rationale: NULL represents the absence of a value — not zero, not an empty string, but truly missing or unknown
data. NULL requires special handling: comparisons use IS NULL / IS NOT NULL rather than = NULL. Arithmetic with
NULL produces NULL. NULL != 0 and NULL != '' (empty string). This distinction is critical for writing correct WHERE
clause filters.
Q6. Which clause in a SELECT statement filters rows AFTER grouping has been performed?
A. WHERE
B. HAVING ✓
C. GROUP BY
D. ORDER BY
Correct Answer: B
Rationale: HAVING filters groups created by GROUP BY, allowing conditions on aggregate functions (e.g., HAVING
COUNT(*) > 5). WHERE filters individual rows BEFORE grouping occurs and cannot reference aggregate functions.
GROUP BY creates the groups. ORDER BY sorts the final result set. The logical execution order is: WHERE →
GROUP BY → HAVING → SELECT → ORDER BY.
Q7. A 'foreign key' in a relational table is best described as:
A. Any column that is indexed for faster retrieval
B. A column (or set of columns) that references the primary key of another table, enforcing referential
integrity ✓
C. The second column defined in a CREATE TABLE statement
D. A column containing encrypted data values
Correct Answer: B
Rationale: A foreign key establishes a referential integrity constraint between two tables: the values in the foreign
key column must match existing primary key values in the referenced table (or be NULL if allowed). This prevents
orphaned records. Foreign keys do not have to be indexed (though indexing them improves JOIN performance). They
are defined by their referencing relationship, not their position in the CREATE TABLE statement.
Q8. Which of the following is the correct SQL comment syntax for a single-line comment?
A. /* This is a comment */
B. // This is a comment
C. -- This is a comment ✓
D. # This is a comment (standard SQL)
Correct Answer: C
Rationale: Standard SQL uses -- (double dash) for single-line comments. /* ... */ is the standard multi-line (block)
comment syntax (Option A is also valid but is multi-line). // is used in languages like Java and C++, not standard SQL.
# is used in MySQL as a non-standard single-line comment but is not ANSI SQL standard. For WGU D427, -- is the
correct single-line comment syntax.
, Q9. What does 'ACID' stand for in the context of database transactions?
A. Automated, Consistent, Isolated, Durable
B. Atomicity, Consistency, Isolation, Durability ✓
C. Atomic, Committed, Integrated, Distributed
D. Atomicity, Consistency, Indexed, Data-secure
Correct Answer: B
Rationale: ACID properties ensure reliable database transactions: Atomicity (all operations in a transaction succeed
or all are rolled back), Consistency (a transaction brings the database from one valid state to another), Isolation
(concurrent transactions execute as if sequential), Durability (committed transactions persist even after system
failure). These properties are fundamental to relational database reliability.
Q10. Which SQL aggregate function returns the number of rows that match a specified
condition?
A. SUM()
B. AVG()
C. COUNT() ✓
D. MAX()
Correct Answer: C
Rationale: COUNT() returns the number of rows matching the query criteria. COUNT(*) counts all rows including
NULLs; COUNT(column) counts non-NULL values in that column. SUM() adds numeric values. AVG() returns the
arithmetic mean. MAX() returns the largest value. These aggregate functions are used with GROUP BY and are
fundamental D427 knowledge.
Q11. In SQL, what is the purpose of the ORDER BY clause?
A. To group rows with the same values together
B. To filter rows based on a condition
C. To sort the result set by one or more columns in ascending or descending order ✓
D. To join two tables together
Correct Answer: C
Rationale: ORDER BY sorts the query result set. Default sort is ASC (ascending); DESC sorts descending. Multiple
columns can be specified: ORDER BY last_name ASC, first_name DESC. ORDER BY is processed last in SQL's
logical execution order. GROUP BY groups rows for aggregation. WHERE filters rows. JOIN combines tables.
Q12. Which SQL keyword is used to combine rows from two or more tables based on a related
column?
A. MERGE
B. COMBINE
C. JOIN ✓
D. LINK
Correct Answer: C
Rationale: JOIN combines rows from two or more tables based on a related column condition. Types include INNER
JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN. MERGE is a DML command that performs
INSERT/UPDATE/DELETE in one statement (not about combining table data for reading). COMBINE and LINK are
not standard SQL keywords.
Q13. What is the difference between CHAR(n) and VARCHAR(n) data types in SQL?
A. CHAR stores numbers; VARCHAR stores text
B. CHAR is fixed-length (always uses n bytes); VARCHAR is variable-length (uses
only as many bytes as the actual string plus overhead) ✓
C. CHAR is for single characters only; VARCHAR is for multiple characters
D. There is no difference — they are interchangeable
Correct Answer: B
