ocp 11gÈÏÖ¤Ìâ¿â´óÈ«£º1Z0-051-116Ì⣬ÍêÕûÌâ¿âÇëµã»÷ÕâÀïÁªÏµÀÏʦ×ÉѯÁ˽â

116. Examine the data in the ORD_ITEMS table:

ORD_NO ITEM_NO QTY

1 111 10

1 222 20

1 333 30

2 333 30

2 444 40

3 111 40

You want to find out if there is any item in the table for which the average maximum quantity is more than

50.

You issue the following query:

SQL> SELECT AVG(MAX(qty))

FROM ord_items

GROUP BY item_no

HAVING AVG(MAX(qty))>50;

Which statement is true regarding the outcome of this query?

A. It executes successfully and gives the correct output.

B. It gives an error because the HAVING clause is not valid.

C. It executes successfully but does not give the correct output.

D. It gives an error because the GROUP BY expression is not valid.

Answer: B

ÊÔÌâ½âÎö£º

HAVING×Ó¾äºóÃæ²»ÄÜÓкü¸¸ö×麯ÊýǶÌ×£¬Ö»ÄÜʹÓÃÒ»¸ö×麯Êý¡£