多选题Which three descriptions are correct about the effects of the TRUNCATE command on a table（）AThe corresponding indexes for the table are also truncated.BDelete triggers on the table are fired during the execution of the TRUNCATE command.CThe child table

题目
多选题
Which three descriptions are correct about the effects of the TRUNCATE command on a table（）
A

The corresponding indexes for the table are also truncated.

B

Delete triggers on the table are fired during the execution of the TRUNCATE command.

C

The child table is truncated when the TRUNCATE command is applied on the parent table.

D

The high-water mark （HWM） is set to point to the first usable data block in the table segment.

E

No undo or very little undo data is generated during the execution of the TRUNCATE command

相似考题

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.Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three are true about the SQL statement? ()A. It releases the storage space used by the table.B. It does not release the storage space used by the table.C. You can roll back the deletion of rows after the statement executes.D. You can NOT roll back the deletion of rows after the statement executes.E. An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.F. You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table

3.Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:Which two statements are true about redefining the table?()A. All the triggers for the table are disabled without changing any of the column names or column types in the table.B. The primary key constraint on the EMPLOYEES table is disabled during redefinition.C. VPD policies are copied from the original table to the new table during online redefinition.D. You must copy the VPD policies manually from the original table to the new table during online redefinition.

4.You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?()A. Drop the table.B. Partition the tableC. Truncate the table.D. Add a column to the table.E. Rename a column in the table.

