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?
A. A row whose UNIT_PRICE column contains the value 1023.99 will be displayed as $1,024.
B. A row whose UNIT_PRICE column contains the value 10235.99 will be displayed as $1,0236.
C. A row whose UNIT_PRICE column contains the value 10235.99 will be displayed as #######.
D. A row whose UNIT_PRICE column contains the value 10235.99 will be displayed as $1,023.
E. A row whose UNIT_PRICE column contains the value 1023.99 will be displayed as $1,023.
|
Download Printable PDF. VALID exam to help you PASS. |
 |
AC
AC
AC