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?
A.
SELECT product_id, SYSDATE + warranty_period
FROM product_information;
B.
SELECT product_jd, TO_YMINTERVAL(warranty_period)
FROM product_information;
C.
SELECT product_id, TO_YMINTERVAL(SYSDATE) + warranty_period
FROM product_information;
D.
SELECT product_jd, TO_YMINTERVAL(SYSDATE + warranty_period)
FROM product_information;