Which SQL statement would you execute to display the expiration date of the warranty for a product?

Prev Question
Next Question

View the Exhibit and examine the description of the PRODUCT_INFORMATION table.

Exam 1Z0-047 - Which SQL statement would you execute to display the expiration date of the warranty for a product?

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;

Prev Question
Next Question

Leave a Reply

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