Truncate table 可跟Where从句，根据条件进行删除
Truncate table 用来删除表中所有数据
触发器对Truncate table无效
delete 比Truncate table速度快
多选题关于Truncate table, 以下（）描述是错误的。ATruncate table 可跟Where从句，根据条件进行删除BTruncate table 用来删除表中所有数据C触发器对Truncate table无效Ddelete 比Truncate table速度快
点击查看答案
多选题关于Truncatetable，以下（）描述是正确的。ATruncate table 可跟Where从句，根据条件进行删除 BTruncate table 用来删除表中所有数据 C触发器对Truncate table无效 Ddelete 比Truncate table速度快
多选题关于Truncatetable，以下（）描述是错误的。ATruncate table可跟Where从句，根据条件进行删除。BTruncate table用来删除表中所有数据。C触发器对Truncate table无效。Ddelete比Truncate table速度快。
多选题Evaluate the SQL statement: TRUNCATE TABLE DEPT;Which three are true about the SQL statement? （）AIt releases the storage space used by the table.BIt does not release the storage space used by the table.CYou can roll back the deletion of rows after the statement executes.DYou can NOT roll back the deletion of rows after the statement executes.EAn attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.FYou must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table.
多选题Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?（）AALTER TABLE SPLIT PARTITIONBALTER TABLE MERGE PARTITIONCALTER TABLE TRUNCATE PARTITIONDALTER TABLE ADD PARTITIONEALTER TABLE DROP PARTITIONFALTER TABLE MOVE PARTITION
问答题delete from system.table1与truncate table system.table1区别是什么？
多选题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 is truncated when the TRUNCATE command is applied on the parent table.DThe high-water mark （HWM） is set to point to the first usable data block in the table segment.ENo undo or very little undo data is generated during the execution of the TRUNCATE command
