Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
You have accidentally deleted records from a table called 'transactions'. The table's version was 3 before the deletion and 4 after. What is the easiest method to restore the deleted records or revert the table to its previous state?
A
RESTORE TABLE transactions FROM VERSION as of 4
B
MINUS
C
RESTORE TABLE transactions TO VERSION as of 3
D
INSERT INTO OVERWRITE transactions SELECT * FROM transactions VERSION AS OF 3
E
SELECT * FROM transactions INSERT INTO OVERWRITE transactions SELECT * FROM transactions VERSION AS OF 4
F
INTERSECT
