多选题Which are DML statements? （）ACOMMIT…BMERGE…CUPDATE…DDELETE…ECREATE…FDROP…

题目
多选题
Which are DML statements? （）
A

COMMIT…

B

MERGE…

C

UPDATE…

D

DELETE…

E

CREATE…

F

DROP…

相似考题

1.Which two statements regarding the Flashback Table feature are correct?()A. Flashback Table can be performed on system tables.B. Flashback Table operation does not shrink the segments.C. Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.D. Flashback Table operation acquires exclusive data manipulation language (DML) locks.

2.You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index.Which two are possible if table updates are performed which affect the invisible index columns?（）A. The index remains invisible.B. The index is not updated by the DML statements on the indexed table.C. The index automatically becomes visible in order to have it updated by DML on the table.D. The index becomes unusable but the table is updated by the DML.E. The index is updated by the DML on the table.

3.Which of the following statements is true regarding the VERSIONS BETWEEN clause？（）  A、 The VERSIONS BETWEEN clause may be used in DML statements.B、 The VERSIONS BETWEEN clause may be used in DDL statements.C、 The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.D、 The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.

4.Which statements are true regarding table compression? ()(Choose all that apply.)A. It saves disk space and reduces memory usage.B. It saves disk space but has no effect on memory usage.C. It incurs extra CPU overhead during DML as well as direct loading operations.D. It incurs extra CPU overhead during DML but not direct loading operations.E. It requires uncompress operation during I/O.

