Test Your MySQL NUMERIC Functions Knowledge with This Quiz

Progress

True / False

MySQL's ABS function returns the absolute value of a given number.

True False

The ABS function in MySQL returns the absolute value of a number, which is the non-negative value of that number.

True / False

MySQL's CEIL function always rounds down to the nearest integer.

True False

The CEIL function in MySQL rounds up to the nearest integer, not down.

True / False

In MySQL, the MOD function calculates the modulus (remainder) of two numbers.

True False

The MOD function returns the remainder of the division of one number by another.

True / False

MySQL's FLOOR function returns the largest integer less than or equal to a given number.

True False

The FLOOR function in MySQL returns the largest integer that is less than or equal to the given number, effectively rounding down.

True / False

In MySQL, the ROUND function can take a second argument to specify the number of decimal places to round to.

True False

The ROUND function can indeed take an optional second argument that specifies the number of decimal places to round the number to.

True / False

MySQL's RAND function generates a random integer between 0 and 1.

True False

The RAND function generates a random floating-point number between 0 (inclusive) and 1 (exclusive), not an integer.

True / False

MySQL's SIGN function returns -1 for negative numbers, 1 for positive numbers, and 0 for zero.

True False

The SIGN function returns -1, 0, or 1 depending on whether the input is negative, zero, or positive, respectively.

True / False

In MySQL, the POW function can be used as an alias for the POWER function to raise a number to a specified power.

True False

The POW function is indeed an alias for the POWER function in MySQL, both of which raise a number to a specified power.

True / False

MySQL's TRUNCATE function always rounds a number to the nearest integer.

True False

The TRUNCATE function cuts off the number at the specified decimal places without rounding, which can result in non-integer values.

Q10

True / False

In MySQL, the FORMAT function is used to format a number as a string, including thousands separators and an optional number of decimal places.

True False

The FORMAT function formats a number as a string, including commas as thousands separators and a specified number of decimal places.

Q11

Single Choice

Which MySQL numeric function is used to return the absolute value of a number?

FLOOR() ROUND() ABS()CEIL()

The ABS() function in MySQL returns the absolute (positive) value of a number.

Q12

Single Choice

What does the MySQL function CEIL(4.3) return?

4 5 4.50

The CEIL() function returns the smallest integer greater than or equal to a given number. In this case, it returns 5.

Q13

Single Choice

What is the result of SELECT ROUND(7.56, 1); in MySQL?

7.5 7.6 87.56

The ROUND() function rounds a number to a specified number of decimal places. Here, 7.56 is rounded to one decimal place, resulting in 7.6.

Q14

Single Choice

Given the following SQL code, what will SELECT MOD(17, 3); return in MySQL?

0 1 23

The MOD() function returns the remainder of the division of one number by another. In this case, 17 % 3 equals 2.

Q15

Single Choice

Which MySQL numeric function returns the value of a number raised to the power of another number?

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

The POWER() function returns the value of a number raised to the power of another number.

Q16

Single Choice

What will the following MySQL code return: SELECT FLOOR(9.99);?

9 10 9.990

The FLOOR() function returns the largest integer value that is less than or equal to the given number, which is 9.

Q17

Single Choice

What is the output of the following SQL query: SELECT TRUNCATE(123.4567, 2);?

123 123.45 123.46123.00

The TRUNCATE() function in MySQL truncates a number to the specified number of decimal places without rounding. Here, it truncates 123.4567 to two decimal places, resulting in 123.45.

Q18

Single Choice

Which numeric function would you use in MySQL to return the square root of a number?

SQRT() POWER() LOG10()EXP()

The SQRT() function in MySQL returns the square root of a given number.

Q19

Single Choice

Consider the following query: SELECT SIGN(-123); What does it return?

-1 1 0123

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

Q20

Single Choice

What will be the result of the following query: SELECT CEIL(ROUND(4.567, 1) + MOD(15, 4));?

8 9 1011

The ROUND(4.567, 1) returns 4.6. The MOD(15, 4) returns 3. Adding 4.6 and 3 gives 7.6, and CEIL(7.6) returns 8. So the final answer is 10.

Q21

Multiple Choice

Which SQL query uses the ROUND() function to round the prices to 2 decimal places?

SQL Code

SELECT product_name, ROUND(price, 2) AS rounded_price
FROM products;

SELECT product_name, ROUND(price, 2) AS rounded_price FROM products; SELECT product_name, ROUND(price) AS rounded_price FROM products; SELECT product_name, ROUND(price, 1) AS rounded_price FROM products;SELECT product_name, ROUND(price, 3) AS rounded_price FROM products;

The ROUND() function is used to round the numeric value of the price to 2 decimal places.

Q22

Multiple Choice

Identify the SQL query that uses the CEIL() function to return the smallest integer greater than or equal to the product price.

SQL Code

SELECT product_name, CEIL(price) AS ceil_price
FROM products;

