1. What is the truncated value of 78.90 when this SQL statement is executed? SEL

Question

1. What is the truncated value of 78.90 when this SQL statement is executed?

SELECT TRUNC(78.90,-2) FROM DUAL;

2.

What is the round of value of 78.90 when this SQL statement is executed?

SELECT ROUND(78.90,-2) FROM DUAL;

3.

What is the round of value of 78.90 when this SQL statement is executed?

SELECT ROUND(78.90,1) FROM DUAL;

Quiz Type: Set B- Application - LongQuiz002 PART DESCRIPTION ONHAND CLASS WAREHOUSE - - - - - - - - - - - - - - - - - - -- ---------- ----- ---------- AT94 IRON BV06 HOME GYM CD52 MICROWAVE OVEN DL71 CORDLESS DRILL DR93 GAS RANGE DW11 WASHER FD21 STAND MIXER KL62 DRYER KTO3 DISHWASHER KV29 TREADMILL 50 HW 45 SG 32 AP 21 HW 21 AP 12 AP 22 HW 12 AP 8 AP 9 SG PRICE ---------- 2495 79495 165 12995 495 399 159 349 595 1390

Explanation / Answer

1) 0 is the truncated value. TRUNC in sql will remove the digits froma given integer. If given positive then it will remove digits from decimal poit otherwise it will remove from main value. So here we have given -2 so it will remove 78 so it will return 0.

2)100 is the value. Since -2 is given in round function it will rond value before the decimal point so it will round 78 to 100

3) 78.9 is the rounded value. Since 1 is given it will round to one value after the decimal

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.