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

题目
多选题
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?（）ACOMMITBMERGECUPDATEDDELETEECREATEFDROP...”相关问题

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

    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

  • 第4题：

    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

  • 第5题：

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

  • 第6题：

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


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

  • 第7题：

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


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

  • 第8题：

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

  • 第9题：

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

  • 第10题：

    多选题
    Which are DML statements? （）
    A

    COMMIT…

    B

    MERGE…

    C

    UPDATE…

    D

    DELETE…

    E

    CREATE…

    F

    DROP…


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

  • 第11题：

    多选题
    Which are DML statements? （）
    A

    COMMIT

    B

    MERGE

    C

    UPDATE

    D

    DELETE

    E

    CREATE

    F

    DROP...


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

  • 第12题：

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

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

    正确答案:D,E

  • 第15题：

    Which are DML statements? （）

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

    正确答案:B,C,D

  • 第16题：

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

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

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

  • 第19题：

    多选题
    Which are DML statements? （）
    A

    COMMIT

    B

    MERGE

    C

    UPDATE

    D

    DELETE

    E

    CREATE

    F

    DROP


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

  • 第20题：

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

  • 第21题：

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

  • 第22题：

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

  • 第23题：

    多选题
    Which two statements are true regarding views?（）
    A

    A subquery that defines a view cannot include the GROUP BY clause

    B

    A view that is created with the subquery having the DISTINCT keyword can be updated

    C

    A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated

    D

    A data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table


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

  • 第24题：

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

相关内容