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

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


相似考题
更多“单选题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 s”相关问题
  • 第1题:

    在Oracle中,()是一个基于Web的SQL*Plus工具,能够在网页中执行SQL*Plus命令。

    • A、SQL*Plus
    • B、iSQL*Plus
    • C、PL*SQL
    • D、iPL*SQL

    正确答案:B

  • 第2题:

    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

  • 第3题:

    Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?()

    • A、SQL Repair Advisor
    • B、SQL Optimizer
    • C、SQL Access Advisor
    • D、SQL Tuning Advisor

    正确答案:D

  • 第4题:

    关于SQL*PLUS的叙述正确的是()

    • A、SQL*PLUS是ORACLE数据库的专用访问工具
    • B、SQL*PLUS是标准的SQL访问工具,可以访问各类关系型数据库
    • C、SQL*PLUS是所有ORACLE应用程序的底层API
    • D、SQL*PLUS是访问ORACLE数据库的唯一对外接口
    • E、以上所述都不正确

    正确答案:A

  • 第5题:

    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

  • 第6题:

    下列关于PL/SQL的说法正确的是()

    • A、PL/SQL是应用于各种数据库上的通用语言
    • B、PL/SQL是过程化的SQL语言
    • C、PL/SQL是只能在SQL*PLUS中运行
    • D、在PL/SQL可以直接执行所有的SQL操作

    正确答案:B

  • 第7题:

    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

  • 第8题:

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

  • 第9题:

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

  • 第10题:

    单选题
    Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?()
    A

     SQL Repair Advisor

    B

     SQL Optimizer

    C

     SQL Access Advisor

    D

     SQL Tuning Advisor


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

  • 第11题:

    单选题
    下列关于PL/SQL的说法正确的是()
    A

    PL/SQL是应用于各种数据库上的通用语言

    B

    PL/SQL是过程化的SQL语言

    C

    PL/SQL是只能在SQL*PLUS中运行

    D

    在PL/SQL可以直接执行所有的SQL操作


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

  • 第12题:

    单选题
    在Oracle中,()是一个基于Web的SQL*Plus工具,能够在网页中执行SQL*Plus命令。
    A

    SQL*Plus

    B

    iSQL*Plus

    C

    PL*SQL

    D

    iPL*SQL


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

  • 第13题:

    在Oracle数据库中,以下哪个语句可以在SQL*Plus中执行emp_rec.sql脚本?()

    • A、&emp_rec.sql
    • B、@emp_rec.sql
    • C、GETemp_rec.sql
    • D、SAVEemp_rec.sql

    正确答案:B

  • 第14题:

    Which is an /SQL*Plus command? ()

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

    正确答案:D

  • 第15题:

    在命令行中启动SQL*Plus,使用如下()命令。

    • A、SQLPLUS
    • B、SQL*PLUS
    • C、SQL
    • D、SPLUS

    正确答案:A

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

  • 第18题:

    同一台机器上,一个SQL*Plus可以使用另一个SQL*Plus定义的宿主变量。


    正确答案:错误

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


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

  • 第20题:

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

  • 第21题:

    多选题
    Which are /SQL*Plus commands? ()
    A

    INSERT

    B

    UPDATE

    C

    SELECT

    D

    DESCRIBE

    E

    DELETE

    F

    RENAME


    正确答案: A,F
    解析: 暂无解析

  • 第22题:

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

  • 第23题:

    单选题
    Which is an /SQL*Plus command?()
    A

    INSERT

    B

    UPDATE

    C

    SELECT

    D

    DESCRIBE

    E

    DELETE

    F

    RENAME


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