215. 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 where in QUANTITY_ON_HAND is less than five.

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

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

USING (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

ON (pi.product_id=i.product_id) WHERE 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) AND quantity_on_hand < 5;

Answer: CD

Eg:

1: select m.ename "Man",e.ename "Emp"

from emp m join emp e on m.emp_no=e.mgr_no where m.mgr_no=2;

2: select m.ename "Man",e.ename "Emp"

from emp m join emp e on m.emp_no=e.mgr_no and m.mgr_no=2;

ITPub博客

047-215