多选题Which three statements about subqueries are true?（）AA single row subquery can retrieve only one column and one row.BA single row subquery can retrieve only one row but many columns.CA multiple row subquery can retrieve multiple rows and multiple columns.DA multiple row subquery can be compared by using the “” operator.EA single row subquery can use the IN operator.FA multiple row subquery can use the “=” operator.
多选题
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.
参考解析
解析：
暂无解析
相关考题：
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 subqueryF、 Multiple columns or expressions can be compared between the main query and subquery
Which two statements about subqueries are true? （）A、A subquery should retrieve only one row.B、A subquery can retrieve zero or more rows.C、A subquery can be used only in SQL query statements.D、Subqueries CANNOT be nested by more than two levels.E、A subquery CANNOT be used in an SQL query statement that uses group functions.F、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.
Which three statements about subqueries are true? （）A、A main query can have more than one subquery.B、A subquery can have more than one main query.C、The subquery and main query must retrieve data from the same table.D、The subquery and main query can retrieve data from different tables.E、Only one column or expression can be compared between the subquery and main query.F、Multiple columns or expression can be compared between the subquery and main query.
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.
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.
Which two statements are true regarding subqueries? （）A、A subquery can retrieve zero or more rows B、Only two subqueries can be placed atone level C、A subquery can be used only in SQL query statements D、A subquery can appear on either side of a comparison operator E、There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement
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.
Which three statements are true regarding single-row functions？（）A、 They can accept only one argument.B、 They can be nested up to only two levels.C、 They can return multiple values of more than one data type.D、 They can be used in SELECT， WHERE， and ORDER BY clauses. E、 They can modify the data type of the argument that is referenced.F、 They can accept a column name， expression， variable name， or a user-supplied constant as arguments.
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 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 an INSERT statement to insert multiple rows at a time.
Which four are attributes of single row functions? （）A、cannot be nestedB、manipulate data itemsC、act on each row returnedD、return one result per rowE、accept only one argument and return only one valueF、accept arguments which can be a column or an expression
Which statement is true regarding subqueries?（）A、The LIKE operator cannot be used with single-row subqueries B、The NOT IN operator is equivalent to IS NULL with single-row subqueries C、=ANY and =ALL operators have the same functionality in multiple-row subqueries D、The NOT operator can be used with IN, ANY, and ALL operators in multiple-row subqueries
Which two statements are true regarding single row functions?（）A、They accept only a single argument B、They can be nested only to two levels C、Arguments can only be column values or constants D、They always return a single result row for every row of a queried table E、They can return a data type value different from the one that is referenced
多选题Which two statements are true regarding subqueries? （）AA subquery can retrieve zero or more rowsBOnly two subqueries can be placed atone levelCA subquery can be used only in SQL query statementsDA subquery can appear on either side of a comparison operatorEThere is no limit on the number of subquery levels in the WHERE clause of a SELECT statement
多选题Which three statements about subqueries are true? （）AA main query can have more than one subquery.BA subquery can have more than one main query.CThe subquery and main query must retrieve data from the same table.DThe subquery and main query can retrieve data from different tables.EOnly one column or expression can be compared between the subquery and main query.FMultiple columns or expression can be compared between the subquery and main query.
多选题Which two statements about subqueries are true? （）AA single row subquery can retrieve data from only one table.BA 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.CA 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.DA single row subquery can retrieve data from more than one table.EA single row subquery cannot be used in a condition where the LIKE operator is used for comparison.FA multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.
多选题Which two are true about aggregate functions? （）AYou can use aggregate functions in any clause of a SELECT statement.BYou can use aggregate functions only in the column list of the SELECT clause and in the WHERE clause of a SELECT statement.CYou can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.DYou can pass column names, expressions, constants, or functions as parameters to an aggregate function.EYou can use aggregate functions on a table, only by grouping the whole table as one single group.FYou cannot group the rows of a table by more than one column while using aggregate functions.
单选题Which statement is true regarding subqueries?（）AThe LIKE operator cannot be used with single-row subqueries BThe NOT IN operator is equivalent to IS NULL with single-row subqueries C=ANY and =ALL operators have the same functionality in multiple-row subqueries DThe NOT operator can be used with IN, ANY, and ALL operators in multiple-row subqueries
多选题Which two statements about subqueries are true? （）AA single row subquery can retrieve data from only one table.BA 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.CA SQL query statement can display data from table B that is referred to in its subquery, without including B in its own FROM clause.DA single row subquery can retrieve data from more than one table.EA single row subquery cannot be used in a condition where the LIKE operator is used for comparison.FA multiple-row subquery cannot be used in an INSERT statement to insert multiple rows at a time.
多选题Which four are attributes of single row functions? （）Acannot be nestedBmanipulate data itemsCact on each row returnedDreturn one result per rowEaccept only one argument and return only one valueFaccept arguments which can be a column or an expression
多选题Which two statements about subqueries are true? （）AA subquery should retrieve only one row.BA subquery can retrieve zero or more rows.CA subquery can be used only in SQL query statements.DSubqueries CANNOT be nested by more than two levels.EA subquery CANNOT be used in an SQL query statement that uses group functions.FWhen 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.
多选题Which two statements are true regarding single row functions?（）AThey accept only a single argumentBThey can be nested only to two levelsCArguments can only be column values or constantsDThey always return a single result row for every row of a queried tableEThey can return a data type value different from the one that is referenced
多选题Which three statements are true regarding single-row functions？（）AThey can accept only one argument.BThey can be nested up to only two levels.CThey can return multiple values of more than one data type.DThey can be used in SELECT， WHERE， and ORDER BY clauses.EThey can modify the data type of the argument that is referenced.FThey can accept a column name， expression， variable name， or a user-supplied constant as arguments.