单选题You define a multiple-row subquery in the WHERE clause of an SQL query with a comparison operator "=".What happens when the main query is executed?（）A The main query executes with the first value returned by the subquery.B The main query executes with

题目
单选题
You define a multiple-row subquery in the WHERE clause of an SQL query with a comparison operator "=".What happens when the main query is executed?（）
A

The main query executes with the first value returned by the subquery.

B

The main query executes with the last value returned by the subquery.

C

The main query executes with all the values returned by the subquery.

D

The main query fails because the multiple-row subquery cannot be used with the comparison operator.

E

You cannot define a multiple-row subquery in the WHERE clause of a SQL query.

相似考题

1.You define a multiple－row subquery in the WHERE clause of an SQL query with a comparison operator "=". What happens when the main query is executed? ()A. The main query executes with the first value returned by the subquery.B. The main query executes with the last value returned by the subquery.C. The main query executes with all the values returned by the subquery.D. The main query fails because the multiple-row subquery cannot be used with the comparison operator.E. You cannot define a multiple-row subquery in the WHERE clause of a SQL query.

2.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

3.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.

4.Examine the data from the ORDERS and CUSTOMERS tables.Evaluate the SQL statement:What is the result when the query is executed?()A.B.C.D. The query fails because the subquery returns more than one row.E. The query fails because the outer query and the inner query are using different tables.

