Which values are displayed? - ProProfs Discuss
Advertisement

Which values are displayed?

Evaluate the SQL statement: SELECT ROUND(45.953, -1), TRUNC(45.936, 2) FROM dual;

A. 46 and 45
B. 46 and 45.93
C. 50 and 45.93
D. 45 and 45.93
E. 45.95 and 45.93

Asked by Kabirkhanna, Last updated: Sep 12, 2021

+ Answer
Request
Question menu
Vote up Vote down

3 Answers

amrita.ghosh0907

amrita.ghosh

amrita.ghosh0907
Amrita.ghosh

Answered Jun 21, 2020

The correct answer should be 50, 45.93. I have also tried it and checked.

upvote downvote
Reply 

Peter

Peter

Peter
Peter

Answered Jun 19, 2018

The correct answer should be 40 and 45.93. a trunc with -1 truncates the number which is evaluated to tenth values (10,20,30,40 etc..)

upvote downvote
Reply 

kabirkhanna

kabirkhanna

kabirkhanna
Kabirkhanna

Answered Sep 11, 2017

46 and 45
upvote downvote
Reply 

Advertisement
Advertisement
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader

Email Sent
We have sent an email to your address "" with instructions to reset your password.