A user accidentally truncated the data from a frequently-modified table. The Administrator has reviewed the query history and found the truncate statement which was run on 2021-12-12 15:00 with query ID 8e5d0ca9-005e-44e6-b858-a8f5b37c5726. Which of the following statements would allow the Administrator to create a copy of the table as it was exactly before the truncated statement was executed, so it can be checked for integrity before being inserted into the main table?

Question

Accepted Answer

D. CREATE TABLE RESTORE_TABLE CLONE CURRENT_TABLE before (statement =>

Answer

A. CREATE TABLE RESTORE_TABLE CLONE CURRENT_TABLE BEFORE (timestamp => '2021-

Answer

B. SELECT * FROM CURRENT_TABLE before (statement => '8e5d0ca9-005e-44e6-b858-

Answer

C. INSERT INTO CURRENT_TABLE SELECT * FROM CURRENT_TABLE before (statement =>

A user accidentally truncated the data from a frequently-modified table. The Administrator has reviewed the query history and found the truncate statement which was run on 2021-12-12 15:00 with…

Question

Options

How the community answered

Community Discussion