Oracle Database 12c: SQL Fundamentals — Question 16

Examine the structure and data in the PRIC E_LIST table: Name Null? Type
------------ ------------- -------------------
PROD_D NOT NULL NUMBER(3)
PROD_PRICE VARCHAR2(10)

PROD_ID PROD PRICE -
----------- ------------------------
100 $234.55
101 $6, 509.75
102 $1, 234
in the same format as the PROD_PRICE. Which SQL statement would give the required result?

Answer options

• A. SELECT TO_CHAR(prod_price* .25.'$99.999.99') FROM PRICEJLIST:
• B. . SELECT TO_CHAR(TO_NUMBER(prod_price)* .25.'$99.999.00') FROM PRICE_LIST;
• C. SELECT TO_CRAR(TO_NUMBER(prod_price.'S99.999.99')* .25.'$99.999.00') FROM PRICE_LIST:
• D. SELECT TO_NUMBER(TO_NUMBER(prod_price., $99.999.99')* .25/$99.999.00') FROM PRICE_LIST:

Correct answer: C

Explanation

Option C is the correct answer because it attempts to convert the PROD_PRICE to a number and then apply a 25% calculation, while also formatting it with the appropriate dollar format. The other options contain syntax errors or incorrect function usage that would prevent them from executing successfully.