Oracle 11G OCP 1Z0-052 167

（167）Which three descriptions are correct about the effects of the TRUNCATE command on a  table? (Choose three.)

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）

解析：

实测,触发器未触发, 索引被truncate（注意不是删除）

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/17013648/viewspace-1225862/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/17013648/viewspace-1225862/