D427 Data Management Applications - Set 3 - Part 2

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

Question 21: What is the purpose of the SQL HAVING clause?

To filter rows before grouping

To filter rows after grouping

To specify conditions for JOINs

To limit the number of rows returned

Question 22: Which SQL clause is used to limit the number of rows returned by a query?

TOP

LIMIT

WHERE

GROUP BY

Question 23: How do you delete a specific row in SQL where the column "ID" is 10?

REMOVE FROM table WHERE ID = 10

DELETE FROM table WHERE ID = 10

TRUNCATE table WHERE ID = 10

ERASE FROM table WHERE ID = 10

Question 24: Which SQL statement is used to change the structure of an existing table?

UPDATE TABLE

ALTER TABLE

MODIFY TABLE

RENAME TABLE

Question 25: What does the SQL statement CREATE TABLE do?

It creates a new table

It updates an existing table

It deletes a table

It renames a table

Question 26: Which SQL keyword is used to filter rows before applying the GROUP BY clause?

FILTER

WHERE

HAVING

ORDER BY

Question 27: What SQL operator is used to test if a value is in a specific list of values?

EXISTS

ANY

Question 28: How do you retrieve rows where a column value matches a pattern in SQL?

WHERE column LIKE pattern

WHERE column = pattern

WHERE column IN pattern

WHERE column MATCHES pattern

Question 29: Which SQL function is used to find the minimum value in a column?

MIN()

LEAST()

SMALLEST()

LOWER()

Question 30: What does the SQL function ROUND() do?

Converts numbers to integers

Rounds a number to the nearest integer

Rounds a number to the specified number of decimal places

Converts a string to a number

Question 31: What does the SQL IS NOT NULL condition do?

Selects rows where the column is NULL

Selects rows where the column is not NULL

Converts NULL values to 0

Converts NULL values to an empty string

Question 32: Which SQL function is used to replace NULL values with a specified value?

IFNULL()

COALESCE()

NVL()

ISNULL()

Question 33: How do you concatenate two strings in SQL?

CONCAT()

MERGE()

JOIN()

UNION()

Question 34: What does the SQL clause EXISTS do?

It checks if a subquery returns any rows

It checks if a column contains any NULL values

It filters rows based on conditions

It sorts the rows in ascending order

Question 35: Which SQL operator is used to compare two expressions and return TRUE if they are not equal?

NOT EQUAL

EQUALS

Question 36: What does the SQL clause ORDER BY do?

It sorts the result set

It filters rows based on conditions

It limits the number of rows returned

It merges the results of two queries

Question 37: Which SQL clause is used to group rows that have the same values?

GROUP BY

ORDER BY

HAVING

CLUSTER BY

Question 38: How do you retrieve all rows where a column value is between two values in SQL?

WHERE column BETWEEN value1 AND value2

WHERE column IN value1 TO value2

WHERE column >= value1 AND <= value2

WHERE column > value1 AND < value2

Question 39: What SQL function is used to count the number of rows returned by a query?

COUNT()

SUM()

TOTAL()

ROWS()

Question 40: How do you remove a column from an existing table in SQL?

DELETE COLUMN

ALTER TABLE DROP COLUMN

REMOVE COLUMN

ERASE COLUMN

Don't Want to Study?

Save Time on Studies, Spend More with Family & Friends! Pay-After-you-Pass!

Get Exam Support