Oracle
1Z0-071 · Question #306
1Z0-071 Question #306: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #306. The question stem and answer options stay visible for context.
Question
The PRODUCT_INFORMATION table has a UNIT_PRICE column of data type NUMBER (8, 2). Evaluate this SQL statement: SELECT TO_CHAR(unit_price, `$9,999') FROM product_information; Which two statements are true about the output? (Choose two.)
Options
- AA row whose UNIT_PRICE column contains the value 1023.99 will be displayed as $1,024.
- BA row whose UNIT_PRICE column contains the value 10235.99 will be displayed as $1,0236.
- CA row whose UNIT_PRICE column contains the value 10235.99 will be displayed as #######.
- DA row whose UNIT_PRICE column contains the value 10235.99 will be displayed as $1,023.
- EA row whose UNIT_PRICE column contains the value 1023.99 will be displayed as $1,023.
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 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.