Where can subqueries be used?（）A、field names in the SELECT statement B、the FROM clause in the SELECT statement C、the HAVING clause in the SELECT statementD、the GROUP BY clause in the SELECT statement E、the WHERE clause in only the SELECT statement F、the W

题目

Where can subqueries be used?（）

A、field names in the SELECT statement
B、the FROM clause in the SELECT statement
C、the HAVING clause in the SELECT statement
D、the GROUP BY clause in the SELECT statement
E、the WHERE clause in only the SELECT statement
F、the WHERE clause in SELECT as well as all DML statements

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

相似问题和答案

第1题：

Where's the boy? We can’t ________c找到) him．

正确答案：
32. find

第2题：

The Sahara can be described as______

A) a place of contrasts
B) a place where no one lives
C) an area where the winters are cold
D) an area that appeals to many tourists

答案：D

解析：

第3题：

---- Excuse me. Could you tell me ___________?

---- Yes, There is a video shop next to the tall building.

A. where can I buy some CDs B. where I can buy some CDs

C. when can I buy some CDs D. when I can buy some CDs

正确答案：B

第4题：

Can you tell me （）the galley is?

A、what
B、how
C、where

正确答案:C

第5题：

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

第6题：

Receptionist: Can I help you?

Customer: ______. Where do I pay my fees?

A、As you please

B、Yes, please

C、Thank you

D、Yes, you can

参考答案：B

第7题：

Which two statements about subqueries are true? （）

A、A single row subquery can retrieve data from only one table.
B、A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.
C、A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause.
D、A single row subquery can retrieve data from more than one table.
E、A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.
F、A multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.

正确答案:B,D

第8题：

A location where data can betemporarily stored．

A．Area

B．Disk

C．Buffer

D．File

正确答案：C
解析：缓冲区：临时存放数据之处。

第9题：

Which three statements about subqueries are true?（）

A、A single row subquery can retrieve only one column and one row.
B、A single row subquery can retrieve only one row but many columns.
C、A multiple row subquery can retrieve multiple rows and multiple columns.
D、A multiple row subquery can be compared by using the “>” operator.
E、A single row subquery can use the IN operator.
F、A multiple row subquery can use the “=” operator.

正确答案:B,C,E

第10题：

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 if the query uses a HAVING clause.
F、A HAVING clause CANNOT be used in subqueries.

正确答案:B,D

Where can subqueries

题目

相似问题和答案

更多相关问题

相关内容