Which alter command below may affect the availability of column with respect to time travel?

Which alter command below may affect the availability of column with respect to time travel?

A. ALTER TABLE…DROP COLUMN

B. ALTER TABLE…SET DATA TYPE

C. ALTER TABLE…SET DEFAULT

View Answer

Answer: A

Explanation:

For the alter command that may affect the availability of a column with respect to time travel:

A. ALTER TABLE…DROP COLUMN

Dropping a column from a table can affect the ability to time travel back to a point before the column was dropped, as the column would no longer exist in the current schema of the table.