Which SQL statement would you execute to fulfill this requirement?

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

You want to see the product names and the date of expiration of warranty for all the products, if the product is purchased today. The products that have no warranty should be displayed at the top and the products with maximum warranty period should be displayed at the bottom.
Which SQL statement would you execute to fulfill this requirement?
A. SELECT product_name, SYSDATE+warranty_period AS "Warranty expire date"
FROM product_information
ORDER BY SYSDATE-warranty_period
B. SELECT product_name, SYSDATE+warranty_period AS "Warranty expire date"
FROM product_information
ORDER BY SYSDATE+warranty_period
C. SELECT product_name, SYSDATE+warranty_period AS "Warranty expire date"
FROM product_information
ORDER BY SYSDATE
D. SELECT product_name, SYSDATE+warranty_period AS "Warranty expire date"
FROM product_information
WHERE warranty_period > SYSDATE

Download Printable PDF. VALID exam to help you PASS.

One thought on “Which SQL statement would you execute to fulfill this requirement?

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.