Mathematical SQL Functions

What does the ROUND function do in SQL?

• Rounds a numeric value

• Multiplies two numeric values

• Returns the square root of a number

• Converts a string to uppercase

How is the TRUNCATE function different from the ROUND function?

• The TRUNCATE function is used for text manipulation, while the ROUND function is used for mathematical calculations.

• The TRUNCATE function rounds a number to a specified number of decimal places, while the ROUND function removes all decimal places from a number.

• The TRUNCATE function removes all decimal places from a number, while the ROUND function rounds a number to a specified number of decimal places.

• The TRUNCATE function always rounds up a number, while the ROUND function always rounds down.

In SQL, what does the MOD function return?

• Sum of two numbers

• Result of multiplication

• Remainder of a division operation

• Average of a set of values

Calculate the square root of 64 using SQL.

• 12

• 10

• 6

• 8

What does the POW function do in SQL?

• The POW function in SQL converts a number to a string.

• The POW function in SQL calculates the square root of a number.

• The POW function in SQL multiplies two numbers together.

• The POW function in SQL raises a number to the power of another number.

Find the absolute value of -5 using SQL.

• -10

• 5

• 0

• -5

When using the ROUND function, what does the second parameter represent?

• Number of hundreds

• Number of decimal places

• Number of significant figures

• Number of thousands

Explain how the TRUNCATE function handles decimal values.

• The TRUNCATE function converts decimal values to strings

• The TRUNCATE function rounds up decimal values

• The TRUNCATE function multiplies decimal values

• The TRUNCATE function handles decimal values by discarding the decimal part of the number.

If you apply the MOD function to 10 and 3, what will be the result?

• 4

• 2

• 1

• 5

Compute the square root of 100 using SQL.

• 15

• 5

• 12

• 10