Test Your PostgreSQL NUMERIC Functions Knowledge with this Quiz

Progress

True / False

In PostgreSQL, the ROUND() function can only be used with integers.

True False

The ROUND() function can be used with any numeric value, not just integers. It rounds the numeric value to the nearest integer or specified decimal places.

True / False

The ABS() function in PostgreSQL returns the absolute value of a numeric input.

True False

The ABS() function returns the absolute (non-negative) value of the numeric input.

True / False

In PostgreSQL, the MOD() function is used to calculate the remainder of a division operation.

True False

The MOD() function returns the remainder of the division of two numeric values.

True / False

The CEIL() function in PostgreSQL always rounds a number up to the nearest integer.

True False

The CEIL() (or CEILING()) function rounds the numeric value up to the nearest integer.

True / False

PostgreSQL’s TRUNC() function can only truncate numbers to an integer.

True False

The TRUNC() function can truncate numbers to a specified number of decimal places, not just to an integer.

True / False

The POWER() function in PostgreSQL raises a number to the power of another number.

True False

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

True / False

In PostgreSQL, the SQRT() function can be used to find the square root of a negative number

True False

The SQRT() function cannot be used with negative numbers as the result would be a complex number, which PostgreSQL does not support natively for this function.

True / False

PostgreSQL’s LOG() function can take a base and a number as arguments.

True False

The LOG() function in PostgreSQL can take two arguments: the base and the number, to return the logarithm of the number to the given base.

True / False

The RANDOM() function in PostgreSQL generates a random number between 0 and 1.

True False

The RANDOM() function returns a random floating-point value between 0 (inclusive) and 1 (exclusive).

Q10

True / False

In PostgreSQL, using the FLOOR() function will always return a value less than or equal to the original number.

True False

The FLOOR() function always rounds down the numeric value to the nearest integer that is less than or equal to the original number.

Q11

Single Choice

In PostgreSQL, which function would you use to round a numeric value to the nearest integer?

FLOOR() CEIL() ROUND()TRUNC()

The ROUND() function in PostgreSQL is used to round a numeric value to the nearest integer. For example, ROUND(4.6) will return 5.

Q12

Single Choice

What does the ABS() function return when used in PostgreSQL?

The square root of a number The absolute value of a number The cube root of a numberThe modulus of a number

The ABS() function returns the absolute (positive) value of a numeric expression. For example, ABS(-5) will return 5.

Q13

Single Choice

How do you calculate the square root of a number in PostgreSQL?

SQRT() SQUARE() ROOT()POWER()

The SQRT() function in PostgreSQL returns the square root of a numeric value. For example, SQRT(9) returns 3.

Q14

Single Choice

What is the output of the following PostgreSQL query?

SQL Code

SELECT CEIL(4.2);

4 5 4.24.0

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

Q15

Single Choice

Which PostgreSQL function would you use to truncate a numeric value to a specific number of decimal places?

ROUND() TRUNC() CEIL()FLOOR()

The TRUNC() function truncates a numeric value to a specified number of decimal places without rounding. For example, TRUNC(4.678, 2) will return 4.67.

Q16

Single Choice

What does the following PostgreSQL query return?

SQL Code

SELECT MOD(10, 3);

1 2 34

The MOD() function returns the remainder of the division of the first argument by the second. Here, 10 % 3 is 1.

Q17

Single Choice

What is the result of the following PostgreSQL query?

SQL Code

SELECT POWER(2, 3);

5 6 78

The POWER() function in PostgreSQL returns the result of raising the first argument to the power of the second argument. In this case, POWER(2, 3) equals 8.

Q18

Single Choice

How can you calculate the natural logarithm of a number in PostgreSQL?

LN() LOG() EXP()LOG10()

The LN() function in PostgreSQL returns the natural logarithm (base e) of a given number. For example, LN(1) returns 0.

Q19

Single Choice

What will the following PostgreSQL query return?

SQL Code

SELECT FLOOR(8.7);

8 9 02

The FLOOR() function in PostgreSQL returns the largest integer less than or equal to the given number. Here, FLOOR(8.7) returns 8.

Q20

Single Choice

In PostgreSQL, what does the following query return when using the CUME_DIST() function?

SQL Code

SELECT CUME_DIST() OVER (ORDER BY salary) FROM employees;

A cumulative distribution of salaries The total sum of salaries The count of employeesThe average of salaries

