违法和不良信息举报 联系客服
免费注册 登录

多选题In which four clauses can a subquery be used?（）Ain the INTO clause of an INSERT statementBin the FROM clause of a SELECT statementCin the GROUP BY clause of a SELECT statementDin the WHERE clause of a SELECT statementEin the SET clause of an UPDATE sta

题目
多选题
In which four clauses can a subquery be used?（）
A

in the INTO clause of an INSERT statement

B

in the FROM clause of a SELECT statement

C

in the GROUP BY clause of a SELECT statement

D

in the WHERE clause of a SELECT statement

E

in the SET clause of an UPDATE statement

F

in the VALUES clause of an INSERT statement

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

第1题：

Exhibit:Examine the data in the EMPLOYEES table.Examine the subquery:SELECT last_nameFROM employeesWHERE salary IN (SELECT MAX(salary)FROM employeesGROUP BY department_id);Which statement is true?()

A. The SELECT statement is syntactically accurate.

B. The SELECT statement does not work because there is no HAVING clause.

C. The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.

D. The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.


参考答案：A

第2题：

In which of the following situations should correlation names be used?()

A.A table referenced in the FROM clause has no indexed column.

B.The table referenced in the FROM clause has more than 200 columns.

C.Two or more tables in the FROM clause have identical column names.

D.The FROM clause contains two or more tables in the SELECT statement.


参考答案：C

第3题：

In which four clauses can a subquery be used? ()

A. in the INTO clause of an INSERT statement

B. in the FROM clause of a SELECT statement

C. in the GROUP BY clause of a SELECT statement

D. in the WHERE clause of a SELECT statement

E. in the SET clause of an UPDATE statement

F. in the VALUES clause of an INSERT statement


参考答案：B, D, E, F

第4题：

Which two statements are true about WHERE and HAVING clauses? （）

  • A、A WHERE clause can be used to restrict both rows and groups.
  • B、A WHERE clause can be used to restrict rows only.
  • C、A HAVING clause can be used to restrict both rows and groups.
  • D、A HAVING clause can be used to restrict groups only.
  • E、A WHERE clause CANNOT be used in a query of the query uses a HAVING clause.
  • F、A HAVING clause CANNOT be used in subqueries.

正确答案:B,D

第5题：

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

  • A、The sort is in ascending by order by default.
  • B、The sort is in descending order by default.
  • C、The ORDER BY clause must precede the WHERE clause.
  • D、The ORDER BY clause is executed on the client side.
  • E、The ORDER BY clause comes last in the SELECT statement.
  • F、The ORDER BY clause is executed first in the query execution.

正确答案:A,E

第6题：

Click the Exhibit button and examine the data in the EMPLOYEES table.Examine the subquery:SELECT last_nameFROM employeesWHERE salary IN (SELECT MAX(salary)FROM employeesGROUP BY department_id);Which statement is true?（）

A.The SELECT statement is syntactically accurate.

B.The SELECT statement does not work because there is no HAVING clause.

C.The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.

D.The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.


参考答案：A

第7题：

In which of the following situations should correlation names be used?（）

  • A、A table referenced in the FROM clause has no indexed column.
  • B、The table referenced in the FROM clause has more than 200 columns.
  • C、Two or more tables in the FROM clause have identical column names.
  • D、The FROM clause contains two or more tables in the SELECT statement.

正确答案:C

第8题：

In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed in the SELECT statement? ()

A. Immediately after the SELECT clause

B. Before the WHERE clause

C. Before the FROM clause

D. After the ORDER BY clause

E. After the WHERE clause


参考答案：E

第9题：

In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed in the SELECT statement?（）

  • A、Immediately after the SELECT clause
  • B、Before the WHERE clause
  • C、Before the FROM clause
  • D、After the ORDER BY clause
  • E、After the WHERE clause

正确答案:E

第10题：

Which two are true about aggregate functions? （）

  • A、You can use aggregate functions in any clause of a SELECT statement.
  • B、You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.
  • C、You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.
  • D、You can pass column names, expressions, constants, or functions as parameter to an aggregate function.
  • E、You can use aggregate functions on a table, only by grouping the whole table as one single group.
  • F、You cannot group the rows of a table by more than one column while using aggregate functions.

正确答案:A,D

更多相关问题
相关内容