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

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

相似考题

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

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

3.Which iSQL*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 iSQL*Plus.

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

参考答案和解析
正确答案： A
解析： 暂无解析
更多“单选题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 statement correctly describes SQL and /SQL*Plus?（）

    • A、Both SQL and /SQL*plus allow manipulation of values in the database.
    • B、/SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.
    • C、/SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.
    • D、/SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.

    正确答案:A

  • 第2题：

    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.

    正确答案:B,F

  • 第3题：

    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

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

    正确答案:A

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

  • 第6题：

    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.

    正确答案:C,E

  • 第7题：

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


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

  • 第8题：

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


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

  • 第9题：

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


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

  • 第10题：

    单选题
    Which statement correctly describes SQL and /SQL*Plus?（）
    A

    Both SQL and /SQL*plus allow manipulation of values in the database.

    B

    /SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.

    C

    /SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.

    D

    /SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.


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

  • 第11题：

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


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

  • 第12题：

    多选题
    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
    解析： 暂无解析

  • 第13题：

    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.

    正确答案:B,D

  • 第14题：

    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

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

  • 第16题：

    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

    正确答案:A

  • 第17题：

    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.

    正确答案:A

  • 第18题：

    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.

    正确答案:C,D

  • 第19题：

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


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

  • 第20题：

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


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

  • 第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 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
    解析： 暂无解析

  • 第22题：

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


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

  • 第23题：

    单选题
    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
    解析： 暂无解析

  • 第24题：

    多选题
    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
    解析： 暂无解析

相关内容