Skip to content
Pass Any WGU OA Exam Now & Pay After You Pass. Contact Us!
  1. Home
  2. WGU Exams
  3. WGU D492
  4. Set 4
WGU D492 · Data Analytics Applications

WGU D492 Practice Questions – Set 4

50 multiple-choice questions with answers and detailed explanations. Untimed — choose an answer to check it instantly.

Question 1 of 50

Which SQL keyword is used to return only unique values from a column?

Question 2 of 50

In relational databases, what does the term "referential integrity" mean?

Question 3 of 50

Which SQL clause is used to sort the rows in ascending order?

Question 4 of 50

In SQL, which function is used to return the lowest value from a column?

Question 5 of 50

What is a heap table in relational databases?

Question 6 of 50

In SQL, what is the role of the MOD() function?

Question 7 of 50

In SQL, which operator is used to select rows that do not match a pattern?

Question 8 of 50

In SQL, which clause is used to limit the number of rows returned by a query?

Question 9 of 50

What is the primary purpose of the INNER JOIN in SQL?

Question 10 of 50

In SQL, which function is used to calculate the total of values in a column?

Question 11 of 50

What is a non-clustered index in a relational database?

Question 12 of 50

In SQL, what does the JOIN clause do?

Question 13 of 50

In SQL, what does the UNION operator do?

Question 14 of 50

What is the purpose of the HAVING clause in SQL?

Question 15 of 50

Which SQL function is used to return the square root of a number?

Question 16 of 50

What is a full outer join in SQL?

Question 17 of 50

In SQL, what is the purpose of the INSERT statement?

Question 18 of 50

What is the role of the FOREIGN KEY in a relational database?

Question 19 of 50

In SQL, which function is used to extract a portion of a string?

Question 20 of 50

In SQL, which command is used to delete a table from a database?

Question 21 of 50

Which SQL function returns the number of rows that match a specified condition?

Question 22 of 50

What is a hash table in a relational database?

Question 23 of 50

In SQL, which clause is used to remove duplicate rows from the result set?

Question 24 of 50

What is a sorted table in a relational database?

Question 25 of 50

In SQL, which clause is used to specify the condition for selecting rows?

Question 26 of 50

Which SQL function returns the absolute value of a number?

Question 27 of 50

What is the role of the GROUP BY clause in SQL?

Question 28 of 50

In SQL, which keyword is used to rename a column in the result set?

Question 29 of 50

In SQL, which function is used to join two or more strings?

Question 30 of 50

What is the purpose of the ROLLBACK command in SQL?

Question 31 of 50

What is the default order of sorting when using the ORDER BY clause in SQL?

Question 32 of 50

In SQL, what type of join returns only the rows that match in both tables?

Question 33 of 50

In SQL, which function is used to calculate the natural logarithm of a number?

Question 34 of 50

In SQL, which function is used to remove leading and trailing spaces from a string?

Question 35 of 50

Which SQL operator is used to check if a value is within a list of values?

Question 36 of 50

In SQL, which keyword is used to combine two queries and include all duplicate rows?

Question 37 of 50

What is the function of the COUNT() aggregate function in SQL?

Question 38 of 50

In SQL, what does the EXISTS operator do?

Question 39 of 50

In SQL, which keyword is used to combine the result sets of two queries and remove duplicates?

Question 40 of 50

In SQL, what does the HAVING clause do?

Question 41 of 50

Which SQL operator is used to select rows that match a specific pattern?

Question 42 of 50

In SQL, which function is used to return the current date?

Question 43 of 50

Which SQL statement is used to modify the structure of an existing table?

Question 44 of 50

What does the DISTINCT keyword do in SQL?

Question 45 of 50

In SQL, which function is used to calculate the average of values in a column?

Question 46 of 50

Which SQL statement is used to add a new column to an existing table?

Question 47 of 50

In SQL, which clause is used to filter groups of rows after they have been aggregated?

Question 48 of 50

In SQL, what is a subquery?

Question 49 of 50

In SQL, which function is used to return the year from a date?

Question 50 of 50

In SQL, what does the LEFT JOIN return?

Set 4 complete

You scored 0%

0 correct out of 0 answered (50 questions in this set).

Next: Set 5

Struggling with WGU D492?

If this exam is giving you a hard time, let us be your helping hand. Contact us, and we'll provide the assistance you need to pass and move forward.

Chat Now