Oracle
1Z0-047 · Question #122
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
- DSELECT product_id, TO_YMINTERVAL(SYSDATE + warranty_period)
How the community answered
(39 responses)- A77% (30)
- B13% (5)
- C8% (3)
- D3% (1)
Community Discussion
No community discussion yet for this question.