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?
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?
