Oracle 12cµÄOCP¿¼ÊÔ¿¼3¿Æ£¬·Ö±ðÊÇ071¡¢062¡¢063£¬¶ÔÓÚÕâЩ¿¼Ì⣬ÎÒÃÇרÃÅÓÐÈ˸ºÔðÊÕ¼¯ÕûÀí£¬²¢ÓÉרҵµÄÀÏʦ¶ÔÕâЩ¿¼Ìâ½øÐнâÎö£¬Ï£Íû¿ÉÒÔ°ïÖúÏ뿼OCPµÄͬѧ£¬ÕâÀ￪ʼ½éÉÜ071µÄÌâ¿â¡£

ÿÖÜÎåÍí8µã£¬ÎÒÃÇÓÐÃâ·ÑµÄOCP½âÎö¹«¿ª¿Î£¬µØÖ·£ºhttps://ke.qq.com/course/326223  OCPÌâ¿â½»Á÷Ⱥ£º1015267481£¬ÑéÖ¤ocp

-------------------------------------------------------

071¿¼ÊÔÌâ¿â-µÚ16Ìâ¡¢choose two

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

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;

Answer£ºBD

(½âÎö£ºAC Óï·¨²»¶Ô£¬Ö´ÐÐʱÏÔʾ ORA-00933: SQL ÃüÁîδÕýÈ·½áÊø

ÀàËƵÄÓï¾ä£º

1¡¢

select d.deptno,d.dname,e.empno,e.ename,e.sal

from emp e join dept d

on (e.deptno=d.deptno)

where sal < 3000;)

2¡¢

select d.deptno,d.dname,e.empno,e.ename,e.sal

from emp e join dept d

on (e.deptno=d.deptno) and sal < 3000;