多选题Which are DML statements? （）ACOMMITBMERGECUPDATEDDELETEECREATEFDROP...

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

COMMIT

B

MERGE

C

UPDATE

D

DELETE

E

CREATE

F

DROP...

相似考题

1.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 executionB.The SQL statements in the STS are executed concurrently to produce the execution plan and execution statisticsC.The execution plan and execution statistics are computed for each SQL statement in the STSD.The effects of DDL and DML are considered to produce the execution plan and execution statistics

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

3.Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?（）A、REVOKE ALL PRIVILEGES FROM USER tomB、REVOKE ALL ON EMPLOYEE FROM USER tomC、REVOKE EXECUTE ON EMPLOYEE FROM USER tomD、REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom

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 dataB. Stack spaceC. Private SQL areaD. Location of the runtime area for DML and DDL StatementsE. Location of a part of the runtime area for SELECT statements

更多“Which are DML statements? （）”相关问题

  • 第1题：

    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

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

  • 第5题：

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


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

  • 第6题：

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


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

  • 第7题：

    多选题
    Which  statements are correct about temporary tables（）
    A

    Indexes and views can be created on temporary tables.

    B

    Both the data and the structure of temporary tables can be exported.

    C

    Temporary tables are always created in a user’s temporary tablespace.

    D

    The data inserted into a temporary table in a session is available to other sessions.

    E

    Data manipulation language （DML） locks are never acquired on the data of temporary tables


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

  • 第8题：

    多选题
    Which two statements are true about simple views？（）
    A

    Views can be created as read only.

    B

    Views are data segments like tables.

    C

    Views can be created on the basis of more than one table.

    D

    Data manipulation language （DML） operations cannot be performed on views.


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

  • 第9题：

    多选题
    Which are DML statements? （）
    A

    COMMIT…

    B

    MERGE…

    C

    UPDATE…

    D

    DELETE…

    E

    CREATE…

    F

    DROP…


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

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


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

  • 第12题：

    Which are DML statements? （）

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

    正确答案:B,C,D

  • 第13题：

    Why does performance degrade when many UPDATE， INSERT， or DELETE statements are issued on a tablethat has an associated Bitmap index（）

    • A、The DML operations re-create the Bitmap index blocks.
    • B、The Bitmap index is rebuilt automatically after a DML operation.
    • C、The smallest amount of a bitmap that can be locked is a bitmap segment.
    • D、Additional time is taken to remove NULL values from the Bitmap index after a DML operation.

    正确答案:C

  • 第14题：

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

  • 第15题：

    多选题
    Which are DML statements? （）
    A

    COMMIT

    B

    MERGE

    C

    UPDATE

    D

    DELETE

    E

    CREATE

    F

    DROP...


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

  • 第16题：

    多选题
    Which are DML statements? （）
    A

    COMMIT

    B

    MERGE

    C

    UPDATE

    D

    DELETE

    E

    CREATE

    F

    DROP


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

  • 第17题：

    多选题
    Which four actions are possible during an Online Data file Move operation?（）
    A

    Creating and dropping tables in the data file being moved

    B

    Performing file shrink of the data file being moved

    C

    Querying tables in the data file being moved

    D

    Performing Block Media Recovery for a data block in the data file being moved

    E

    Flashing back the database

    F

    Executing DML statements on objects stored in the data file being moved


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

  • 第18题：

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

  • 第19题：

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


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

  • 第20题：

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

  • 第21题：

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

相关内容