d427 Data Management Applications - Set 4 - Part 1

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

Question 1: Which SQL clause is used to filter records returned by a SELECT statement after the records are grouped?

GROUP BY

WHERE

HAVING

ORDER BY

Question 2: What SQL function would you use to calculate the average of a column of numbers?

SUM()

AVERAGE()

AVG()

MEAN()

Question 3: Which SQL operator is used to return rows that match a pattern?

MATCH

EQUALS

Question 4: How do you update the value of a specific row in SQL?

MODIFY TABLE

UPDATE

SET COLUMN

ALTER ROW

Question 5: Which SQL function returns the largest value in a numeric column?

MAX()

LARGEST()

GREATER()

BIG()

Question 6: How do you select rows that have a NULL value in a specific column?

WHERE column IS NULL

WHERE column == NULL

WHERE column = NULL

WHERE column IS EMPTY

Question 7: What SQL statement would you use to create a new table?

INSERT INTO

CREATE TABLE

NEW TABLE

ADD TABLE

Question 8: Which SQL operator is used to combine multiple conditions in a WHERE clause where both conditions must be true?

AND

NOT

Question 9: Which SQL function would you use to count the number of non-NULL values in a column?

COUNT()

TOTAL()

LENGTH()

SUM()

Question 10: What does the SQL function LOWER() do?

Converts a string to uppercase

Converts a string to lowercase

Returns the smallest numeric value

Removes lowercase letters from a string

Question 11: Which SQL keyword is used to eliminate duplicate rows in a result set?

DISTINCT

REMOVE DUPLICATES

UNIQUE

DELETE

Question 12: How do you retrieve all columns from a table in SQL?

SELECT ALL

SELECT *

SELECT COLUMNS

SELECT FROM TABLE

Question 13: What is the purpose of the SQL GROUP BY clause?

To filter records by a condition

To group rows that have the same values into summary rows

To combine the results of two queries

To sort the result set

Question 14: What does the SQL keyword ASC stand for?

Ascending

Assumed

Ascertain

Asynchronous

Question 15: Which SQL keyword is used to remove all rows from a table but retain the table's structure?

DELETE

TRUNCATE

REMOVE

CLEAR

Question 16: How do you retrieve only the first 5 rows from a query result in SQL?

LIMIT 5

TOP 5

MAX 5

RESTRICT 5

Question 17: Which SQL clause is used to filter records before they are grouped?

WHERE

HAVING

FILTER

GROUP BY

Question 18: What is the purpose of the SQL COUNT() function?

To calculate the sum of a column

To return the number of rows in a result set

To count the distinct values in a column

To return the number of columns in a table

Question 19: How do you retrieve rows where a column value falls within a range of two values in SQL?

WHERE column BETWEEN value1 AND value2

WHERE column >= value1 AND <= value2

WHERE column IN (value1, value2)

WHERE column > value1 AND < value2

Question 20: Which SQL statement is used to delete a specific row from a table?

DELETE

REMOVE

DROP

CLEAR

Need Guaranteed Results?

Our exam support service guarantees you'll pass your OA on the first attempt. Pay only after you pass!

Get Exam Support