D 427 / D427 Pre - Assessment V2 (Latest Update 2025 / 2026) Data Management – Applications | Questions and Answers | Grade A | 100% Correct (Verified Answers). WGU

1
D427




D 427 / D427 Pre - Assessment V2 (Latest
Update ) Data Management –
Applications | Questions and Answers | Grade
A | 100% Correct (Verified Answers). WGU



1. Which SQL clause is used to combine rows from two or more tables,

based on a related column between them?


A. SELECT

B. JOIN

C. WHERE

D. GROUP BY: B. JOIN

2. Which of the following statements about aggregate functions and

NULL values is true?


A. Aggregate functions consider NULL values as zero

B. Aggregate functions ignore NULL values

C. Aggregate functions return NULL if any value is NULL




,D. Aggregate functions cannot be used on columns with NULL values: B.

Aggregate functions ignore NULL values

3.) Which of the following is NOT an advantage of using views?


A. Protecting sensitive data by hiding certain

columns B. Saving complex queries for reuse

C. Improving performance by always storing view data

D. Saving optimized queries for consistent performance: C. Improving

performance by always storing view data

4.) Which of the following is a valid use of the GROUP BY clause?


A. To filter rows based on an aggregate function

B. To sort the result set

C. To group rows that have the same values in specified columns

D. To limit the number of returned rows: C. To group rows that have the

same values in specified columns

5.) The BETWEEN operator is equivalent to which of the following

expressions?






, 3
D427


A. value > minValue AND value < maxValue

B. value >= minValue AND value <= maxValue

C. value >= minValue OR value <= maxValue

D. value BETWEEN minValue OR maxValue: B. value >= minValue AND

value <= maxValue

6.) Which clause in SQL is used to sort the result-set in ascending or

descending order?


A. GROUP BY

B. ORDER BY

C. HAVING

D. WHERE: B. ORDER BY

7.) What is the correct order of clauses in an SQL SELECT statement?


A. SELECT, WHERE, GROUP BY, HAVING,

ORDER BY B. SELECT, GROUP BY, WHERE,

HAVING, ORDER BY

C. SELECT, WHERE, HAVING, GROUP BY, ORDER BY






, D. SELECT, HAVING, WHERE, GROUP BY, ORDER BY: A. SELECT,

WHERE,

GROUP BY, HAVING, ORDER BY

8.) In the expression `Name BETWEEN 'Anele' AND 'Jose'`, which data

type must the Name column have for this expression to be valid?


A. INT

B. DATE

C. VARCHAR

D. BOOLEAN: C. VARCHAR

9.) In SQL, which clause is evaluated first in a SELECT statement with

GROUP BY and HAVING clauses?


A. SELECT

B. GROUP BY

C. WHERE

D. FROM: D. FROM

10.) How can you match the literal character '%' in a LIKE pattern?