SQL Functions

Question 1

​The DISTINCT keyword can be used to indicate that duplicate data should be suppressed in the results of a query.

Accepted Answer

True

Question 2

Which of the following statements will produce the value 21.1?

Accepted Answer

SELECT ROUND(21.12, 1) FROM dual;

Question 3

Single-row functions return one row of results for each group or category of rows processed.​

Accepted Answer

False

Question 4

When a function is used in a SELECT statement, it only affects how the data are displayed in the results.​

Accepted Answer

True

Question 5

A column alias must be contained within double quotation marks (' ') if it contains which of the following?

Accepted Answer

All of the above

Question 6

Which of the following is an aggregate function in SQL?

Accepted Answer

SUM

Question 7

What is the purpose of the GROUP BY clause in SQL?

Accepted Answer

To group rows based on the values in one or more columns

Question 8

The LENGTH function is used to determine the number of rows in a table.​

Accepted Answer

False

Question 9

Which of the following is a single-row function in SQL?

Accepted Answer

CONCAT

Questions 9