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

Download Printable PDF. VALID exam to help you PASS.

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.