D426 Data Management Foundations - Set 2 - 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 function returns the total number of rows in a result set?

COUNT

SUM

AVG

MAX

Question 42: Which type of join in SQL combines all rows from two tables, regardless of matching values?

FULL JOIN

CROSS JOIN

INNER JOIN

LEFT JOIN

Question 43: Which SQL keyword is used to filter the results of a query based on a condition?

WHERE

HAVING

LIMIT

ORDER BY

Question 44: Which SQL command is used to remove all rows from a table but keep its structure intact?

DELETE

TRUNCATE

DROP TABLE

REMOVE TABLE

Question 45: Which SQL function is used to return the length of a string?

LENGTH

CONCAT

TRIM

SUBSTRING

Question 46: Which SQL operator is used to return values that do not match a specified pattern?

NOT LIKE

NOT IN

EXISTS

Question 47: Which SQL keyword is used to remove duplicate rows from the result set of a query?

DISTINCT

GROUP BY

ORDER BY

HAVING

Question 48: Which SQL function is used to extract a substring from a string?

SUBSTRING

CONCAT

LENGTH

TRIM

Question 49: In SQL, which keyword is used to change the values in a table based on a condition?

UPDATE

DELETE

INSERT

SELECT

Question 50: Which SQL function returns the current date without the time portion?

CURDATE

NOW

GETDATE

DATE

Struggling With Exams?

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

Get Exam Support