更多“多选题Which three descriptions are correct about the effects of the TRUNCATE command on a table（）AThe corresponding indexes for the table are also truncated.BDelete triggers on the table are fired during the execution of the TRUNCATE command.CThe child table”相关问题

  • 第1题：

    关于Truncate table, 以下（）描述是错误的。

    • A、Truncate table 可跟Where从句，根据条件进行删除
    • B、Truncate table 用来删除表中所有数据
    • C、触发器对Truncate table无效
    • D、delete 比Truncate table速度快

    正确答案:A,D

  • 第2题：

    You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?（）

    • A、Drop the table.
    • B、Partition the table
    • C、Truncate the table.
    • D、Add a column to the table.
    • E、Rename a column in the table.

    正确答案:D

  • 第3题：

    You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive？（）  

    • A、 Drop the table.
    • B、 Partition the table.
    • C、 Truncate the table.
    • D、 Add a column to the table.
    • E、 Rename a column in the table.

    正确答案:D

  • 第4题：

    For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state？（）

    • A、UPDATE TABLE
    • B、CREATE CLUSTER
    • C、TRUNCATE TABLE
    • D、ALTER TABLE MOVE
    • E、INSERT INTO···VALUES
    • F、ALTER TABLE···DROP COLUMN
    • G、ALTER TABLE···DROP PARTITION

    正确答案:A,E

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

    正确答案:A,B,D

  • 第6题：

    You have just performed a FLASHBACK TABLE operation using the following command：   flashback table employees to scn 123456；   The employees table has triggers associated with it.  Which of the following statements is true regarding the state of the triggers during the Flashback Table operation？（）  

    • A、 All the triggers are disabled.
    • B、 All the triggers are enabled by default.
    • C、 Enabled triggers remain enabled and disabled triggers remain disabled.
    • D、 Triggers are deleted when a Flashback Table operation is performed.

    正确答案:A

  • 第7题：

    多选题
    You executed the following FLASHBACK TABLE command： FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）； Which two statements are correct？ （）
    A

    The FLASHBACK TABLE statement will not be written to the alert log file.

    B

    The EMP table that was dropped by mistake from the database will be restored.

    C

    The changes made to the EMP table since the specified time will be undone.

    D

    The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table.

    E

    The FLASHBACK TABLE statement will be executed within a single transaction.

    F

    The list of transactions that have modified the EMP table since the specified time will be displayed.


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

  • 第8题：

    多选题
    You execute this command to drop the ITEM table， which has the primary key referred in the ORDERtable：  SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE；  Which two statements are true about the effect of the command（）
    A

    No flashback is possible to bring back the ITEM table.

    B

    The ORDER table is dropped along with the ITEM table.

    C

    The dependent referential integrity constraints in the ORDER table are disabled.

    D

    The dependent referential integrity constraints in the ORDER table are removed.

    E

    The table definition of the ITEM table and associated indexes are placed in the recycle bin.


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

  • 第9题：

    单选题
    You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive？（）
    A

     Drop the table.

    B

     Partition the table.

    C

     Truncate the table.

    D

     Add a column to the table.

    E

     Rename a column in the table.


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

  • 第10题：

    多选题
    Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? （）
    A

    It releases the storage space used by the table.

    B

    It does not release the storage space used by the table.

    C

    You can roll back the deletion of rows after the statement executes.

    D

    You can NOT roll back the deletion of rows after the statement executes.

    E

    An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.

    F

    You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table


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

  • 第11题：

    多选题
    关于Truncate table, 以下（）描述是错误的。
    A

    Truncate table 可跟Where从句，根据条件进行删除

    B

    Truncate table 用来删除表中所有数据

    C

    触发器对Truncate table无效

    D

    delete 比Truncate table速度快


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

  • 第12题：

    多选题
    You execute this command to drop the ITEM table， which has the primary key referred in the ORDERS table：SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE；  Which two statements are true about theeffect of the command（）
    A

    No flashback is possible to bring back the ITEM table.

    B

    The ORDERS table is dropped along with the ITEM table.

    C

    The dependent referential integrity constraints in the ORDERS table are disabled.

    D

    The dependent referential integrity constraints in the ORDERS table are removed.

    E

    The table definition of the ITEM table and associated indexes are placed in the recycle bin


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

  • 第13题：

    关于Truncatetable，以下（）描述是正确的。

    • A、Truncate table 可跟Where从句，根据条件进行删除 
    • B、Truncate table 用来删除表中所有数据 
    • C、触发器对Truncate table无效 
    • D、delete 比Truncate table速度快

    正确答案:B,C

  • 第14题：

    Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?（）

    • A、ALTER TABLE SPLIT PARTITION
    • B、ALTER TABLE MERGE PARTITION
    • C、ALTER TABLE TRUNCATE PARTITION
    • D、ALTER TABLE ADD PARTITION
    • E、ALTER TABLE DROP PARTITION
    • F、ALTER TABLE MOVE PARTITION

    正确答案:C,E

  • 第15题：

    What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archivingenabled?（）

    • A、It fails with the ORA-665610 Invalid DDL statement on history-tracked message
    • B、The rows in the table are truncated without being archived.
    • C、The rows in the table are archived, and then truncated.
    • D、The rows in both the table and the archive are truncated.

    正确答案:A

  • 第16题：

    Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? （）

    • A、It releases the storage space used by the table.
    • B、It does not release the storage space used by the table.
    • C、You can roll back the deletion of rows after the statement executes.
    • D、You can NOT roll back the deletion of rows after the statement executes.
    • E、An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.
    • F、You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table

    正确答案:A,D,F

  • 第17题：

    Which three descriptions are correct about the effects of the TRUNCATE command on a table（）

    • A、The corresponding indexes for the table are also truncated.
    • B、Delete triggers on the table are fired during the execution of the TRUNCATE command.
    • C、The child table is truncated when the TRUNCATE command is applied on the parent table.
    • D、The high-water mark （HWM） is set to point to the first usable data block in the table segment.
    • E、No undo or very little undo data is generated during the execution of the TRUNCATE command

    正确答案:A,D,E

  • 第18题：

    多选题
    关于Truncatetable，以下（）描述是正确的。
    A

    Truncate table 可跟Where从句，根据条件进行删除 

    B

    Truncate table 用来删除表中所有数据 

    C

    触发器对Truncate table无效 

    D

    delete 比Truncate table速度快


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

  • 第19题：

    单选题
    You have just performed a FLASHBACK TABLE operation using the following command：   flashback table employees to scn 123456；   The employees table has triggers associated with it.  Which of the following statements is true regarding the state of the triggers during the Flashback Table operation？（）
    A

     All the triggers are disabled.

    B

     All the triggers are enabled by default.

    C

     Enabled triggers remain enabled and disabled triggers remain disabled.

    D

     Triggers are deleted when a Flashback Table operation is performed.


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

  • 第20题：

    多选题
    Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?（）
    A

    ALTER TABLE SPLIT PARTITION

    B

    ALTER TABLE MERGE PARTITION

    C

    ALTER TABLE TRUNCATE PARTITION

    D

    ALTER TABLE ADD PARTITION

    E

    ALTER TABLE DROP PARTITION

    F

    ALTER TABLE MOVE PARTITION


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

  • 第21题：

    多选题
    Which three descriptions are correct about the effects of the TRUNCATE command on a table（）
    A

    The corresponding indexes for the table are also truncated.

    B

    Delete triggers on the table are fired during the execution of the TRUNCATE command.

    C

    The child table is truncated when the TRUNCATE command is applied on the parent table.

    D

    The high-water mark （HWM） is set to point to the first usable data block in the table segment.

    E

    No undo or very little undo data is generated during the execution of the TRUNCATE command


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

  • 第22题：

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


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

  • 第23题：

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

  • 第24题：

    单选题
    Which statement is correct about the forwarding table?（）
    A

    The forwarding table is stored only on the PFE

    B

    The forwarding table contains all known routes

    C

    The forwarding table is stored on both the RE and PFE

    D

    The forwarding table is stored only on the RE


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

相关内容