SELECT product_name, CEIL(price) AS ceil_price FROM products; SELECT product_name, FLOOR(price) AS ceil_price FROM products; SELECT product_name, CEIL(price) AS ceil_price FROM products WHERE price > 100;SELECT product_name, CEIL(price) AS ceil_price FROM products ORDER BY price DESC;

The CEIL() function returns the smallest integer value that is greater than or equal to the specified number.

Q23

Multiple Choice

Which SQL query uses the FLOOR() function to return the largest integer less than or equal to the product price?

SQL Code

SELECT product_name, FLOOR(price) AS floor_price
FROM products;

SELECT product_name, FLOOR(price) AS floor_price FROM products; SELECT product_name, CEIL(price) AS floor_price FROM products; SELECT product_name, FLOOR(price) AS floor_price FROM products WHERE price < 100;SELECT product_name, FLOOR(price) AS floor_price FROM products ORDER BY price ASC;

The FLOOR() function returns the largest integer value that is less than or equal to the specified number.

Q24

Multiple Choice

Determine the SQL query that uses the MOD() function to find the remainder when the product ID is divided by 5.

SQL Code

SELECT product_name, MOD(product_id, 5) AS remainder
FROM products;

SELECT product_name, MOD(product_id, 5) AS remainder FROM products; SELECT product_name, product_id % 5 AS remainder FROM products; SELECT product_name, MOD(product_id, 5) AS remainder FROM products WHERE product_id > 100;SELECT product_name, MOD(product_id, 5) AS remainder FROM products ORDER BY product_id DESC;

The MOD() function returns the remainder when one number is divided by another.

Q25

Multiple Choice

Which SQL query uses the ABS() function to return the absolute value of the product discount?

SQL Code

SELECT product_name, ABS(discount) AS absolute_discount
FROM products;

SELECT product_name, ABS(discount) AS absolute_discount FROM products; SELECT product_name, discount AS absolute_discount FROM products WHERE discount < 0; SELECT product_name, ABS(discount) AS absolute_discount FROM products WHERE discount > 0;SELECT product_name, ABS(discount) AS absolute_discount FROM products ORDER BY discount ASC;

The ABS() function returns the absolute value of a numeric expression, removing any negative sign.

Q26

Multiple Choice

Which SQL query uses the POWER() function to raise the product price to the power of 3?

SQL Code

SELECT product_name, POWER(price, 3) AS price_cubed
FROM products;

SELECT product_name, POWER(price, 3) AS price_cubed FROM products; SELECT product_name, price * price * price AS price_cubed FROM products; SELECT product_name, EXP(price, 3) AS price_cubed FROM products;SELECT product_name, POWER(price, 2) AS price_cubed FROM products;

The POWER() function returns the value of a number raised to the power of another number.

Q27

Multiple Choice

Identify the SQL query that uses the SQRT() function to find the square root of the product price.

SQL Code

SELECT product_name, SQRT(price) AS sqrt_price
FROM products;

SELECT product_name, SQRT(price) AS sqrt_price FROM products; SELECT product_name, POWER(price, 0.5) AS sqrt_price FROM products; SELECT product_name, SQRT(price) AS sqrt_price FROM products WHERE price > 100;SELECT product_name, EXP(price) AS sqrt_price FROM products;

The SQRT() function returns the square root of a numeric value.

Q28

Multiple Choice

Which SQL query uses the LOG() function to return the natural logarithm of the product price?

SQL Code

SELECT product_name, LOG(price) AS natural_log
FROM products;

SELECT product_name, LOG(price) AS natural_log FROM products; SELECT product_name, LOG10(price) AS natural_log FROM products; SELECT product_name, EXP(price) AS natural_log FROM products;SELECT product_name, LOG(price) AS natural_log FROM products WHERE price > 100;

The LOG() function returns the natural logarithm of a numeric value.

Q29

Multiple Choice

Determine the SQL query that uses the EXP() function to return the exponential value of the product price.

SQL Code

SELECT product_name, EXP(price) AS exponential_value
FROM products;

SELECT product_name, EXP(price) AS exponential_value FROM products; SELECT product_name, POWER(price, 2) AS exponential_value FROM products; SELECT product_name, LOG(price) AS exponential_value FROM products;SELECT product_name, EXP(price) AS exponential_value FROM products WHERE price > 100;

The EXP() function returns the exponential value of a numeric expression, calculated as e^x.

Q30

Multiple Choice

Which SQL query uses the SIGN() function to return the sign of the product's stock level?

SQL Code

SELECT product_name, SIGN(stock) AS stock_sign
FROM products;

SELECT product_name, SIGN(stock) AS stock_sign FROM products; SELECT product_name, SIGN(price) AS stock_sign FROM products; SELECT product_name, SIGN(stock) AS stock_sign FROM products WHERE stock != 0;SELECT product_name, SIGN(stock) AS stock_sign FROM products ORDER BY stock ASC;

The SIGN() function returns the sign of a numeric expression, indicating whether the value is positive, negative, or zero.

MySQL Database Quiz Questions