问题

Evaluate these two SQL statements: SE

Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary, hire_date FROM EMPLOYEES 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.

参考答案

参考解析：

分类：1Z0-007题库

相关推荐

1、Evaluate the SQL statement: What is

Evaluate the SQL statement:What is the result of the statement?（）A The statement produces an error at line 1.B The statement produces an erro...

2、Evaluate this SQL statement: In the

Evaluate this SQL statement:In the statement, which capabilities of a SELECT statement are performed?（）A Selection, projection, joinB Difference,...

3、Evaluate these two SQL statements: W

Evaluate these two SQL statements:What is true about them?（）A The two statements produce identical results.B The second statement returns a syn...

4、Evaluate the SQL statement DROP TABLE

Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? （）A You cannot roll back this statement.B A...

5、Evaluate this SQL statement: SELECT e.

Evaluate this SQL statement: SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME FROM EMP e, DEPARTMENT d WHERE e.DEPARTMENT_ID = d.DE...

6、Evaluate the SQL statement: What wil

Evaluate the SQL statement:What will be displayed?（）A 0B 1C 0.00D An error statement

编辑推荐

原子吸收法测定Ca2+含量时，为消除其中PO43-的干扰而加入高浓.....

下降速度应缓慢，禁止在带负荷的情况下使其（）。..

部队对从高校毕业生士兵中选取士官是如何规定的？..

专业技术人员学习积累专业技术岗位工作经验的途径有哪些原则.....

（）是卖方无需在包装箱相邻的四面做出的标记。..

根据民事诉讼法及相关规定，下列关于财产保全的说法哪些是正.....