1Z0-071 Web TestEngine demo

Viev the Exhibit and examine the structure of the PRODUCT INFORMATION and INVENTORIEStables.

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 where in QUANTITY ON HAND is lessthan five.

Which two SQL statements can accomplish the task? (Choose two)

Select all that apply.

• A

  SELECT product id, quantity on hand, supplier id FROM product information NATURAL JOIN
  inventories AND quantity .on hand < 5;

• B

  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;

• C

  SELECT i. product_id, i. quantity_on hand, pi. supplier id FROM product information pi JOIN inventories i USING (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)WHERE quantity on hand < 5;