Oracle Database Sql Certified Associate · Free Practice Question Easy
Question 12
View and examine the following SQL exhibit.
Exhibit: 1
- SELECT TRUNC(ROUND(156.00, -1), -1)
- FROM DUAL;
Identify the result of the query execution.
-
A
150
-
B
100
-
C
160
-
D
16
-
E
200
Reveal correct answer
Correct answer: C
Explanation
Step-by-step Evaluation:
1. ROUND(156.00, -1)
The
ROUNDfunction with a negative precision rounds to the nearest 10.ROUND(156.00, -1)→ Rounds 156 to the nearest multiple of 10.156 is closer to 160 than 150.
Result: 160
2. TRUNC(160, -1)
The
TRUNCfunction with a negative precision truncates to the lower multiple of 10.TRUNC(160, -1)→ Truncates 160 down to the nearest 10 (removes units).Result: 160 (already a multiple of 10)
The Oracle/PLSQL TRUNC function returns a date truncated to a specific unit of measure.
Syntax (with dates)
The syntax for the TRUNC function in Oracle/PLSQL is:
- TRUNC ( date [, format ] )
Parameters or Arguments
date The date to truncate.
format - Optional. The unit of measure to apply for truncating. If the format parameter is omitted, the TRUNC function will truncate the date to the day value, so that any hours, minutes, or seconds will be truncated off.
Returns
The TRUNC function (as it applies to dates) returns a date value.
The Oracle/PLSQL TRUNC function returns a number truncated to a certain number of decimal places.
Syntax (with numbers)
The syntax for the TRUNC function in Oracle/PLSQL is:
- TRUNC( number [, decimal_places] )
Parameters or Arguments
number - The number to truncate. decimal_places Optional. The number of decimal places to truncate to. This value must be an integer. If this parameter is omitted, the TRUNC function will truncate the number to 0 decimal places.
Returns
The TRUNC function (as it applies to numbers) returns a numeric value.
The Oracle/PLSQL ROUND function returns a date rounded to a specific unit of measure.
ROUND Function Syntax (with dates)
The syntax for the ROUND function in Oracle/PLSQL is:
- ROUND( date [, format] )
Parameters or Arguments
date - The date to round.
format - Optional. The unit of measure to apply for rounding. If the format parameter is omitted, the ROUND function will round to the nearest day.
Returns
The ROUND function (as it applies to dates) returns a date value.
The Oracle/PLSQL ROUND function returns a number rounded to a certain number of decimal places.
Syntax (with numbers)
The syntax for the ROUND function in Oracle/PLSQL is:
- ROUND( number [, decimal_places] )
Parameters or Arguments
number - The number to round. decimal_places Optional. The number of decimal places rounded to. This value must be an integer. If this parameter is omitted, the ROUND function will round the number to 0 decimal places.
Returns
The ROUND function (as it applies to numbers) returns a numeric value.
A. The query in the exhibit is performing a multiplication operation between two numbers, which results in 10 * 16 = 160. Therefore, the correct result of the query execution is not 150.
B. The query in the exhibit is performing a multiplication operation between two numbers, which results in 10 * 16 = 160. Therefore, the correct result of the query execution is not 100.
C. The query in the exhibit is performing a multiplication operation between two numbers, which results in 10 * 16 = 160. Therefore, the correct result of the query execution is 160.
D. The query in the exhibit is performing a multiplication operation between two numbers, which results in 10 * 16 = 160. Therefore, the correct result of the query execution is not 16.
E. The query in the exhibit is performing a multiplication operation between two numbers, which results in 10 * 16 = 160. Therefore, the correct result of the query execution is not 200.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
