d427 Data Management Applications - Set 5 - 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 operator is used to compare two values for inequality?

Question 2: What does the SQL MIN() function do?

Returns the minimum value in a column

Returns the maximum value in a column

Returns the average value in a column

Returns the number of rows in a column

Question 3: Which SQL keyword is used to specify a condition that is applied to individual rows before they are grouped?

WHERE

HAVING

GROUP BY

SELECT

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

TOP

LIMIT

SELECT

RESTRICT

Question 5: How do you remove duplicate rows from a result set in SQL?

DELETE DUPLICATES

REMOVE DUPLICATES

DISTINCT

UNIQUE

Question 6: What SQL statement would you use to remove a table from a database?

DELETE

DROP TABLE

TRUNCATE TABLE

REMOVE TABLE

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

MIN()

MAX()

GREATEST()

SUM()

Question 8: How do you select rows where a column value is NULL in SQL?

WHERE column == NULL

WHERE column = NULL

WHERE column IS NULL

WHERE column != NULL

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

ALTER TABLE

UPDATE TABLE

MODIFY TABLE

RENAME TABLE

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

Returns the number of rows in a result set

Returns the total sum of a numeric column

Returns the minimum value in a column

Returns the number of distinct values in a column

Question 11: What SQL function would you use to convert a string to uppercase?

LOWER()

UPPER()

CAPITALIZE()

UCASE()

Question 12: How do you return all rows from a table in SQL?

SELECT ALL

SELECT *

SELECT FROM

SELECT COLUMNS

Question 13: Which SQL keyword is used to combine the results of two or more queries into a single result set?

JOIN

UNION

MERGE

COMBINE

Question 14: Which SQL clause is used to sort the result set?

ORDER BY

GROUP BY

SORT BY

FILTER BY

Question 15: How do you select only the first 10 rows from a table in SQL?

LIMIT 10

TOP 10

SELECT FIRST 10

SELECT 10

Question 16: Which SQL function would you use to return the current system date and time?

NOW()

CURRENT_DATE()

CURRENT_TIMESTAMP()

GETDATE()

Question 17: What does the SQL HAVING clause do?

It filters rows based on a specified condition

It filters groups after they are formed

It sorts the result set

It limits the number of rows returned

Question 18: Which SQL operator is used to match a value with any value in a list of values?

BETWEEN

ANY

Question 19: Which SQL keyword is used to create a new database?

CREATE DATABASE

NEW DATABASE

ADD DATABASE

CREATE DB

Question 20: How do you retrieve only unique values from a column in SQL?

DISTINCT

UNIQUE

REMOVE DUPLICATES

LIMIT

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