多选题Which two statements are true regarding the ORDER BY clause? （）AIt is executed first in the query executionBIt must be the last clause in the SELECT statementCIt cannot be used in a SELECT statement containing a HAVING clauseDYou cannot specify a colum

题目

多选题

Which two statements are true regarding the ORDER BY clause? （）

It is executed first in the query execution

It must be the last clause in the SELECT statement

It cannot be used in a SELECT statement containing a HAVING clause

You cannot specify a column name followed by an expression in this clause

You can specify a combination of numeric positions and column names in this clause

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

相似问题和答案

第1题：

Which two statements are true regarding L2TP? ()(Choose two.)

A. Tunnels are initiated by the LAC

B. Tunnels are initiated by the LNS

C. By default, subscriber authentication occurs on the LNS

D. By default, subscriber authentication occurs on the LAC

参考答案：A, C

第2题：

Which of the following statements is true regarding the VERSIONS BETWEEN clause？（）

A、 The VERSIONS BETWEEN clause may be used in DML statements.
B、 The VERSIONS BETWEEN clause may be used in DDL statements.
C、 The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.
D、 The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.

正确答案:C

第3题：

Which two statements are true regarding the default behavior of the ORDER BY clause? ()

A.Null values are left out of the sort.

B.Character values are displayed from Z to A

C.Date values are displayed with the earliest value first.

D.Null values are displayed last for descending sequences.

E.Numeric values are displayed with the lowest values first.

参考答案：C, E

第4题：

Which two statements are true regarding L2TP? （）(Choose two.)

A、Tunnels are initiated by the LAC
B、Tunnels are initiated by the LNS
C、By default, subscriber authentication occurs on the LNS
D、By default, subscriber authentication occurs on the LAC

正确答案:A,C

第5题：

Which statement is true regarding the INTERSECT operator?（）

A、It ignores NULL values
B、Reversing the order of the intersected tables alters the result
C、The names of columns in all SELECT statements must be identical
D、The number of columns and data types must be identical for all SELECT statements in the query

正确答案:D

第6题：

Which two statements are true regarding the USING clause in table joins?（）

A、It can be used to join a maximum of three tables
B、It can be used to restrict the number of columns used in a NATURAL join
C、It can be used to access data from tables through equijoins as well as nonequijoins
D、It can be used to join tables that have columns with the same name and compatible data types

正确答案:B,D

第7题：

Which two statements about views are true? （）

A、A view can be created as read only.
B、A view can be created as a join on two or more tables.
C、A view cannot have an ORDER BY clause in the SELECT statement.
D、A view cannot be created with a GROUP BY clause in the SELECT statement.
E、A view must have aliases defined for the column names in the SELECT statement.

正确答案:A,B

第8题：

Which two statements are true with regard to policy ordering? ()(Choose two.)

A. The last policy is the default policy, which allows all traffic.

B. The order of policies is not important.

C. New policies are placed at the end of the policy list.

D. The insert command can be used to change the order.

参考答案：C, D

第9题：

Which three statements are true regarding subqueries?（）

A、Subqueries can contain GROUP BY and ORDER BY clauses
B、Main query and subquery can get data from different tables
C、Main query and subquery must get data from the same tables
D、Subqueries can contain ORDER BY but not the GROUP BY clause
E、Only one column or expression can be compared between the main query and subquery
F、 Multiple columns or expressions can be compared between the main query and subquery

正确答案:A,B,E

第10题：

Which two statements are true regarding routing policy processing?（）

A、The Junos OS verifies the match criteria of each policy in order and performs the associated action when a match occurs.
B、Policies are evaluated from right to left as displayed in the Junos OS configuration file.
C、Polices are evaluated based on the order in which they are applied to a routing protocol.
D、Policy processing stops once the last statement in the policy is evaluated.

正确答案:A,C

Which two statements are true regarding the ORDER BY clause?

题目

相似问题和答案

更多相关问题

相关内容