Test Your Oracle NUMERIC Functions Knowledge: Quiz

Progress

True / False

In Oracle, the ROUND function is used to round a numeric value to a specified number of decimal places.

True False

The ROUND function rounds a numeric value to the nearest specified number of decimal places.

True / False

The CEIL function in Oracle returns the smallest integer that is greater than or equal to a given numeric value.

True False

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

True / False

In Oracle, the FLOOR function returns the largest integer that is less than or equal to a given numeric value.

True False

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

True / False

In Oracle, the MOD function returns the remainder of a division operation.

True False

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

True / False

The TRUNC function in Oracle can be used to truncate a numeric value to a specified number of decimal places.

True False

The TRUNC function truncates a numeric value to the specified number of decimal places without rounding.

True / False

In Oracle, the POWER function returns the result of raising one numeric value to the power of another.

True False

The POWER function raises a number to the power of another number.

True / False

The SIGN function in Oracle returns the sign of a numeric value, indicating whether the value is positive, negative, or zero.

True False

The SIGN function returns -1 if the number is negative, 0 if the number is zero, and 1 if the number is positive.

True / False

In Oracle, the ABS function returns the absolute value of a numeric expression.

True False

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

True / False

The LN function in Oracle calculates the natural logarithm of a given numeric value.

True False

The LN function returns the natural logarithm (base e) of a specified numeric value.

Q10

True / False

The Oracle Certified Professional (OCP) exam includes knowledge on using numeric functions effectively, understanding their syntax, and optimizing their performance in SQL queries.

True False

The OCP certification covers advanced topics, including the effective use of numeric functions, understanding their syntax, and optimizing their performance in SQL queries.

Q11

Single Choice

Which Oracle SQL function is used to round a number to the nearest integer?

FLOOR CEIL ROUNDMOD

The ROUND function in Oracle rounds a number to the nearest integer or to a specified number of decimal places.

Q12

Single Choice

What will be the result of the following Oracle SQL expression?

SQL Code

SELECT ABS(-15) FROM dual;

-15 15 0NULL

The ABS function returns the absolute value of a number, which is always positive.

Q13

Single Choice

Which Oracle SQL function can you use to find the remainder of a division operation?

MOD DIV REMAINDERFLOOR

The MOD function returns the remainder of a division operation.

Q14

Single Choice

Consider the following Oracle SQL query:What does this query return?

SQL Code

SELECT ROUND(45.678, 1) FROM dual;

45.67 45.6 45.6846

The ROUND function rounds the number to 1 decimal place, resulting in 45.68.

Q15

Single Choice

Which Oracle SQL function would you use to always round a number up to the nearest integer?

ROUND FLOOR TRUNCCEIL

The CEIL function rounds a number up to the nearest integer, regardless of its decimal part.

Q16

Single Choice

Given the Oracle SQL query:What will be the result?

SQL Code

SELECT TRUNC(15.789, 2) FROM dual;

15.79 15.78 15.715.00

The TRUNC function truncates the number to 2 decimal places without rounding, resulting in 15.78.

Q17

Single Choice

What will be the result of the following Oracle SQL query?

SQL Code

SELECT POWER(2, 3) FROM dual;

6 8 92

The POWER function raises the first number to the power of the second number, so 2^3 equals 8.

Q18

Single Choice

Consider the following Oracle SQL query:What does this query return?

SQL Code

SELECT SIGN(-25) FROM dual;

-25 25 1-1

The SIGN function returns -1 if the number is negative, 1 if it is positive, and 0 if it is zero.

Q19

Single Choice

Which Oracle SQL function can be used to return the smallest integer greater than or equal to a given number?

FLOOR ROUND CEILMOD

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

Q20

Single Choice

What is the result of the following Oracle SQL query?

SQL Code

SELECT TRUNC(MOD(ABS(-17.8), 7)) FROM dual;

3 4 60

The query first calculates the absolute value of -17.8 (which is 17.8), then finds the remainder when 17.8 is divided by 7 (which is 3.8), and finally truncates this value to 3.

Q21

Multiple Choice

Which SQL code snippet uses the `ROUND` function to round the salary to 2 decimal places in Oracle?

SQL Code

SELECT employee_id, salary, ROUND(salary, 2) AS rounded_salary
FROM employees;

SELECT employee_id, salary, ROUND(salary, 2) AS rounded_salary
FROM employees;

SELECT employee_id, salary, ROUND(salary, 2) AS rounded_salary
FROM employees;

