Oracle
1Z0-062 · Question #89
What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archiving enabled?
The correct answer is B. The rows in the table are truncated without being archived. You cannot roll back a TRUNCATE TABLE statement, nor can you use a FLASHBACK TABLE statement to retrieve the contents of a table that has been truncated.
Managing Undo Data
Question
What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archiving enabled?
Options
- AIt fails with the ORA-665610 Invalid DDL statement on history-tracked message
- BThe rows in the table are truncated without being archived.
- CThe rows in the table are archived, and then truncated.
- DThe rows in both the table and the archive are truncated.
How the community answered
(33 responses)- A12% (4)
- B79% (26)
- C6% (2)
- D3% (1)
Explanation
You cannot roll back a TRUNCATE TABLE statement, nor can you use a FLASHBACK TABLE statement to retrieve the contents of a table that has been truncated.
Topics
#Flashback Archive#TRUNCATE TABLE#undo data#data retention
Community Discussion
No community discussion yet for this question.