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

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

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

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

B.
The high-water mark (HWM) is set to point to the first useable data block in the table segment.

C.
The corresponding indexes for the table are also truncated.

D.
Very little or no undo data is generated during the execution of the TRUNCATE command.

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *