ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 047-215

047-215

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-19 10:02:33 0 删除 编辑
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博客 ” ,链接:http://blog.itpub.net/11312660/viewspace-719006/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 047-207
下一篇: 047-218
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    213996