Which two SQL statements can accomplish the task?

View the Exhibit and examine the structure of the PRODUCT_INFORMATION and INVENTORIES tables.

You have a requirement from the supplies department to give a list containing PRODUCT_ID, SUPPLIER_ID, and QUANTITY_ON_HAND for all the products wherein QUANTITY_ON_HAND is less than five. Which two SQL statements can accomplish the task? (Choose two.)
A. SELECT i.product_id, i.quantity_on_hand, pi.supplier_id
FROM product_information pi JOIN inventories i
ON (pi.product_id=i.product_id)
WHERE quantity_on_hand < 5;
B. SELECT product_id, quantity_on_hand, supplier_id FROM product_information
NATURAL JOIN inventories AND quantity_on_hand < 5;
C. SELECT i.product_id, i.quantity_on_hand, pi.supplier_id FROM product_information pi JOIN inventories i
ON (pi.product_id=i.product_id) AND quantity_on_hand < 5;
D. SELECT i.product_id, i.quantity_on_hand, pi.supplier_id
FROM product_information pi JOIN inventories i
ON (pi.product_id=i.product_id)
USING (product_id) AND quantity_on_hand < 5;

Download Printable PDF. VALID exam to help you PASS.

Leave a Reply

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


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