In order to ma

按照姓名升序序排列( )

A.ORDER BY NAME ASC

B.ORDER BY ASC NAME

C.ORDER BY NAME DESC

D.ORDER BY DESC NAME

The ORDERS table has these columns:ORDER_ID NUMBER(4) NOT NULLCUSTOMER_ID NUMBER(12) NOT NULLORDER_TOTAL NUMBER(10,2)The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs.Which two statements retrieve orders with an inclusive total that ranges between 100.00 and 2000.00 dollars? （）

A. SELECT customer_id, order_id, order_total FROM orders RANGE ON order _ total (100 AND 2000) INCLUSIVE;

B. SELECT customer_id, order_id, order_total FROM orders HAVING order _ total BETWEEN 100 and 2000;

C. SELECT customer_id, order_id, order_total FROM orders WHERE order _ total BETWEEN 100 and 2000;

D. SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and <= 2000;

E. SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and order_total <= 2000;

设有订单表order(其中包含字段：订单号，客户号，职员号，签订日期，金额)，查询2007年所签订单的信息，并按金额降序排序，正确的SQL命令是( )。

A．SELECT * FROM order WHERE YEAR(签订日期)=2007 ORDER BY 金额 DESC

B．SELECT * FROM order WHILE YEAR(签订日期)=2007 ORDER BY 金额 ASC

C．SELECT * FROM order WHERE YEAR(签订日期)=2007 ORDER BY 金额 ASC

D．SELECT * FROM order WHILE YEAR(签订日期)=2007 ORDER BY 金额 DESC

A.in order to

B.in order for

C.in order that

A.onlythelow-order23bitsoftheMACaddressareusedtomapIPaddresses

B.onlythelow-order24bitsoftheMACaddressareusedtomapIPaddresses

C.onlythehigh-order23bitsoftheMACaddressareusedtomapIPaddresses

D.onlythelow-order23bitsoftheIPaddressareusedtomapMACaddresses

E.the0x01004fMACaddressprefixisusedformappingIPaddressestoMACaddresses

F.the0x01005eMACaddressprefixisusedformappingIPaddressestoMACaddresses

按照姓名降序排列( )

A.ORDER BY DESC NAME

B.ORDER BY NAME DESC

C.ORDER BY NAME ASC

D.ORDER BY ASC NAME