Free ADC Data Retrieval & Query Techniques Questions and Answers

Question 1

What is the primary function of a SELECT statement in SQL?

Accepted Answer

Retrieve data from one or more tables.

Answer

Modify existing data.

Answer

Delete records.

Answer

Create new tables.

Question 2

Which clause is used to filter records in a SQL query?

Accepted Answer

WHERE

Answer

FROM

Answer

GROUP BY

Answer

ORDER BY

Question 3

What does the JOIN operation accomplish in SQL?

Accepted Answer

Combines data from multiple tables based on a common field.

Answer

Removes duplicated data.

Answer

Backs up the database.

Answer

Creates a new table.

Question 4

How can you sort data in ascending or descending order in SQL?

Accepted Answer

ORDER BY

Answer

GROUP BY

Answer

SORT

Answer

FILTER

Question 5

What is the result of using the DISTINCT keyword in a query?

Accepted Answer

Removes duplicate rows.

Answer

Sorts results alphabetically.

Answer

Removes NULL values.

Answer

Creates table indexes.

Question 6

Which SQL function returns the number of records in a result set?

Accepted Answer

COUNT()

Answer

SUM()

Answer

TOTAL()

Answer

ADD()

Question 7

Which keyword is used to rename a column or table in the result set?

Accepted Answer

AS

Answer

ALIAS

Answer

RENAME

Answer

MODIFY

Question 8

How do you retrieve records that satisfy at least one of multiple conditions?

Accepted Answer

OR

Answer

AND

Answer

BETWEEN

Answer

NOT

Question 9

What does the LIKE operator do in a SQL query?

Accepted Answer

Searches for a pattern in text.

Answer

Compares numeric ranges.

Answer

Limits results to the first 10 rows.

Answer

Updates column values.