Oracle
1Z0-071 · Question #306
The PRODUCT_INFORMATION table has a UNIT_PRICE column of data type NUMBER (8, 2). Evaluate this SQL statement: SELECT TO_CHAR(unit_price, `$9,999') FROM product_information; Which two statements are…
The correct answer is C. A row whose UNIT_PRICE column contains the value 10235.99 will be displayed as #######. E. A row whose UNIT_PRICE column contains the value 1023.99 will be displayed as $1,023. See the full explanation below for the reasoning.
Question
The PRODUCT_INFORMATION table has a UNIT_PRICE column of data type NUMBER (8, 2). Evaluate this SQL statement:
SELECT TO_CHAR(unit_price, `$9,999') FROM product_information; Which two statements are true about the output? (Choose two.)
Options
- AA row whose UNIT_PRICE column contains the value 1023.99 will be displayed as $1,024.
- BA row whose UNIT_PRICE column contains the value 10235.99 will be displayed as $1,0236.
- CA row whose UNIT_PRICE column contains the value 10235.99 will be displayed as #######.
- DA row whose UNIT_PRICE column contains the value 10235.99 will be displayed as $1,023.
- EA row whose UNIT_PRICE column contains the value 1023.99 will be displayed as $1,023.
How the community answered
(35 responses)- A3% (1)
- B11% (4)
- C80% (28)
- D6% (2)
Community Discussion
No community discussion yet for this question.