单选题A data manipulation language statement （）.A completes a transaction on a tableB modifies the structure and data in a tableC modifies the data but not the structure of a tableD modifies the structure but not the data of a table

题目
单选题
A data manipulation language statement （）.
A

completes a transaction on a table

B

modifies the structure and data in a table

C

modifies the data but not the structure of a table

D

modifies the structure but not the data of a table

相似考题

1.View the exhibit and examine the TRANS table‘s storage information.After a massive delete operation, you executed the following statement to shrink the TRANS table:SQL> ALTER TABLE trans SHRINK SPACE CASCADE;Which statement describes the outcome of the command?（）A. An error is produced.B. The table and all related objects are compacted and the position of the high-water mark (HWM) for the table is adjustedC. The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchangedD. The unused space in the table is reclaimed and returned to the tablespace and the data manipulation language (DML) triggers on the table are fired during the shrinking process

2.You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace:ALTER TABLE employees SHRINK SPACE CASCADE;Which statement is correct in this scenario?（）A. The EMPLOYEES table will be changed to read-only mode during the shrink operation.B. The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.C. The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.D. Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.

3.ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?（）A. The data is decrypted during SORT and JOIN operations.B. The data remains encrypted when it is read into memory.C. The data remains encrypted when it is stored in the redo logs.D. The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.

4.Which two client requests are captured during database replay Capture?()A. Flashback queriesB. Shared server requestsC. Login and logoff activities of sessionsD. Direct path load of data from external files by using utilities such as SQL *loaderE. Data definition language (DDL) and data manipulation language (DML) operations

更多“A data manipulation language statement （）.”相关问题

  • 第1题：

    Which statement is true about a running session that belongs to the online transaction processing (OLTP) group?()

    A. It permanently switches to the low_group consumer group if the session exceeds 10,000 I/O requests or 2,500 MB of data transfer.

    B. It performs the first 10000 I/O requests or 2,500 MB of data transfer in the LOW-GROUP consumer group, and then switches to the original group.

    C. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500 MB of data transfer and returns to the original group after the operation.

    D. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500MB of data transfer for queries, but not for data manipulation language (DML) operations.


    参考答案：D

  • 第2题：

    Which two client requests are captured during database replay Capture?（）

    • A、Flashback queries
    • B、Shared server requests
    • C、Login and logoff activities of sessions
    • D、Direct path load of data from external files by using utilities such as SQL *loader
    • E、Data definition language (DDL) and data manipulation language (DML) operations

    正确答案:C,E

  • 第3题：

    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

  • 第4题：

    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

  • 第5题：

    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.

    正确答案:A,C,E

  • 第6题：

    You suspect unauthorized data manipulation language （DML） operations on a particular table. Youwant to track users who are performing the transactions and the values used in the transactions. You alsoplan to transfer these values to another table for analysis.  How would you achieve this（）

    • A、by using triggers
    • B、by using Data Pump
    • C、by using external tables
    • D、by using anonymous PL/SQL blocks

    正确答案:A

  • 第7题：

    多选题
    Examine the following statement that is used to modify the primary key constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements aretrue regarding the above command（）
    A

    The constraint remains valid.

    B

    The index on the constraint is dropped.

    C

    It allows the loading of data into the table using SQL *Loader.

    D

    New data conforms to the constraint， but existing data is not checked.

    E

    It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.


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

  • 第8题：

    多选题
    When does a transaction complete?（）
    A

    when a DELETE statement is executed

    B

    when a ROLLBACK command is executed

    C

    when a PL/SQL anonymous block is executed

    D

    when a data definition language (DDL) statement is executed

    E

    when a TRUNCATE statement is executed after the pending transact ion


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

  • 第9题：

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

  • 第10题：

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

  • 第11题：

    多选题
    Which two client requests are captured during database replay Capture?（）
    A

    Flashback queries

    B

    Shared server requests

    C

    Login and logoff activities of sessions

    D

    Direct path load of data from external files by using utilities such as SQL *loader

    E

    Data definition language (DDL) and data manipulation language (DML) operations


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

  • 第12题：

    单选题
    You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）
    A

    The data in the segment will be compacted but the high water mark will not be adjusted 

    B

    The EMPLOYEES table will be changed to read-only mode during the shrink operation 

    C

    The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over

    D

    The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation 

    E

    Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation


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

  • 第13题：

    Which two client requests are captured during database replay Capture?() (Choose two)

    A. Flashback queries

    B. Shared server requests

    C. Login and logoff activities of sessions

    D. Direct path load of data from external files by using utilities such as SQL *loader

    E. Data definition language (DDL) and data manipulation language (DML) operations


    参考答案：C, E

  • 第14题：

    When does a transaction complete?（）

    • A、when a DELETE statement is executed 
    • B、when a ROLLBACK command is executed 
    • C、when a PL/SQL anonymous block is executed 
    • D、when a data definition language (DDL) statement is executed 
    • E、when a TRUNCATE statement is executed after the pending transact ion

    正确答案:B,D,E

  • 第15题：

    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

    正确答案:A,C,E

  • 第16题：

    Which two client requests are captured during database replay Capture?（） (Choose two)

    • A、Flashback queries
    • B、Shared server requests
    • C、Login and logoff activities of sessions
    • D、Direct path load of data from external files by using utilities such as SQL *loader
    • E、Data definition language (DDL) and data manipulation language (DML) operations

    正确答案:C,E

  • 第17题：

    Examine the following statement that is used to modify the constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）

    • A、The constraint remains valid.
    • B、The index on the constraint is dropped.
    • C、It allows the loading of data into the table using SQL*Loader.
    • D、New data conforms to the constraint， but existing data is not checked
    • E、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

    正确答案:A,B,C

  • 第18题：

    单选题
    You suspect unauthorized data manipulation language （DML） operations on a particular table. Youwant to track users who are performing the transactions and the values used in the transactions. You alsoplan to transfer these values to another table for analysis.  How would you achieve this（）
    A

    by using triggers

    B

    by using Data Pump

    C

    by using external tables

    D

    by using anonymous PL/SQL blocks


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

  • 第19题：

    多选题
    Which two client requests are captured during database replay Capture?（） (Choose two)
    A

    Flashback queries

    B

    Shared server requests

    C

    Login and logoff activities of sessions

    D

    Direct path load of data from external files by using utilities such as SQL *loader

    E

    Data definition language (DDL) and data manipulation language (DML) operations


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

  • 第20题：

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

  • 第21题：

    多选题
    Examine the following statement that is used to modify the constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）
    A

    The constraint remains valid.

    B

    The index on the constraint is dropped.

    C

    It allows the loading of data into the table using SQL*Loader.

    D

    New data conforms to the constraint， but existing data is not checked

    E

    It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.


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

  • 第22题：

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


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

  • 第23题：

    单选题
    ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?（）
    A

    The data is decrypted during SORT and JOIN operations.

    B

    The data remains encrypted when it is read into memory.

    C

    The data remains encrypted when it is stored in the redo logs.

    D

    The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.


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

  • 第24题：

    单选题
    A data manipulation language statement （）.
    A

    completes a transaction on a table

    B

    modifies the structure and data in a table

    C

    modifies the data but not the structure of a table

    D

    modifies the structure but not the data of a table


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

相关内容