A is the right one :
The ROUND(156.00, -2) function call rounds the number 156.00 to the nearest hundredth, resulting in the value 200.
The TRUNC(200, -1) function call truncates the number 200 to the nearest ten, resulting in the value 150.
Therefore, the final result of the SQL query is 150.
TRUNC does nothing here. The rounding of -2 gives closest order of 100, 156->200. Then 200 is truncated to 200
upvoted 2 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
yaya32
1 year agoandrejshilin16
6 months, 2 weeks agolucemqy
1 year, 2 months agometallers
1 year, 3 months agotjsweg
1 year, 5 months agoMcromeo
1 year, 4 months agozouve
1 year, 7 months agoCMjer
1 year, 8 months agoAc37
1 year, 10 months agoAbdullaMA2
1 year, 10 months agoFargo01
10 months, 2 weeks agoRik92
1 year, 11 months ago