单选题The order of name resolution can be controlled.   The default is：   1.DNS/BIND   2.NIS  3./etc/hosts   To change the order of the above name resolutions， which of the following should be used？（）A nslookupB hostnameC /etc/host.equivD environment variabl

用途：

指定需返回数据的范围

语法：

SELECT column_name FROM table_name

WHERE column_name

BETWEEN value1 AND value2

Order by

用途：

指定结果集的排序

语法：

SELECT column-name(s)FROM table-name ORDER BY{order_by_expression[ASC|DESC

13.

A. a schema object

B. a subquery that can contain an ORDER BY clause

C. another name for a view that contains group functions

D. a subquery that is part of the FROM clause of another query

按照姓名降序排列( )

A.ORDER BY DESC NAME

B.ORDER BY NAME DESC

C.ORDER BY NAME ASC

D.ORDER BY ASC NAME

Evaluate these two SQL statements: SELECT last_name, salary, hire_dateFROM EMPLOYEES ORDRE BY salary DESC; SELECT last_name, salary, hire_dateFROM EMPOLYEES ORDER BY 2 DESC; What is true about them? （）

A. The two statements produce identical results.

B. The second statement returns a syntax error.

C. There is no need to specify DESC because the results are sorted in descending order by default.

D. The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.

按照姓名升序序排列( )

A.ORDER BY NAME ASC

B.ORDER BY ASC NAME

C.ORDER BY NAME DESC

D.ORDER BY DESC NAME