ocp 11g認證題庫詳解：1Z0-051-063題
最新學訊：近期OCP認證正在報名中，因考試人員較多請盡快報名獲取最近考試時間，報名費用請聯系在線老師，甲骨文官方認證，報名從速！
我要咨詢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排序可升序可降序。