SELECT employee_id, salary, ROUND(salary, 2) AS rounded_salary FROM employees; SELECT employee_id, salary, ROUND(salary, 2) AS rounded_salary FROM employees; SELECT employee_id, salary, ROUND(salary, 2) AS rounded_salary FROM employees;SELECT employee_id, salary FROM employees;

Options A, B, and C correctly demonstrate the use of the `ROUND` function to round the salary to 2 decimal places. Option D is incorrect because it does not use the `ROUND` function.

Q22

Multiple Choice

Which SQL code snippet uses the `TRUNC` function to truncate the salary to the nearest thousand in Oracle?

SQL Code

SELECT employee_id, salary, TRUNC(salary, -3) AS truncated_salary
FROM employees;

SELECT employee_id, salary, TRUNC(salary, -3) AS truncated_salary
FROM employees;

SELECT employee_id, salary, TRUNC(salary, -3) AS truncated_salary
FROM employees;

SELECT employee_id, salary, TRUNC(salary, -3) AS truncated_salary FROM employees; SELECT employee_id, salary, TRUNC(salary, -3) AS truncated_salary FROM employees; SELECT employee_id, salary, TRUNC(salary, -3) AS truncated_salary FROM employees;SELECT employee_id, salary FROM employees;

Options A, B, and C correctly demonstrate the use of the `TRUNC` function to truncate the salary to the nearest thousand. Option D is incorrect because it does not use the `TRUNC` function.

Q23

Multiple Choice

Which SQL code snippet uses the `MOD` function to find the remainder when the salary is divided by 1000 in Oracle?

SQL Code

SELECT employee_id, salary, MOD(salary, 1000) AS remainder
FROM employees;

SELECT employee_id, salary, MOD(salary, 1000) AS remainder
FROM employees;

SELECT employee_id, salary, MOD(salary, 1000) AS remainder
FROM employees;

SELECT employee_id, salary, MOD(salary, 1000) AS remainder FROM employees; SELECT employee_id, salary, MOD(salary, 1000) AS remainder FROM employees; SELECT employee_id, salary, MOD(salary, 1000) AS remainder FROM employees;SELECT employee_id, salary FROM employees;

Options A, B, and C correctly demonstrate the use of the `MOD` function to find the remainder when the salary is divided by 1000. Option D is incorrect because it does not use the `MOD` function.

Q24

Multiple Choice

Which SQL code snippet uses the `FLOOR` function to find the largest integer less than or equal to the salary in Oracle?

SQL Code

SELECT employee_id, salary, FLOOR(salary) AS floor_salary
FROM employees;

SELECT employee_id, salary, FLOOR(salary) AS floor_salary
FROM employees;

SELECT employee_id, salary, FLOOR(salary) AS floor_salary
FROM employees;

SELECT employee_id, salary, FLOOR(salary) AS floor_salary FROM employees; SELECT employee_id, salary, FLOOR(salary) AS floor_salary FROM employees; SELECT employee_id, salary, FLOOR(salary) AS floor_salary FROM employees;SELECT employee_id, salary FROM employees;

Options A, B, and C correctly demonstrate the use of the `FLOOR` function to find the largest integer less than or equal to the salary. Option D is incorrect because it does not use the `FLOOR` function.

Q25

Multiple Choice

Which SQL code snippet uses the `CEIL` function to find the smallest integer greater than or equal to the salary in Oracle?

SQL Code

SELECT employee_id, salary, CEIL(salary) AS ceil_salary
FROM employees;

SELECT employee_id, salary, CEIL(salary) AS ceil_salary
FROM employees;

SELECT employee_id, salary, CEIL(salary) AS ceil_salary
FROM employees;

SELECT employee_id, salary, CEIL(salary) AS ceil_salary FROM employees; SELECT employee_id, salary, CEIL(salary) AS ceil_salary FROM employees; SELECT employee_id, salary, CEIL(salary) AS ceil_salary FROM employees;SELECT employee_id, salary FROM employees;

Options A, B, and C correctly demonstrate the use of the `CEIL` function to find the smallest integer greater than or equal to the salary. Option D is incorrect because it does not use the `CEIL` function.

Q26

Multiple Choice

Which SQL code snippet demonstrates advanced use of the `POWER` function to calculate the square of the employee's salary in Oracle?

SQL Code

SELECT employee_id, salary, POWER(salary, 2) AS squared_salary
FROM employees;

