Which SQL statement would you execute?

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?

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_id, TO_YMINTERVAL(warranty_period) FROM
product_information;

C.
SELECT product_id, TO_YMINTERVAL(SYSDATE) + warranty_period FROM
product_information;

D.
SELECT product_id, TO_YMINTERVAL(SYSDATE + warranty_period) FROM
product_information;



Leave a Reply 1

Your email address will not be published. Required fields are marked *