Test Your Microsoft SQL Server NUMERIC Functions Knowledge with This Quiz

Progress

True / False

The CEILING function always rounds a number up to the nearest integer.

True False

The CEILING function rounds a number up to the nearest integer, regardless of whether the number is positive or negative.

True / False

The FLOOR function rounds a number down to the nearest integer.

True False

The FLOOR function rounds a number down to the nearest integer, regardless of whether the number is positive or negative.

True / False

The ROUND function can be used to round a number to a specified number of decimal places.

True False

The ROUND function can be used to round a number to a specified number of decimal places, or to the nearest integer if no decimal places are specified.

True / False

The POWER function is used to calculate the square root of a number.

True False

The POWER function is used to raise a number to a specified power. The SQRT function is used to calculate the square root of a number.

True / False

The LOG function can be used to calculate the natural logarithm of a number.

True False

The LOG function is used to calculate the logarithm of a number to a specified base, and the LN function is used to calculate the natural logarithm of a number.

True / False

The ABS function returns the absolute value of a number.

True False

The ABS function returns the absolute value of a number, which is the number without its sign.

True / False

The SIGN function returns the sign of a number.

True False

The SIGN function returns the sign of a number: 1 for positive numbers, -1 for negative numbers, and 0 for zero.

True / False

The PI function returns the value of pi (π).

True False

The PI function returns the value of pi (π), which is approximately 3.14159.

True / False

The SQRT function can be used to calculate the square root of a negative number.

True False

The SQRT function cannot be used to calculate the square root of a negative number because the result would be a complex number.

Q10

True / False

The COS function returns the cosine of a given angle in radians.

True False

The COS function returns the cosine of a given angle, which must be specified in radians.

Q11

True / False

The SIN function returns the sine of a given angle in degrees.

True False

The SIN function returns the sine of a given angle, which must be specified in radians, not degrees.

Q12

True / False

The TAN function returns the tangent of a given angle in radians.

True False

The TAN function returns the tangent of a given angle, which must be specified in radians.

Q13

True / False

The DEGREES function converts an angle from degrees to radians.

True False

The DEGREES function converts an angle from radians to degrees, not the other way around.

Q14

True / False

The RADIANS function converts an angle from degrees to radians.

True False

The RADIANS function converts an angle from degrees to radians.

Q15

True / False

The EXP function calculates the exponential value of a number.

True False

The EXP function returns the value of e raised to the power of a given number.

Q16

Single Choice

Which function rounds a number up to the nearest integer?

SQL Code

SELECT CEILING(123.456);
SELECT FLOOR(123.456);
SELECT ROUND(123.456, 0);
SELECT CEILING(-789.123);

CEILING() FLOOR() ROUND()TRUNCATE()

The CEILING function rounds a number up to the nearest integer, regardless of the sign of the number.

Q17

Single Choice

Which function rounds a number down to the nearest integer?

SQL Code

SELECT CEILING(123.456);
SELECT FLOOR(123.456);
SELECT ROUND(123.456, 0);
SELECT FLOOR(-789.123);

CEILING() FLOOR() ROUND()TRUNCATE()

The FLOOR function rounds a number down to the nearest integer, regardless of the sign of the number.

Q18

Single Choice

Which function can be used to calculate the natural logarithm of a number?

SQL Code

SELECT LOG(2.718);
SELECT LOG(10);
SELECT LN(2.718);
SELECT LOG(5, 2);

LOG() EXP() LN()SQRT()

The LN function is used to calculate the natural logarithm of a number, while the LOG function can calculate logarithms to any specified base.

Q19

Single Choice

Which function returns the absolute value of a number?

SQL Code

SELECT ABS(-123.456);
SELECT CEILING(-123.456);
SELECT FLOOR(-123.456);
SELECT SIGN(-123.456);

ABS() CEILING() FLOOR()SIGN()

The ABS function returns the absolute value of a number, removing any sign.

Q20

Single Choice

Which function returns the sign of a number?

SQL Code

SELECT ABS(-123.456);
SELECT CEILING(-123.456);
SELECT FLOOR(-123.456);
SELECT SIGN(-123.456);

ABS() CEILING() FLOOR()SIGN()

The SIGN function returns the sign of a number: 1 for positive numbers, -1 for negative numbers, and 0 for zero.

Q21

Single Choice

Which function returns the value of pi (π)?

SQL Code

