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

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

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

071¿¼ÊÔÌâ¿â-µÚ44Ìâ¡¢choose all that apply

View the Exhibit and examine the details of the ORDER_ITEMS table.

Evaluate the following SQL statements:

Statement 1:

SELECT MAX(unit_price*quantity) "Maximum Order"

FROM order_items;

Statement 2:

SELECT MAX(unit_price*quantity) "Maximum Order"

FROM order_items

GROUP BY order_id;

Which statements are true regarding the output of these SQL statements? (Choose all that apply.)

A) Both statements would ignore NULL values for the UNIT_PRICE and QUANTITY columns.

B) Statement 1 would return only one row of output.

C) Both the statements would give the same output.

D) Statement 2 would return multiple rows of output.

E) Statement 1 would not return any row because the GROUP BY clause is missing.

Anser£ºABD

(½âÎö£º¶ÔÓÚ null Öµ£¬Oracle ¼ÆËãµÄʱºò½á¹ûΪ¿Õ£¬µ«ÊÇÔÚÇó×î´óÖµµÄʱºò£¬»áºöÂÔ)

SQL> select sal*comm from emp;

SAL*COMM

----------

480000

625000

1750000

¡­

SQL> select max(sal*comm) from emp;

MAX(SAL*COMM)

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

1750000