MS SQL Server - 14 - TSQL Functions MCQ

14 – TSQL Functions MCQ

Best of luck!

1 / 25

1. What is the primary purpose of SQL Server’s aggregate functions?

To perform calculations on text data

To perform calculations on all rows in a table

To perform calculations on individual rows

To perform calculations on grouped rows and return a single result

2 / 25

2. Which SQL Server aggregate function calculates the average value of a numeric column?

AVG

SUM

COUNT

MAX

3 / 25

3. What is the result of applying the COUNT function to a column in SQL Server?

The average value of the column

The sum of all values in the column

The highest value in the column

The total number of rows in the column

4 / 25

4. Which SQL Server aggregate function returns the sum of all values in a numeric column?

AVG

MIN

COUNT

SUM

5 / 25

5. What is the purpose of the MAX function in SQL Server?

To return the sum of all values in a column

To return the highest value in a column

To return the average value of a column

To return the lowest value in a column

6 / 25

6. Which SQL Server aggregate function calculates the total number of rows in a result set or a specific column?

COUNT

AVG

SUM

MAX

7 / 25

7. In SQL Server, what does the SUM function return when applied to a column containing NULL values?

NULL

The average of non-NULL values

An error is raised

Zero

8 / 25

8. What is the primary purpose of SQL Server’s scalar functions?

To perform calculations on all rows in a table

To perform calculations on text data

To perform calculations on individual rows

To perform calculations on grouped rows

9 / 25

9. Which SQL Server scalar function is used to convert a value from one data type to another?

AVG

SUM

MAX

CAST

10 / 25

10. In SQL Server, which scalar function can be used to extract a portion of a string?

CONCAT

FORMAT

SUBSTRING

TRIM

11 / 25

11. What is the primary purpose of the CONCAT function in SQL Server?

To concatenate two or more strings

To find the maximum value in a column

To add two numeric values

To calculate the average of numeric values

12 / 25

12. Which SQL Server scalar function is used to remove leading and trailing spaces from a string?

CONCAT

SUBSTRING

TRIM

FORMAT

13 / 25

13. In SQL Server, which scalar function is used to format date and time values?

TRIM

FORMAT

SUBSTRING

CONCAT

14 / 25

14. Which SQL Server scalar function can be used to round a numeric value to the nearest integer?

CAST

ROUND

TRUNCATE

CONCAT

15 / 25

15. What does the ROUND function in SQL Server do when rounding a value to a specified number of decimal places?

It always rounds down to the nearest value.

It rounds to the nearest value with ties rounding away from zero.

It always rounds up to the nearest value.

It rounds to the nearest value with ties rounding to the nearest even number.

16 / 25

16. Which SQL Server scalar function can be used to find the length of a string?

SIZE

LENGTH

LEN

COUNT

17 / 25

17. In SQL Server, which scalar function can be used to convert a string to lowercase?

INITCAP

UPPER

LOWER

CONCAT

18 / 25

18. What is the purpose of the UPPER function in SQL Server?

To find the maximum value in a column

To convert a string to uppercase

To convert a string to lowercase

To calculate the average of numeric values

19 / 25

19. Which SQL Server scalar function is used to extract the year from a date or datetime value?

DAY

YEAR

DATEPART

MONTH

20 / 25

20. In SQL Server, which scalar function can be used to extract the month from a date or datetime value?

MONTH

DAY

YEAR

DATEPART

21 / 25

21. What is the primary purpose of the DATEPART function in SQL Server?

To convert a string to uppercase

To calculate the average of numeric values

To find the maximum value in a column

To extract parts of a date or datetime value, such as year, month, or day

22 / 25

22. Which SQL Server scalar function is used to add or subtract a specified number of days from a date?

DATEADD

DATEPART

DATEDIFF

DATEFORMAT

23 / 25

23. What does the DATEDIFF function in SQL Server do?

It calculates the difference between two dates in days.

It calculates the difference between two dates in minutes.

It calculates the difference between two dates in months.

It calculates the difference between two dates in years.

24 / 25

24. In SQL Server, which scalar function can be used to get the current date and time?

GETDATE

CURRENT_TIMESTAMP

DATEADD

NOW

25 / 25

25. Which SQL Server scalar function is used to generate a globally unique identifier (GUID)?

GENERATEID

GUID

NEWID

UNIQUEID

Your score is

0%

MS SQL Server – 14 – TSQL Functions MCQ