Oracle
1Z0-047 · Question #73
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…
The correct answer is A. The LIST_PRICE column having value 1123.90 would be displayed as $1,124. D. The LIST_PRICE column having value 11235.90 would be displayed as #######. See the full explanation below for the reasoning.
Question
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.)
Exhibit
Options
- AThe LIST_PRICE column having value 1123.90 would be displayed as $1,124.
- BThe LIST_PRICE column having value 1123.90 would be displayed as $1,123.
- CThe LIST_PRICE column having value 11235.90 would be displayed as $1,123.
- DThe LIST_PRICE column having value 11235.90 would be displayed as #######.
How the community answered
(32 responses)- A81% (26)
- B13% (4)
- C6% (2)
Community Discussion
No community discussion yet for this question.