Oracle
1Z0-052 · Question #128
Which three descriptions are correct about the effects of the TRUNCATE command on a table? (Choose three.)
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #128. The question stem and answer options stay visible for context.
Managing Data and Concurrency
Question
Which three descriptions are correct about the effects of the TRUNCATE command on a table? (Choose three.)
Options
- 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 highwater 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.
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#TRUNCATE#high water mark#indexes#undo generation