Oracle
1Z0-047 · Question #7
1Z0-047 Question #7: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-047 to reveal the answer and full explanation for question #7. The question stem and answer options stay visible for context.
Question
View the Exhibit and examine the description of the PRODUCT_INFORMATION table. You want to display the expiration date of the warranty for a product. Which SQL statement would you execute?
Exhibit
Options
- ASELECT product_id, SYSDATE + warranty_period
- BSELECT product_id, TO_YMINTERVAL(warranty_period)
- CSELECT product_id, TO_YMINTERVAL(SYSDATE) + warranty_period FROM product_information;
- DSELECT product_id, TO_YMINTERVAL(SYSDATE + warranty_period) FROM product_information;
Unlock 1Z0-047 to see the answer
You've previewed enough free 1Z0-047 questions. Unlock 1Z0-047 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.