Evaluate the following SQL statement: SELECT ROUND (TRUNC (MOD (1600, 10),-1), 2) FROM dual; What will be displayed?
B
Correct answer
Explanation
To understand the given SQL statement, the user must know the following functions:
- MOD - returns the remainder of a division operation
- TRUNC - truncates a number to a specified number of decimal places
- ROUND - rounds a number to a specified number of decimal places
Now let's break down the SQL statement:
- The MOD function calculates the remainder of 1600 divided by 10, which is 0.
- The TRUNC function truncates 0 to -1 decimal places, which is still 0.
- Finally, the ROUND function rounds 0 to 2 decimal places, which is still 0.
Therefore, the answer is option B: 0.