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.

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

相似考题

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

3.Which two statements are true regarding the USING clause in table joins?（）A、It can be used to join a maximum of three tables B、It can be used to restrict the number of columns used in a NATURAL join C、It can be used to access data from tables through equijoins as well as nonequijoins D、It can be used to join tables that have columns with the same name and compatible data types

4.Which two are attributes of iSQL*Plus? （）A、iSQL*Plus commands cannot be abbreviated.B、iSQL*Plus commands are accessed from a browser.C、iSQL*Plus commands are used to manipulate data in tables.D、iSQL*Plus commands manipulate table definitions in the database.E、iSQL*Plus is the Oracle proprietary interface for executing SQL statements.

更多“Which iSQL*Plus feature can be used to replace values in the WHERE clause?() ”相关问题

  • 第1题：

    Which are iSQL*Plus commands? （）

    • A、INSERT
    • B、UPDATE
    • C、SELECT
    • D、DESCRIBE
    • E、DELETE
    • F、RENAME

    正确答案:D

  • 第2题：

    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.

    正确答案:B,D

  • 第3题：

    Which two statements are true regarding the USING and ON clauses in table joins?（）

    • A、Both USING and ON clauses can be used for equijoins and nonequijoins 
    • B、Amaximum of one pair of columns can be joined between two tables using the ON clause 
    • C、The ON clause can be used to join tables on columns that have different names but compatible data types 
    • D、The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause 

    正确答案:C,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


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

  • 第5题：

    单选题
    Which of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?（）
    A

    Unique

    B

    Check

    C

    Referential

    D

    Informational


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

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


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

  • 第7题：

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


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

  • 第9题：

    单选题
    Which are iSQL*Plus commands? （）
    A

    INSERT

    B

    UPDATE

    C

    SELECT

    D

    DESCRIBE

    E

    DELETE

    F

    RENAME


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

  • 第10题：

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


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

  • 第11题：

    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

  • 第12题：

    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 statement
    • D、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

    正确答案:B,C,F

  • 第13题：

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

    D

    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


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

  • 第14题：

    多选题
    Which two statements are true regarding the USING and ON clauses in table joins?（）
    A

    Both USING and ON clauses can be used for equijoins and nonequijoins

    B

    Amaximum of one pair of columns can be joined between two tables using the ON clause

    C

    The ON clause can be used to join tables on columns that have different names but compatible data types

    D

    The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause


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

  • 第15题：

    多选题
    Which two statements are true regarding the USING clause in table joins?（）
    A

    It can be used to join a maximum of three tables

    B

    It can be used to restrict the number of columns used in a NATURAL join

    C

    It can be used to access data from tables through equijoins as well as nonequijoins

    D

    It can be used to join tables that have columns with the same name and compatible data types


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

  • 第16题：

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

  • 第17题：

    多选题
    Which two are attributes of iSQL*Plus? （）
    A

    iSQL*Plus commands cannot be abbreviated.

    B

    iSQL*Plus commands are accessed from a browser.

    C

    iSQL*Plus commands are used to manipulate data in tables.

    D

    iSQL*Plus commands manipulate table definitions in the database.

    E

    iSQL*Plus is the Oracle proprietary interface for executing SQL statements.


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

  • 第18题：

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

  • 第19题：

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


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

相关内容