The CUME_DIST() function in PostgreSQL computes the cumulative distribution of a value within a set of values. The result is a number between 0 and 1, representing the percentage of rows with values less than or equal to the current row's value.

Q21

Multiple Choice

Which SQL queries correctly use the ROUND function to round numeric values in PostgreSQL?

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

The ROUND function is used to round a numeric value to a specified number of decimal places.

Q22

Multiple Choice

Which SQL queries correctly use the CEIL function to round up numeric values in PostgreSQL?

SELECT CEIL(total_amount) AS rounded_amount FROM invoices; SELECT CEIL(total_amount, 2) AS rounded_amount FROM invoices; SELECT CEIL(total_amount, 0) AS rounded_amount FROM invoices;SELECT CEIL(total_amount - 0.5) AS rounded_amount FROM invoices;

The CEIL function returns the smallest integer greater than or equal to the given numeric value.

Q23

Multiple Choice

Which SQL queries correctly use the FLOOR function to round down numeric values in PostgreSQL?

SELECT FLOOR(monthly_salary) AS floored_salary FROM salaries; SELECT FLOOR(monthly_salary, 2) AS floored_salary FROM salaries; SELECT FLOOR(monthly_salary, 0) AS floored_salary FROM salaries;SELECT FLOOR(monthly_salary + 0.5) AS floored_salary FROM salaries;

The FLOOR function returns the largest integer less than or equal to the given numeric value.

Q24

Multiple Choice

Which SQL queries correctly use the MOD function to find the remainder of a division in PostgreSQL?

SELECT MOD(quantity, 5) AS remainder FROM orders; SELECT MOD(order_id, quantity) AS remainder FROM orders; SELECT MOD(5, quantity) AS remainder FROM orders;SELECT MOD(quantity - 1, 5) AS remainder FROM orders;

The MOD function returns the remainder of the division of two numbers.

Q25

Multiple Choice

Which SQL queries correctly use the ABS function to get the absolute value of a number in PostgreSQL?

SELECT ABS(profit_loss) AS abs_value FROM transactions; SELECT ABS(profit_loss) FROM transactions; SELECT ABS(-profit_loss) AS abs_value FROM transactions;SELECT ABS(profit_loss - 100) AS abs_value FROM transactions;

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

Q26

Multiple Choice

Which SQL queries correctly use the POWER function to raise a number to a specific power in PostgreSQL?

SELECT POWER(base, exponent) AS result FROM calculations; SELECT POWER(base, 2) AS result FROM calculations; SELECT POWER(2, exponent) AS result FROM calculations;SELECT POWER(exponent, base) AS result FROM calculations;

The POWER function returns the value of the first argument raised to the power of the second argument.

Q27

Multiple Choice

Which SQL queries correctly use the SQRT function to calculate the square root in PostgreSQL?

SELECT SQRT(area) AS sqrt_value FROM areas; SELECT SQRT(area * 2) AS sqrt_value FROM areas; SELECT SQRT(area / 2) AS sqrt_value FROM areas;SELECT SQRT(ABS(area)) AS sqrt_value FROM areas;

The SQRT function returns the square root of a given number.

Q28

Multiple Choice

Which SQL queries correctly use the LOG function to calculate the logarithm in PostgreSQL?

SELECT LOG(value) AS log_value FROM measurements; SELECT LOG(10, value) AS log_value FROM measurements; SELECT LOG(value, 10) AS log_value FROM measurements;SELECT LOG(value + 1) AS log_value FROM measurements;

The LOG function returns the logarithm of a given number to the base e (natural logarithm).

Q29

Multiple Choice

Which SQL queries correctly use the EXP function to calculate the exponential value in PostgreSQL?

SELECT EXP(rate) AS exp_value FROM growth; SELECT EXP(rate * 2) AS exp_value FROM growth; SELECT EXP(rate + 1) AS exp_value FROM growth;SELECT EXP(ABS(rate)) AS exp_value FROM growth;

The EXP function returns e raised to the power of the given number, where e is the base of natural logarithms.

Q30

Multiple Choice

Which SQL queries correctly use the SIGN function to determine the sign of a number in PostgreSQL?

SELECT SIGN(difference) AS sign_value FROM data; SELECT SIGN(-difference) AS sign_value FROM data; SELECT SIGN(ABS(difference)) AS sign_value FROM data;SELECT SIGN(difference + 0.1) AS sign_value FROM data;

The SIGN function returns -1, 0, or 1, depending on the sign of the input value.

PostgreSQL Database Quiz Questions