Oracle
1Z0-043 · Question #105
For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state? (Choose two)
The correct answer is A. UPDATE TABLE E. INSERT INTO...VALUES. See the full explanation below for the reasoning.
Question
For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state? (Choose two)
Options
- AUPDATE TABLE
- BCREATE CLUSTER
- CTRUNCATE TABLE
- DALTER TABLE MOVE
- EINSERT INTO...VALUES
- FALTER TABLE...DROP COLUMN
- GALTER TABLE...DROP PARTITION
How the community answered
(28 responses)- A71% (20)
- B4% (1)
- C4% (1)
- D14% (4)
- G7% (2)
Community Discussion
No community discussion yet for this question.