更多“多选题Which are DML statements? （）ACOMMIT…BMERGE…CUPDATE…DDELETE…ECREATE…FDROP…”相关问题

  • 第1题：

    Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?（）

    • A、REVOKE ALL PRIVILEGES FROM USER tom
    • B、REVOKE ALL ON EMPLOYEE FROM USER tom
    • C、REVOKE EXECUTE ON EMPLOYEE FROM USER tom
    • D、REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom

    正确答案:B

  • 第2题：

    Which are DML statements?（）

    • A、COMMIT
    • B、MERGE
    • C、UPDATE
    • D、DELETE
    • E、CREATE
    • F、DROP...

    正确答案:B,C,D

  • 第3题：

    You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index. Which two are possible if table updates are performed which affect the invisible index columns?（）

    • A、The index remains invisible.
    • B、The index is not updated by the DML statements on the indexed table.
    • C、The index automatically becomes visible in order to have it updated by DML on the table.
    • D、The index becomes unusable but the table is updated by the DML.
    • E、The index is updated by the DML on the table.

    正确答案:A,E

  • 第4题：

    多选题
    You configure your database Instance to support shared server connections.Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?（）
    A

    User session data

    B

    Stack space

    C

    Private SQL area

    D

    Location of the runtime area for DML and DDL Statements

    E

    Location of a part of the runtime area for SELECT statements


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

  • 第5题：

    单选题
    Which of the following operations does not require Oracle to store information in an UNDO segments as part of the transaction?（）
    A

    INSERT 

    B

    SELECT 

    C

    UPDATE 

    D

    DELETE


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

  • 第6题：

    多选题
    You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index. Which two are possible if table updates are performed which affect the invisible index columns?（）
    A

    The index remains invisible.

    B

    The index is not updated by the DML statements on the indexed table.

    C

    The index automatically becomes visible in order to have it updated by DML on the table.

    D

    The index becomes unusable but the table is updated by the DML.

    E

    The index is updated by the DML on the table.


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

  • 第7题：

    多选题
    Which are DML statements? （）
    A

    COMMIT

    B

    MERGE

    C

    UPDATE

    D

    DELETE

    E

    CREATE

    F

    DROP


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

  • 第8题：

    多选题
    You execute the following PL/SQL:Which two statements are true?（）
    A

    Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accessed.

    B

    FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE > 10000 is accessed.

    C

    FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column.

    D

    FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.


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

  • 第9题：

    单选题
    Over the course of a day，a department performed multiple DML statements （inserts， updates， deletes） on multiple rows of data in multiple tables. The manager would like a report showing the time， table name，and DML type for all changes that were made. Which Flashback technology would be the best choice to produce the list？（）
    A

     Flashback Drop

    B

     Flashback Query

    C

     Flashback Transaction Query

    D

     Flashback Versions Query

    E

     Flashback Table


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

  • 第10题：

    多选题
    Which statements are true regarding table compression？（）
    A

    It saves disk space and reduces memory usage.

    B

    It saves disk space but has no effect on memory usage.

    C

    It incurs extra CPU overhead during DML as well as direct loading operations.

    D

    It incurs extra CPU overhead during DML but not direct loading operations.

    E

    It requires uncompress operation during I/O.


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

  • 第11题：

    多选题
    Which are DML statements? （）
    A

    COMMIT

    B

    MERGE

    C

    UPDATE

    D

    DELETE

    E

    CREATE

    F

    DROP...


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

  • 第12题：

    多选题
    Which statements are correct regarding indexes？ （）
    A

    When a table is dropped， the corresponding indexes are automatically dropped.

    B

    For each DML operation performed， the corresponding indexes are automatically updated.

    C

    Indexes should be created on columns that are frequently referenced as part of an expression.

    D

    A non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a uniqueindex.


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

  • 第13题：

    Over the course of a day，a department performed multiple DML statements （inserts， updates， deletes） on multiple rows of data in multiple tables. The manager would like a report showing the time， table name，and DML type for all changes that were made. Which Flashback technology would be the best choice to produce the list？（）

    • A、 Flashback Drop
    • B、 Flashback Query
    • C、 Flashback Transaction Query
    • D、 Flashback Versions Query
    • E、 Flashback Table

    正确答案:C

  • 第14题：

    Which are DML statements? （）

    • A、COMMIT…
    • B、MERGE…
    • C、UPDATE…
    • D、DELETE…
    • E、CREATE…
    • F、DROP…

    正确答案:B,C,D

  • 第15题：

    单选题
    在Hibernate中，Session类提供了（）接口，提供了参数绑定、结果集处理以及运行实际查询的方法。
    A

    createSQLQuery（）

    B

    save（）

    C

    update（）

    D

    delete（）


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

  • 第16题：

    多选题
    Which statements are true regarding table compression? （）(Choose all that apply.)
    A

    It saves disk space and reduces memory usage.

    B

    It saves disk space but has no effect on memory usage.

    C

    It incurs extra CPU overhead during DML as well as direct loading operations.

    D

    It incurs extra CPU overhead during DML but not direct loading operations.

    E

    It requires uncompress operation during I/O.


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

  • 第17题：

    多选题
    You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set?（）
    A

    Every SQL statement in the STS is considered only once for execution

    B

    The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics

    C

    The execution plan and execution statistics are computed for each SQL statement in the STS

    D

    The effects of DDL and DML are considered to produce the execution plan and execution statistics


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

  • 第18题：

    单选题
    功能最强也是最复杂的SQL语句是（）。
    A

    Insert语句

    B

    Select语句

    C

    Update语句

    D

    Delete语句


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

  • 第19题：

    多选题
    Which two statements regarding the Flashback Table feature are correct?（）
    A

    Flashback Table can be performed on system tables.

    B

    Flashback Table operation does not shrink the segments.

    C

    Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.

    D

    Flashback Table operation acquires exclusive data manipulation language (DML) locks.


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

  • 第20题：

    单选题
    Which of the following statements is true regarding the VERSIONS BETWEEN clause？（）
    A

     The VERSIONS BETWEEN clause may be used in DML statements.

    B

     The VERSIONS BETWEEN clause may be used in DDL statements.

    C

     The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.

    D

     The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.


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

  • 第21题：

    多选题
    Which are DML statements? （）
    A

    COMMIT…

    B

    MERGE…

    C

    UPDATE…

    D

    DELETE…

    E

    CREATE…

    F

    DROP…


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

  • 第22题：

    单选题
    在Hibernate中，以下（）不属于session的方法
    A

    close（）

    B

    open（）

    C

    update（）

    D

    delete（）


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

  • 第23题：

    多选题
    Which statements are true regarding system-partitioned tables?（）
    A

    Only a single partitioning key column can be specified.

    B

    All DML statements must use partition-extended syntax.

    C

    The same physical attributes must be specified for each partition.

    D

    Unique local indexes cannot be created on a system-partitioned table.

    E

    Traditional partition pruning and partitionwise joins are not supported on these tables.


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

  • 第24题：

    多选题
    按触发操作的不同，DML触发器分为（）
    A

    select触发器

    B

    insert触发器

    C

    update触发器

    D

    delete触发器


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

相关内容