ocp 11gÈÏÖ¤¿¼ÊÔÌ⣺1Z0-051-063Ì⣬ÍêÕûÌâ¿âÇëµã»÷ÕâÀïÁªÏµÀÏʦ×ÉѯÁ˽â

63. View the E xhibit and examine the structure of the PRODUCTS table.

You want to display only those product names with their list prices where the list price is at least double

the minimum price. The report should start with the product name having the maximum list price satisfying

this condition.

Evaluate the following SQL statement:

SQL>SELECT prod_name,prod_list_price

FROM products

WHERE prod_list_price >= 2 * prod_min_price

Which ORDER BY clauses can be added to the above SQL statement to get the correct output?

(Choose all that apply.)

A. ORDER BY prod_list_price DESC, prod_name;

B. ORDER BY (2*prod_min_price)DESC, prod_name;

C. ORDER BY prod_name, (2*prod_min_price)DESC;

D. ORDER BY prod_name DESC, prod_list_price DESC;

E. ORDER BY prod_list_price DESC, prod_name DESC;

Answer: AE

´ð°¸½âÎö£º

The report should start with the product name having the maximum list price satisfying this condition.

ÌâÒâÒªÇó°´ÕÕlist priceÓÉ´óµ½Ð¡¸½¼ÓÃû×ÖÀ´ÅÅÐò£¬¼´Ïȱ£Ö¤ prod_list_priceÊǽµÐòµÄºóÃæ°´ÕÕnameÀ´ÅÅÐò£¬prod_nameÅÅÐò¿ÉÉýÐò¿É½µÐò¡£