SELECT employee_id, salary, POWER(salary, 2) AS squared_salary
FROM employees;

SELECT employee_id, salary, POWER(salary, 2) AS squared_salary
FROM employees;

SELECT employee_id, salary, POWER(salary, 2) AS squared_salary FROM employees; SELECT employee_id, salary, POWER(salary, 2) AS squared_salary FROM employees; SELECT employee_id, salary, POWER(salary, 2) AS squared_salary FROM employees;SELECT employee_id, salary FROM employees;

Options A, B, and C correctly demonstrate advanced use of the `POWER` function to calculate the square of the employee's salary. Option D is incorrect because it does not use the `POWER` function.

Q27

Multiple Choice

Which SQL code snippet demonstrates advanced use of the `SQRT` function to calculate the square root of the employee's salary in Oracle?

SQL Code

SELECT employee_id, salary, SQRT(salary) AS sqrt_salary
FROM employees;

SELECT employee_id, salary, SQRT(salary) AS sqrt_salary
FROM employees;

SELECT employee_id, salary, SQRT(salary) AS sqrt_salary
FROM employees;

SELECT employee_id, salary, SQRT(salary) AS sqrt_salary FROM employees; SELECT employee_id, salary, SQRT(salary) AS sqrt_salary FROM employees; SELECT employee_id, salary, SQRT(salary) AS sqrt_salary FROM employees;SELECT employee_id, salary FROM employees;

Options A, B, and C correctly demonstrate advanced use of the `SQRT` function to calculate the square root of the employee's salary. Option D is incorrect because it does not use the `SQRT` function.

Q28

Multiple Choice

Which SQL code snippet demonstrates certification-level use of the `SIGN` function to determine the sign of the employee's bonus in Oracle?

SQL Code

SELECT employee_id, bonus, SIGN(bonus) AS bonus_sign
FROM employees;

SELECT employee_id, bonus, SIGN(bonus) AS bonus_sign
FROM employees;

SELECT employee_id, bonus, SIGN(bonus) AS bonus_sign
FROM employees;

SELECT employee_id, bonus, SIGN(bonus) AS bonus_sign FROM employees; SELECT employee_id, bonus, SIGN(bonus) AS bonus_sign FROM employees; SELECT employee_id, bonus, SIGN(bonus) AS bonus_sign FROM employees;SELECT employee_id, bonus FROM employees;

Options A, B, and C correctly demonstrate certification-level use of the `SIGN` function to determine the sign of the employee's bonus. Option D is incorrect because it does not use the `SIGN` function.

Q29

Multiple Choice

Which SQL code snippet demonstrates certification-level use of the `ABS` function to find the absolute value of the employee's bonus in Oracle?

SQL Code

SELECT employee_id, bonus, ABS(bonus) AS abs_bonus
FROM employees;

SELECT employee_id, bonus, ABS(bonus) AS abs_bonus
FROM employees;

SELECT employee_id, bonus, ABS(bonus) AS abs_bonus
FROM employees;

SELECT employee_id, bonus, ABS(bonus) AS abs_bonus FROM employees; SELECT employee_id, bonus, ABS(bonus) AS abs_bonus FROM employees; SELECT employee_id, bonus, ABS(bonus) AS abs_bonus FROM employees;SELECT employee_id, bonus FROM employees;

Options A, B, and C correctly demonstrate certification-level use of the `ABS` function to find the absolute value of the employee's bonus. Option D is incorrect because it does not use the `ABS` function.

Q30

Multiple Choice

Which SQL code snippet demonstrates certification-level use of the `EXP` function to calculate the exponential value of the employee's performance score in Oracle?

SQL Code

SELECT employee_id, performance_score, EXP(performance_score) AS exp_value
FROM employees;

SELECT employee_id, performance_score, EXP(performance_score) AS exp_value
FROM employees;

SELECT employee_id, performance_score, EXP(performance_score) AS exp_value
FROM employees;

SELECT employee_id, performance_score, EXP(performance_score) AS exp_value FROM employees; SELECT employee_id, performance_score, EXP(performance_score) AS exp_value FROM employees; SELECT employee_id, performance_score, EXP(performance_score) AS exp_value FROM employees;SELECT employee_id, performance_score FROM employees;

Options A, B, and C correctly demonstrate certification-level use of the `EXP` function to calculate the exponential value of the employee's performance score. Option D is incorrect because it does not use the `EXP` function.

Oracle Database Quiz Questions