Oracle
1Z0-047 · Question #7
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?
The correct answer is A. SELECT product_id, SYSDATE + warranty_period. See the full explanation below for the reasoning.
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;
How the community answered
(31 responses)- A74% (23)
- B13% (4)
- C3% (1)
- D10% (3)
Community Discussion
No community discussion yet for this question.
