View the Exhibit and examine the description of the PRODUCT_INFORMATION table.You want to display the expiration date of
Posted: Wed Jun 07, 2023 6:11 am
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;
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;