更多“单选题Which are iSQL*Plus commands? ()A INSERTB UPDATEC SELECTD DESCRIBEE DELETEF RENAME”相关问题
  • 第1题:

    以下SQL语句中,(60)用于修改表结构。

    A.ALTER

    B.UPDATE

    C.SELECT

    D.INSERT


    正确答案:A
    解析:在SQL语句中,(CREATETABLE...)语句用于定义基本表;定义视图使用(CREATEVIEW...)语句;定义别名使用(CREATESYNONYM...)语句;建立索引使用(CREATEINDEX...)语句:修改基本表使用(ALTERTABLE...)语句;(SELECT-FROM-WHERE)语句实现查询;(INSERTINTO)语句用于插入记录;(UPDATE...SET...WHERE)语句用于更新记录:(DELETEFROM...WHERE)语句用于删除记录。

  • 第2题:

    SQL 语言的查询语句是

    A)INSERT

    B)UPDATE

    C)DELETE

    D)SELECT


    正确答案:D

  • 第3题:

    实现排序运算的SQL语言子句是()

    • A、ORDER BY
    • B、UPDATE
    • C、SELECT
    • D、GROUP BY

    正确答案:A

  • 第4题:

    Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in iSQL*Plus?()

    • A、The user must be granted the database administrator (DBA) privilege.
    • B、The user must be listed in the password file for the authentication.
    • C、No special setup is needed for the user to connect as SYSDBA in iSQL*Plus.
    • D、Set up a user in the Oracle Application Server Containers for J2EE (OC4J) user manager,and grant the webDba role to the user.

    正确答案:D

  • 第5题:

    创建数据表应该用以下()指令。

    • A、INSERT
    • B、CREATE
    • C、SELECT
    • D、UPDATE

    正确答案:B

  • 第6题:

    Which are iSQL*Plus commands? ()

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

    正确答案:D

  • 第7题:

    Which is an /SQL*Plus command? ()

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

    正确答案:D

  • 第8题:

    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

  • 第9题:

    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

  • 第10题:

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

    INSERT

    B

    UPDATE

    C

    SELECT

    D

    DESCRIBE

    E

    DELETE

    F

    RENAME


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

  • 第11题:

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

  • 第12题:

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

  • 第13题:

    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

  • 第14题:

    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.

    正确答案:B,E

  • 第15题:

    下列哪些是DML语句()

    • A、commit
    • B、update
    • C、Select
    • D、drop

    正确答案:B,C

  • 第16题:

    SQL的数据操作语句不包括()

    • A、INSERT
    • B、UPDATE
    • C、DELETE
    • D、CHANGE

    正确答案:D

  • 第17题:

    定义视图的语句中可以包含的子句是()

    • A、INSERT
    • B、UPDATE
    • C、SELECT
    • D、DELETE

    正确答案:C

  • 第18题:

    Which is an iSQL*Plus command? ()

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

    正确答案:D

  • 第19题:

    Which are /SQL*Plus commands? ()

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

    正确答案:A,B,C,D,E

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

    正确答案:C,E

  • 第21题:

    单选题
    Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in iSQL*Plus?()
    A

    The user must be granted the database administrator (DBA) privilege.

    B

    The user must be listed in the password file for the authentication.

    C

    No special setup is needed for the user to connect as SYSDBA in iSQL*Plus.

    D

    Set up a user in the Oracle Application Server Containers for J2EE (OC4J) user manager,and grant the webDba role to the user.


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

  • 第22题:

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

  • 第23题:

    单选题
    Which are iSQL*Plus commands? ()
    A

    INSERT

    B

    UPDATE

    C

    SELECT

    D

    DESCRIBE

    E

    DELETE

    F

    RENAME


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

  • 第24题:

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

    INSERT

    B

    UPDATE

    C

    SELECT

    D

    DESCRIBE

    E

    DELETE

    F

    RENAME


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