网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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.
参考答案
参考解析
解析：
暂无解析
更多 “单选题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.” 相关考题
考题
Which best describes an inline view? ()
A. a schema objectB. a subquery that can contain an ORDER BY clauseC. another name for a view that contains group functionsD. a subquery that is part of the FROM clause of another query
考题
In which four clauses can a subquery be used? ()
A. in the INTO clause of an INSERT statementB. in the FROM clause of a SELECT statementC. in the GROUP BY clause of a SELECT statementD. in the WHERE clause of a SELECT statementE. in the SET clause of an UPDATE statementF. in the VALUES clause of an INSERT statement
考题
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.
考题
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 clauseB. Before the WHERE clauseC. Before the FROM clauseD. After the ORDER BY clauseE. After the WHERE clause
考题
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.
考题
In which four clauses can a subquery be used?（）A、in the INTO clause of an INSERT statementB、in the FROM clause of a SELECT statementC、in the GROUP BY clause of a SELECT statementD、in the WHERE clause of a SELECT statementE、in the SET clause of an UPDATE statementF、in the VALUES clause of an INSERT 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.
考题
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
考题
Which best describes an inline view? （）A、a schema objectB、a subquery that can contain an ORDER BY clauseC、another name for a view that contains group functionsD、a subquery that is part of the FROM clause of another query
考题
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
考题
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.
考题
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 WHERE clause in SELECT as well as all DML statements
考题
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.
考题
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 clauseB、Before the WHERE clauseC、Before the FROM clauseD、After the ORDER BY clauseE、After the WHERE clause
考题
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.
考题
多选题Where can subqueries be used?（）Afield names in the SELECT statementBthe FROM clause in the SELECT statementCthe HAVING clause in the SELECT statementDthe GROUP BY clause in the SELECT statementEthe WHERE clause in only the SELECT statementFthe WHERE clause in SELECT as well as all DML statements
考题
单选题Which operator can be used with a multiple-row subquery?（）A
=B
LIKEC
BETWEEND
NOT INE
ISF
考题
多选题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.
考题
多选题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 statementFin the VALUES clause of an INSERT statement
考题
单选题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.
考题
单选题The EMP table contains these columns: LAST NAME VARCHAR2(25) SALARY NUMBER(6,2) DEPARTMENT_ID NUMBER(6) You need to display the employees who have not been assigned to any department. You write the SELECT statement: SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP WHERE DEPARMENT_ID = NULL; 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.
考题
单选题The EMP table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) DEPARTMENT_ID NUMBER (6) You need to display the employees who have not been assigned to any department. You write the SELECT statement: SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP WHERE DEPARTMENT_ID = NULL; 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.
考题
多选题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 best describes an inline view? （）A
a schema objectB
a subquery that can contain an ORDER BY clauseC
another name for a view that contains group functionsD
a subquery that is part of the FROM clause of another 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 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.
考题
单选题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 clauseB
Before the WHERE clauseC
Before the FROM clauseD
After the ORDER BY clauseE
After the WHERE clause
考题
多选题Which two statements are true about WHERE and HAVING clauses? （）AA WHERE clause can be used to restrict both rows and groups.BA WHERE clause can be used to restrict rows only.CA HAVING clause can be used to restrict both rows and groups.DA HAVING clause can be used to restrict groups only.EA WHERE clause CANNOT be used in a query of the query uses a HAVING clause.FA HAVING clause CANNOT be used in subqueries.
考题
单选题Exhibit: Examine the data in the EMPLOYEES table. Examine the subquery: SELECT last_name FROM employees WHERE salary IN (SELECT MAX(salary) FROM employees GROUP BY department_id); Which statement is true?（）A
The SELECT statement is syntactically accurate.B
The SELECT statement does not work because there is no HAVING clause.C
The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.D
The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.
热门标签
最新试卷
