Oracle Database SQL 12c 1z0-071 Exam Practice Test 3

Question : 17 of 50

Marks: +1, -0

Examine the structure and data in the PRICE_LIST table:

You plan to give a discount of 25% on the product price and need to display the discount amount in the same format as the PROD_PRICE.
Which SQL statement would give the required result?

SELECT TO_CHAR (prod_price* .25, ‘$99,999.99’) FROM PRICE_LIST
SELECT TO_CHAR (TO_NUMBER(prod_price) * .25, ‘$99,999.00’) FROM PRICE_LIST
SELECT TO_CHAR (TO_NUMBER(prod_price, ‘ $99,999.99’) * . 25, ‘$ 99,999.00’) FROM PRICE_LIST
SELECT TO_NUMBER (TO_NUMBER(prod_price, ‘ $99,999.99’) * . 25, ‘$ 99,999.00’) FROM PRICE_LIST

Validate

Go to Question:

Prev Question

Next Question