[单选]
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.

A customer wants to have employees work from remote locations as well as in the office. All communications must be secure and files must be protected from access by unauthorized people. The employee’s applications （database inserts and reads） are only accessed with a web browser. Which of the following capabilities is necessary？（） SSL。 PGP。 File encryption program。 Public key encryptio。无形资产能存在于其载体的前提是（）。能带来正常的利润。能带来超额利润。能带来垄断利润。能带来潜在利润。 A banking customer deployed an IBM BladeCenter chassis with one Brocade 8Gb SAN switch module. The customer requires an 8Gb uplink or higher. Which configuration will meet this request?（） Brocade Enterprise 20-port 8Gb SAN switch module 。 Brocade 20-port 8Gb SAN switch module and Brocade Advanced Performance Monitoring for IBM BladeCenter share 。 Brocade Enterprise 10-port 8Gb SAN switch module 。 Brocade 10-port 8Gb SAN switch module and Brocade Advanced Performance Monitoring for IBM BladeCenter。幼儿园公共关系是一种管理职能，在幼儿园工作中发挥着内促团结、外求发展的重要作用，幼儿园公共关系的核心是幼儿园与（）的关系。与教职工。与家长。与社区。与姊妹园。 You work as a database administrator for Supportcenter.cn. Users in the SupportCenter PROD database complain about the slow response when accessing the database. In the Active Session Waiting： Configuration page you find that the majority of the wait time is for the redo log buffer. Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks， and that the disk I/O for the redo log files is the reason for the performance degradation. Which two actions would you take to gain performance？（） Increase the size of redo log files。 Increase the size of redo log buffer。 Increase the number of redo log files。 Place the redo log files on a separate disk。 Decrease the number of redo log groups to two。 Increate the number Log Writer （LGWR） proce。

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? （）

参考答案：

● 参考解析

本题暂无解析

当前位置：1Z0-007题库

[单选] 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? （）

相关题目:

[单选]
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? （）