SELECT PI();
SELECT EXP(1);
SELECT LOG(1);
SELECT SQRT(PI());

PI() EXP() LOG()SQRT()

The PI function returns the value of pi (π), which is approximately 3.14159.

Q22

Single Choice

Which function calculates the square root of a number?

SQL Code

SELECT SQRT(16);
SELECT EXP(2);
SELECT LOG(16);
SELECT PI();

SQRT() EXP() LOG()PI()

The SQRT function calculates the square root of a number.

Q23

Single Choice

Which function calculates the cosine of a given angle?

SQL Code

SELECT COS(PI());
SELECT SIN(PI());
SELECT TAN(PI());
SELECT DEGREES(PI());

COS() SIN() TAN()DEGREES()

The COS function returns the cosine of a given angle in radians.

Q24

Single Choice

Which function converts an angle from degrees to radians?

SQL Code

SELECT RADIANS(180);
SELECT DEGREES(PI());
SELECT SIN(90);
SELECT COS(180);

RADIANS() DEGREES() SIN()COS()

The RADIANS function converts an angle from degrees to radians.

Q25

Single Choice

Which function converts an angle from radians to degrees?

SQL Code

SELECT DEGREES(PI());
SELECT RADIANS(180);
SELECT SIN(PI());
SELECT COS(PI());

DEGREES() RADIANS() SIN()COS()

The DEGREES function converts an angle from radians to degrees.

Q26

Single Choice

Which function calculates the exponential value of a number?

SQL Code

SELECT EXP(1);
SELECT LOG(1);
SELECT PI();
SELECT SQRT(1);

EXP() LOG() PI()SQRT()

The EXP function returns the value of e raised to the power of a given number.

Q27

Single Choice

Which function returns the tangent of a given angle?

SQL Code

SELECT TAN(PI()/4);
SELECT SIN(PI()/4);
SELECT COS(PI()/4);
SELECT DEGREES(PI()/4);

TAN() SIN() COS()DEGREES()

The TAN function returns the tangent of a given angle in radians.

Q28

Single Choice

Which function returns the logarithm of a number to a specified base?

SQL Code

SELECT LOG(10);
SELECT EXP(1);
SELECT PI();
SELECT SQRT(10);

LOG() EXP() PI()SQRT()

The LOG function returns the logarithm of a number to a specified base.

Q29

Single Choice

Which function calculates the trigonometric sine of a given angle?

SQL Code

SELECT SIN(PI()/2);
SELECT COS(PI()/2);
SELECT TAN(PI()/2);
SELECT DEGREES(PI()/2);

SIN() COS() TAN()DEGREES()

The SIN function returns the sine of a given angle in radians.

Q30

Single Choice

Which function calculates the trigonometric cosine of a given angle?

SQL Code

SELECT COS(PI());
SELECT SIN(PI());
SELECT TAN(PI());
SELECT DEGREES(PI());

COS() SIN() TAN()DEGREES()

The COS function returns the cosine of a given angle in radians.

Q31

Multiple Choice

Which functions can be used to round numeric values? Select all that apply.

SQL Code

SELECT ROUND(123.456, 1);
SELECT CEILING(456.789);
SELECT FLOOR(789.123);
SELECT ROUND(987.654, 2);

ROUND() CEILING() FLOOR()TRUNCATE()

The ROUND, CEILING, and FLOOR functions can all be used to round numeric values, each with different rounding methods.

Q32

Multiple Choice

Which functions can be used to compute logarithmic values? Select all that apply.

SQL Code

SELECT LOG(10);
SELECT LN(10);
SELECT LOG(10, 2);
SELECT EXP(1);

LOG() LN() EXP()PI()

The LOG and LN functions can be used to compute logarithmic values, with LOG allowing for different bases.

Q33

Multiple Choice

Which functions return trigonometric values? Select all that apply.

SQL Code

SELECT SIN(PI()/2);
SELECT COS(PI()/2);
SELECT TAN(PI()/2);
SELECT RADIANS(45);

SIN() COS() TAN()DEGREES()

The SIN, COS, and TAN functions return trigonometric values based on angles specified in radians.

Q34

Multiple Choice

Which functions can be used to convert between radians and degrees? Select all that apply.

SQL Code

SELECT DEGREES(PI()/2);
SELECT RADIANS(90);
SELECT SIN(PI()/2);
SELECT COS(PI()/2);

DEGREES() RADIANS() SIN()COS()

