Mathematical Functions in SQL Quiz

What does the POW() function do in SQL?

• Returns the square root of a number

• Rounds a number to a specified number of decimal places

• Returns the value of a number raised to the power of another number

• Returns the absolute value of a number

What is the default behavior of the ROUND() function when no decimal places are specified?

• Returns the original number

• Rounds to the nearest whole number

• Rounds down to the nearest integer

• Rounds to the nearest hundred

What does the TRUNCATE() function do?

• Rounds a number to the nearest integer

• Cuts off decimal places from a number

• Returns the remainder of a division

• Calculates the square root of a number

What is the result of the SQL command SELECT MOD(11, 3)?

• 0

• 3

• 2

• 1

What does the ABS() function return?

• The square of a number

• The absolute (positive) value of a number

• The cube of a number

• The logarithm of a number

What is the result of the SQL command SELECT ROUND(5.678, 2)?

• 5.67

• 5.68

• 6

• 5.6