Oracle Database SQL 12c 1z0-071 Exam Practice Test 4

Question : 8 of 57

Marks: +1, -0

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.)

A row whose UNIT_PRICE column contains the value 1023.99 will be displayed as $1,024.
A row whose UNIT_PRICE column contains the value 10235.99 will be displayed as $1,0236.
A row whose UNIT_PRICE column contains the value 10235.99 will be displayed as #######.
A row whose UNIT_PRICE column contains the value 10235.99 will be displayed as $1,023.
A row whose UNIT_PRICE column contains the value 1023.99 will be displayed as $1,023.

Validate

Go to Question:

Prev Question

Next Question