The DEGREES and RADIANS functions are used to convert between radians and degrees.

Q35

Multiple Choice

Which functions return the absolute value of a number? Select all that apply.

SQL Code

SELECT ABS(-123);
SELECT CEILING(-123);
SELECT FLOOR(-123);
SELECT SIGN(-123);

ABS() CEILING() FLOOR()SIGN()

The ABS function returns the absolute value of a number. CEILING, FLOOR, and SIGN do not return absolute values.

Q36

Multiple Choice

Which functions are used to perform calculations involving powers? Select all that apply.

SQL Code

SELECT POWER(2, 3);
SELECT EXP(2);
SELECT LOG(10);
SELECT SQRT(16);

POWER() EXP() LOG()SQRT()

The POWER function raises a number to a specified power, while EXP computes exponential values. LOG and SQRT are used for logarithmic and square root calculations, respectively.

Q37

Multiple Choice

Which functions can be used to calculate trigonometric values? Select all that apply.

SQL Code

SELECT TAN(PI()/4);
SELECT COS(PI()/4);
SELECT SIN(PI()/4);
SELECT DEGREES(PI()/4);

TAN() COS() SIN()DEGREES()

The TAN, COS, and SIN functions return the tangent, cosine, and sine of an angle in radians, respectively.

Q38

Multiple Choice

Which functions are used to handle angles in SQL Server? Select all that apply.

SQL Code

SELECT DEGREES(PI());
SELECT RADIANS(180);
SELECT SIN(PI());
SELECT COS(PI());

DEGREES() RADIANS() SIN()COS()

The DEGREES and RADIANS functions convert between degrees and radians, while SIN and COS calculate trigonometric values.

Q39

Multiple Choice

Which functions are used to perform rounding operations? Select all that apply.

SQL Code

SELECT ROUND(123.456, 1);
SELECT CEILING(456.789);
SELECT FLOOR(789.123);
SELECT ROUND(987.654, 2);

ROUND() CEILING() FLOOR()TRUNCATE()

ROUND, CEILING, and FLOOR functions are used to perform rounding operations on numeric values.

Q40

Multiple Choice

Which functions can be used to compute trigonometric functions? Select all that apply.

SQL Code

SELECT SIN(PI()/2);
SELECT COS(PI()/2);
SELECT TAN(PI()/2);
SELECT EXP(1);

SIN() COS() TAN()EXP()

The SIN, COS, and TAN functions compute trigonometric functions based on angles in radians.

Q41

Multiple Choice

Which functions handle mathematical constants? Select all that apply.

SQL Code

SELECT PI();
SELECT EXP(1);
SELECT SQRT(1);
SELECT LOG(10);

PI() EXP() SQRT()LOG()

The PI function returns the value of pi (π), while EXP computes the exponential constant. SQRT and LOG do not handle mathematical constants.

Q42

Multiple Choice

Which functions are used to calculate square roots? Select all that apply.

SQL Code

SELECT SQRT(4);
SELECT POWER(2, 2);
SELECT LOG(10);
SELECT EXP(1);

SQRT() POWER() LOG()EXP()

The SQRT function calculates the square root of a number. POWER can also be used to find square roots by raising a number to the 0.5 power.

Q43

Multiple Choice

Which functions are used for logarithmic calculations? Select all that apply.

SQL Code

SELECT LOG(10);
SELECT LN(10);
SELECT EXP(1);
SELECT PI();

LOG() LN() EXP()PI()

The LOG and LN functions are used for logarithmic calculations, with LOG supporting different bases.

Q44

Multiple Choice

Which functions perform rounding operations? Select all that apply.

SQL Code

SELECT ROUND(10.25, 1);
SELECT CEILING(10.25);
SELECT FLOOR(10.25);
SELECT TRUNCATE(10.25);

ROUND() CEILING() FLOOR()TRUNCATE()

ROUND, CEILING, and FLOOR functions are used to perform rounding operations, while TRUNCATE is not available in SQL Server.

Q45

Multiple Choice

Which functions are used to handle angles in trigonometric calculations? Select all that apply.

SQL Code

SELECT DEGREES(PI()/2);
SELECT RADIANS(90);
SELECT SIN(PI()/2);
SELECT COS(PI()/2);

DEGREES() RADIANS() SIN()COS()

DEGREES and RADIANS functions handle angle conversions, while SIN and COS perform trigonometric calculations.

Microsoft SQL Server Database Quiz Questions