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

Question : 10 of 50

Marks: +1, -0

View the Exhibit and examine the details of the PRODUCT_INFORMATION table.

Evaluate this SQL statement:

 SELECT TO_CHAR (list_price, ' $\$$ 9,999') 
 From product_information;

Which two statements are true regarding the output? (Choose two.)

A row whose LIST_PRICE column contains value 11235.90 would be displayed as #######.
A row whose LIST_PRICE column contains value 1123.90 would be displayed as $\$$ 1,123.
A row whose LIST_PRICE column contains value 1123.90 would be displayed as $\$$ 1,124.
A row whose LIST_PRICE column contains value 11235.90 would be displayed as $\$$ 1,123.

Go to Question:

Prev Question

Next Question