Which two statements would be true regarding the output for this SQL statement?

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

Evaluate the following SQL statement:
SELECT TO_CHAR(list_price ,’$9,999″)
FROM product_information;

Which two statements would be true regarding the output for this SQL statement? (Choose two.)

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

Evaluate the following SQL statement:
SELECT TO_CHAR(list_price ,’$9,999″)
FROM product_information;

Which two statements would be true regarding the output for this SQL statement? (Choose two.)

A.
The LIST_PRICE column having value 1123.90 would be displayed as $1,124.

B.
The LIST_PRICE column having value 1123.90 would be displayed as $1,123.

C.
The LIST_PRICE column having value 11235.90 would be displayed as $1,123.

D.
The LIST_PRICE column having value 11235.90 would be displayed as #######.



Leave a Reply 0

Your email address will not be published. Required fields are marked *