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、T

题目

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.

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

The EMPLOYEES table contains these columns:You need to write a query that will produce these results:1. Display the salary multiplied by the commission_pct.2. Exclude employees with a zero commission_pct.3. Display a zero for employees with a null commission value.Evaluate the SQL statement:What does the statement provide?（）

A. All of the desired results

B. Two of the desired results

C. One of the desired results

D. An error statement

参考答案：C

第2题：

Evaluate these two SQL statements: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

第3题：

Which two are attributes of ／SQL*Plus? ()

A. /SQL*Plus commands cannot be abbreviated.

B. /SQL*Plus commands are accesses from a browser.

C. /SQL*Plus commands are used to manipulate data in tables.

D. /SQL*Plus commands manipulate table definitions in the database.

E. /SQL*Plus is the Oracle proprietary interface for executing SQL statements.

参考答案：C, D

第4题：

By default, which two statements are true about export routing policies?（）

A、Export policies can evaluate only active routes.
B、Export policies can evaluate all routes.
C、Export policies can be applied to the forwarding table.
D、Export policies can be applied directly to interfaces

正确答案:A,C

第5题：

Examine the structure of the EMPLOYEES and DEPARTMENTS tables:Evaluate this SQL statement:Which SQL statement is equivalent to the above SQL statement?()

参考答案：C

第6题：

Evaluate this SQL statement:In the statement, which capabilities of a SELECT statement are performed?()

A. Selection, projection, join

B. Difference, projection, join

C. Selection, intersection, join

D. Intersection, projection, join

E. Difference, projection, product

参考答案：A

第7题：

Evaluate the SQL statement:What will be displayed?()

A. 0

B. 1

C. 0.00

D. An error statement

参考答案：A

第8题：

Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.()

A. Cursor cache

B. Stored outline

C. SQL Tuning Set

D. Automatic Workload Repository (AWR) snapshots

参考答案：A, C

第9题：

By default, which two statements are true about export routing polices?()

A. Export polices can evaluate only active routes

B. Export polices can evaluate all routes

C. Export polices can be applied to the forwarding table

D. Export polices can be applied to interfaces

参考答案：A, C

第10题：

Which two statements about the SQL Management Base (SMB) are true? （）(Choose two.)

A、It contains only SQL profiles generated by SQL Tuning Advisor.
B、It stores plans generated by the optimizer using a stored outline.
C、It is part of the data dictionary and stored in the SYSAUX tablespace.
D、It is part of the data dictionary and stored in the SYSTEM tablespace.
E、It contains the statement log, the plan history, plan baselines, and SQL profiles.

正确答案:C,E

Evaluate these two SQL statemen

题目

相似问题和答案

更多相关问题

相关内容