ExamQuestions.com

Register
Login
Oracle Datbase 12c SQL Exam Questions

Oracle

Oracle Datbase 12c SQL

98 / 120

Question 98:

View the Exhibit and examine the details of the PRODUCT_INFORMATION table. 
image
Evaluate this SQL statement: SELECT TO_CHAR (list_price, `$9,999`) From product_information; Which two statements are true regarding the output? (Choose two.) 

Answer options:

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