单选题Which /SQL*Plus feature can be used to replace values in the WHERE clause?（）A Substitution variablesB Replacement variablesC Prompt variablesD Instead-of variablesE This feature cannot be implemented through /SQL*Plus

第1题：

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 of the query uses a HAVING clause.
• F、A HAVING clause CANNOT be used in subqueries.

第2题：

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

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

第4题：

Which /SQL*Plus feature can be used to replace values in the WHERE clause?（）

• A、Substitution variables
• B、Replacement variables
• C、Prompt variables
• D、Instead-of variables
• E、This feature cannot be implemented through /SQL*Plus

第5题：

Which iSQL*Plus feature can be used to replace values in the WHERE clause?（）

• A、substitution variables
• B、replacement variables
• C、prompt variables
• D、instead-of variables
• E、This feature cannot be implemented through iSQL*Plus.

第6题：

Which two are attributes of /SQL*Plus? （）

• A、/SQL*Plus commands cannot be abbreviated.
• B、/SQL*Plus commands are accesses from a browser.
• C、/SQL*Plus commands are used to manipulate data in tables.
• D、/SQL*Plus commands manipulate table definitions in the database.
• E、/SQL*Plus is the Oracle proprietary interface for executing SQL statements.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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.

第14题：

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.

第15题：

Which /SQL*Plus feature can be used to replace values in the WHERE clause?（）

• A、Substitution variables
• B、Replacement variables
• C、Prompt variables
• D、Instead-of variables
• E、This feature cannot be implemented through /SQL*Plus.

第16题：

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.

第17题：

Which two are attributes of iSQL*Plus? （）

• A、/SQL*Plus commands cannot be abbreviated.
• B、/SQL*Plus commands are accessed from a browser.
• C、/SQL*Plus commands are used to manipulate data in tables.
• D、/SQL*Plus commands manipulate table definitions in the database.
• E、/SQL*Plus is the Oracle proprietary interface for executing SQL statements.

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：