D427 Data Management Applications - Set 5 - Part 3

Test your knowledge of technical writing concepts with these practice questions. Each question includes detailed explanations to help you understand the correct answers.

Question 41: Which SQL clause is used to group rows that have the same values in specified columns?

GROUP BY

ORDER BY

FILTER BY

HAVING

Question 42: How do you modify the value of an existing column in SQL?

ALTER COLUMN

UPDATE

MODIFY

CHANGE

Question 43: Which SQL keyword is used to combine rows from two queries into one result set and includes duplicates?

UNION ALL

UNION

JOIN

MERGE

Question 44: How do you select rows where a column value does not match a specified pattern in SQL?

WHERE column NOT LIKE pattern

WHERE column != pattern

WHERE column EXCLUDES pattern

WHERE column NOT EQUALS pattern

Question 45: Which SQL function is used to round a number to a specified number of decimal places?

ROUND()

FLOOR()

CEILING()

TRUNC()

Question 46: What is the purpose of the SQL NVL() function?

It replaces NULL values with a specified value

It checks if a column contains NULL values

It converts a string to a number

It returns the largest value in a column

Question 47: Which SQL clause is used to join two or more tables based on a related column?

JOIN

UNION

MERGE

COMBINE

Question 48: Which SQL keyword is used to specify a condition that must be met for a row to be included in the result set?

WHERE

SELECT

FILTER

ORDER BY

Question 49: What SQL function would you use to return the length of a string?

LENGTH()

LEN()

SIZE()

COUNT()

Question 50: What does the SQL HAVING clause do?

It filters groups after they have been formed

It filters rows before they are grouped

It sorts the result set

It combines the results of two queries

Congratulations! You have completed all 5 question sets. Good job!

Go Back to Home

Struggling With Exams?

Less Time Studying, More Time Living – Finish Your Degree Faster! Pay-After-you-Pass!

Get Exam Support