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

You define a multiple-row subquery in the WHERE clause of an

题目
单选题
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.


参考答案：D

第2题：

The EMP table contains these columns:You need to display the employees who have not been assigned to any department.You write the SELECT statement:What is true about this SQL statement?()

A. The SQL statement displays the desired results.

B. The column in the WHERE clause should be changed to display the desired results.

C. The operator in the WHERE clause should be changed to display the desired results.

D. The WHERE clause should be changed to use an outer join to display the desired results.


参考答案：C

第3题：

Which best describes an inline view? ()

A. a schema object

B. a subquery that can contain an ORDER BY clause

C. another name for a view that contains group functions

D. a subquery that is part of the FROM clause of another query


参考答案：D

第4题：

Which best describes an inline view? （）

  • A、a schema object
  • B、a subquery that can contain an ORDER BY clause
  • C、another name for a view that contains group functions
  • D、a subquery that is part of the FROM clause of another query

正确答案:D

第5题：

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

第6题：

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

第7题：

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

正确答案:A,B,D,E

第8题：

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

第9题：

The accounts receivable department requested an accounts status to allow users to enter either a customer name, customer number, customer phone number and then display the customer out standing balance. You want to restrict the data retrieved based on values entered by the users. Which where clause would you write in the query to select statement to accomplish this task?（）

  • A、&p_where_clause 
  • B、:p_where_clause 
  • C、WHERE CUST_ID=P_CUST_ID or cust_name=:p_cust_name or cust_phone=:p_cust_phone 
  • D、Where cust_ID=&p_custid cust_name=&p_cust_name or cust_phone=&p_cust_phone

正确答案:A

第10题：

Which two statements are true regarding views?（）

  • A、A subquery that defines a view cannot include the GROUP BY clause 
  • B、A view that is created with the subquery having the DISTINCT keyword can be updated 
  • C、A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated 
  • D、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

正确答案:C,D

更多相关问题
相关内容