更多“单选题You define a multiple-row subquery in the WHERE clause of an SQL query with a comparison operator "=".What happens when the main query is executed?（）A The main query executes with the first value returned by the subquery.B The main query executes with ”相关问题

  • 第1题：

    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.

    正确答案:A,C,E

  • 第2题：

    You define a multiple-row subquery in the WHERE clause of an SQL query with a comparison operator "=". What happens when the main query is executed? （）

    • A、The main query executes with the first value returned by the subquery.
    • B、The main query executes with the last value returned by the subquery.
    • C、The main query executes with all the values returned by the subquery.
    • D、The main query fails because the multiple-row subquery cannot be used with the comparison operator.
    • E、You cannot define a multiple-row subquery in the WHERE clause of a SQL query.

    正确答案:D

  • 第3题：

    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

  • 第4题：

    What is true regarding subqueries?（）

    • A、The inner query always sorts the results of the outer query.
    • B、The outer query always sorts the results of the inner query.
    • C、The outer query must return a value to the inner query.
    • D、The inner query returns a value to the outer query.
    • E、The inner query must always return a value or the outer query will give an error.

    正确答案:D

  • 第5题：

    You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A SQL Server 2005 application is utilized by the company. A query is executed by the application to return three columns of the nvarchar data type and one column of the XML data type. A WHERE clause is utilized by the query， and all three of the nvarchar columns are contained by the WHERE clause. 5 million rows are included by the table， and 50，000 rows are returned by the query. The performance of the query should be enhanced. Which action should be performed to achieve the goal？（）

    • A、A primary XML index should be created on the XML column.
    • B、Statistics should be created on the nvarchar columns.
    • C、A view should be created， and only the four columns that the query utilizes are contained by a view.
    • D、A composite index should be created on the three nvarchar columns， and INCLUDE should be specified for the XML column.

    正确答案:D

  • 第6题：

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


    正确答案： E,B
    解析： 暂无解析

  • 第7题：

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


    正确答案： C,D
    解析： 暂无解析

  • 第8题：

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


    正确答案： F,A
    解析： 暂无解析

  • 第9题：

    单选题
    You define a multiple-row subquery in the WHERE clause of an SQL query with a comparison operator "=".What happens when the main query is executed?（）
    A

    The main query executes with the first value returned by the subquery.

    B

    The main query executes with the last value returned by the subquery.

    C

    The main query executes with all the values returned by the subquery.

    D

    The main query fails because the multiple-row subquery cannot be used with the comparison operator.

    E

    You cannot define a multiple-row subquery in the WHERE clause of a SQL query.


    正确答案： D
    解析： 暂无解析

  • 第10题：

    单选题
    EXHIBIT, Emp Table Exhibit A Exhibit B Examine the data from the EMP table. Evaluate this SQL statement: SELECT * FROM emp WHERE emp _ id = 3); WHERE commission = (SELECT commission FROM emp What is the result when the query is executed?（）
    A

    Exhibit A

    B

    Exhibit B 

    C

    The query returns no rows 

    D

    The query fails because the outer query is retrieving more than one column

    E

    The query fails because both the inner and outer queries are retrieving data from the same table.


    正确答案： C
    解析： 暂无解析

  • 第11题：

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


    正确答案： C,D
    解析： 暂无解析

  • 第12题：

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


    正确答案： B,D
    解析： 暂无解析

  • 第13题：

    What is true regarding subqueries?（）

    • A、The inner query always sorts the results of the outer query
    • B、The outer query always sorts the results of the inner query
    • C、The outer query must return a value to the outer query
    • D、The inner query returns a value to the outer query
    • E、The inner query must always return a value or the outer query will give an error

    正确答案:E

  • 第14题：

    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 

    正确答案:A,D

  • 第15题：

    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.

    正确答案:D,F

  • 第16题：

    You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005.You work as a database administrator for your company. You find a problem that when the following query is executed， a SQL Server 2005 application will perform slowly. SELECT * FROM Orders WHERE OrderStatus = ’InProgress’ This query is executed by the application as an ad hoc query. In most occasions， this query performs much more quickly. The company has the OrderStatus column indexed. The value InProgress is included by only a small number of the rows. Nevertheless， the OrderStatus column index which is the most ideal for this query is not being utilized. The performance of this query should be enhanced. However， the application that executes the query should not be changed. In addition， the effect on end users should be cut to the least.  Which action should be performed to finish the task？（）

    • A、To finish the task， the index should be built by utilizing a FILLFACTOR of 10 percent.
    • B、To finish the task， the index should be recreated to have all of the columns in the table included.
    • C、To finish the task， an indexed view of the Orders table should be viewed.
    • D、To finish the task， the statistics should be updated on the index.

    正确答案:D

  • 第17题：

    单选题
    You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005.You work as a database administrator for your company. You find a problem that when the following query is executed， a SQL Server 2005 application will perform slowly. SELECT * FROM Orders WHERE OrderStatus = ’InProgress’ This query is executed by the application as an ad hoc query. In most occasions， this query performs much more quickly. The company has the OrderStatus column indexed. The value InProgress is included by only a small number of the rows. Nevertheless， the OrderStatus column index which is the most ideal for this query is not being utilized. The performance of this query should be enhanced. However， the application that executes the query should not be changed. In addition， the effect on end users should be cut to the least.  Which action should be performed to finish the task？（）
    A

    To finish the task， the index should be built by utilizing a FILLFACTOR of 10 percent.

    B

    To finish the task， the index should be recreated to have all of the columns in the table included.

    C

    To finish the task， an indexed view of the Orders table should be viewed.

    D

    To finish the task， the statistics should be updated on the index.


    正确答案： D
    解析： 暂无解析

  • 第18题：

    单选题
    You are creating an online catalog application that will display product information on the company Web site. The product data is stored in a SQL Server 2005 database. The data is stored as relational data but must be passed to the application as an XML document by using FOR XML. You test your application and notice that not all of the items matching your query appear in the XML document. Only those products that have values for all elements in the schema appear.   You need to modify your Transact-SQL statement so that all products matching your query appear in the XML document. What should you do？（）
    A

    Add an XML index to the table that contains the product data.

    B

    Add the XSINIL argument to the ELEMENTS directive in the query.

    C

    Add a HAVING clause to the query.

    D

    Add the replace value of clause to the query.


    正确答案： D
    解析： 暂无解析

  • 第19题：

    单选题
    You are using the Database Resource Manager to manage database resources. You created a resource plan directive for the MANAGERS resource consumer group under the SALES_PLAN by using the following statement：   SQL>EXEC DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE   （PLAN => ’SALES_PLAN’，   GROUP_OR_SUBPLAN => ’MANAGERS’，   CPU_P1 => 100， CPU_P2 =>0，   SWITCH_GROUP => ’CLERKS’，   SWITCH_TIME_IN_CALL => 600）；   A user， SCOTT， who is assigned to the MANAGERS group， starts a database session and executes a query on the database. What is the outcome if the query takes approximately 15 minutes to complete？（）
    A

     The query starts under the CLERKS group and the user， SCOTT， switches back to the MANAGERS group after the query completes.

    B

     The query starts under the MANAGERS group but terminates with an error when the execution time exceeds 10 minutes.

    C

     The query starts under the MANAGERS group and switches automatically to the CLERKS group when the execution time exceeds 10 minutes. The query does not switch back to the MANAGERS group after the query completes.

    D

     The query starts under the MANAGERS group， the user SCOTT switches automatically to the CLERKS group when the execution time exceeds 10 minutes， and then switches back to the MANAGERS group after the query completes.


    正确答案： C
    解析： 暂无解析

  • 第20题：

    单选题
    What is true regarding subqueries?（）
    A

    The inner query always sorts the results of the outer query.

    B

    The outer query always sorts the results of the inner query.

    C

    The outer query must return a value to the inner query.

    D

    The inner query returns a value to the outer query.

    E

    The inner query must always return a value or the outer query will give an error.


    正确答案： D
    解析： 暂无解析

  • 第21题：

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


    正确答案： A,F
    解析： 暂无解析

  • 第22题：

    多选题
    Which two statements are true regarding the execution of the correlated subqueries？（）
    A

    The nested query executes after the outer query returns the row.

    B

    The nested query executes first and then the outer query executes.

    C

    The outer query executes only once for the result returned by the inner query.

    D

    Each row returned by the outer query is evaluated for the results returned by the inner query.


    正确答案： C,B
    解析： 暂无解析

  • 第23题：

    单选题
    You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A SQL Server 2005 application is utilized by the company. A query is executed by the application to return three columns of the nvarchar data type and one column of the XML data type. A WHERE clause is utilized by the query， and all three of the nvarchar columns are contained by the WHERE clause. 5 million rows are included by the table， and 50，000 rows are returned by the query. The performance of the query should be enhanced. Which action should be performed to achieve the goal？（）
    A

    A primary XML index should be created on the XML column.

    B

    Statistics should be created on the nvarchar columns.

    C

    A view should be created， and only the four columns that the query utilizes are contained by a view.

    D

    A composite index should be created on the three nvarchar columns， and INCLUDE should be specified for the XML column.


    正确答案： D
    解析： 暂无解析

  • 第24题：

    单选题
    What is true regarding subqueries?（）
    A

    The inner query always sorts the results of the outer query

    B

    The outer query always sorts the results of the inner query

    C

    The outer query must return a value to the outer query

    D

    The inner query returns a value to the outer query

    E

    The inner query must always return a value or the outer query will give an error


    正确答案： C
    解析： 暂无解析

相关内容