多选题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 st

A subquery that defines a view cannot include the GROUP BY clause

A view that is created with the subquery having the DISTINCT keyword can be updated

A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated

A data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table

A single row subquery can retrieve data from only one table.

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.

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.

A single row subquery can retrieve data from more than one table.

A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.

A multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.

 One， two， three or four processors

 One， two， or three processors

 One， three， or four processors

 One， two or four processors

A single row subquery can retrieve only one column and one row.

A single row subquery can retrieve only one row but many columns.

A multiple row subquery can retrieve multiple rows and multiple columns.

A multiple row subquery can be compared by using the > operator.

A single row subquery can use the IN operator.

A multiple row subquery can use the = operator.

Subqueries can contain GROUP BY and ORDER BY clauses

Main query and subquery can get data from different tables

Main query and subquery must get data from the same tables

Subqueries can contain ORDER BY but not the GROUP BY clause

Only one column or expression can be compared between the main query and subquery

Multiple columns or expressions can be compared between the main query and subquery

A subquery can retrieve zero or more rows

Only two subqueries can be placed atone level

A subquery can be used only in SQL query statements

A subquery can appear on either side of a comparison operator

There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement

A WHERE clause can be used to restrict both rows and groups.

A WHERE clause can be used to restrict rows only.

A HAVING clause can be used to restrict both rows and groups.

A HAVING clause can be used to restrict groups only.

A WHERE clause CANNOT be used in a query of the query uses a HAVING clause.

A HAVING clause CANNOT be used in subqueries.

Both USING and ON clauses can be used for equijoins and nonequijoins

Amaximum of one pair of columns can be joined between two tables using the ON clause

The ON clause can be used to join tables on columns that have different names but compatible data types

The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause

=

LIKE

BETWEEN

NOT IN

IS

<>

Create groups of data

Sort data in a specific order

Convert data to a different format

Retrieve data based on an unknown condition

in the INTO clause of an INSERT statement

in the FROM clause of a SELECT statement

in the GROUP BY clause of a SELECT statement

in the WHERE clause of a SELECT statement

in the SET clause of an UPDATE statement

in the VALUES clause of an INSERT statement

A main query can have more than one subquery.

A subquery can have more than one main query.

The subquery and main query must retrieve data from the same table.

The subquery and main query can retrieve data from different tables.

Only one column or expression can be compared between the subquery and main query.

Multiple columns or expression can be compared between the subquery and main query.

A subquery should retrieve only one row.

A subquery can retrieve zero or more rows.

A subquery can be used only in SQL query statements.

Subqueries CANNOT be nested by more than two levels.

A subquery CANNOT be used in an SQL query statement that uses group functions.

When a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.

A single row subquery can retrieve data from only one table.

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.

A SQL query statement can display data from table B that is referred to in its subquery, without including B in its own FROM clause.

A single row subquery can retrieve data from more than one table.

A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.

A multiple-row subquery cannot be used in an INSERT statement to insert multiple rows at a time.