Oracle
1Z0-061 · Question #191
1Z0-061 Question #191: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-061 to reveal the answer and full explanation for question #191. The question stem and answer options stay visible for context.
Question
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?
Options
- ASELECT 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;
- CSELECT TO_CRAR(TO_NUMBER(prod_price.'S99.999.99')* .25.'$99.999.00') FROM
- DSELECT TO_NUMBER(TO_NUMBER(prod_price., $99.999.99')* .25/$99.999.00') FROM
Unlock 1Z0-061 to see the answer
You've previewed enough free 1Z0-061 questions. Unlock 1Z0-061 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.