フリー問題

問題文

A batch job has to empty a table that holds ten million rows before it reloads the data. The team compares removing the rows with DELETE against removing them with TRUNCATE. Which statement describes the difference that matters most here?

選択肢

1. The truncate removes the rows one at a time so the removal takes about as long as the delete does on a table of this size.
2. The truncate keeps the rows in a recycle area for a while so the removal can be reversed with a flashback statement afterwards.
3. The truncate is a data statement so the removal can be undone while the delete is a definition statement a rollback cannot undo.
4. The truncate is a definition statement so the removal cannot be undone while the delete is a data statement that a rollback can undo.