Oracle
1Z0-071 · Question #116
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…
The correct answer is A. A row whose LIST_PRICE column contains value 11235.90 would be displayed as #######. C. A row whose LIST_PRICE column contains value 1123.90 would be displayed as $1,124. See the full explanation below for the reasoning.
Question
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.)
Exhibit
Options
- AA row whose LIST_PRICE column contains value 11235.90 would be displayed as #######.
- BA row whose LIST_PRICE column contains value 1123.90 would be displayed as $1,123.
- CA row whose LIST_PRICE column contains value 1123.90 would be displayed as $1,124.
- DA row whose LIST_PRICE column contains value 11235.90 would be displayed as $1,123.
How the community answered
(29 responses)- A79% (23)
- B7% (2)
- D14% (4)
Community Discussion
No community discussion yet for this question.