Which of the following keywords is used to mark a column for deletion at a later time?
A) ALTER TABLE...MARK UNUSED
B) ALTER TABLE...SET UNUSED
C) ALTER TABLE...DROP UNUSED
D) ALTER TABLE...SET COLUMN

Question

Which of the following keywords is used to mark a column for deletion at a later time?​
A) ​ALTER TABLE...MARK UNUSED
B) ​ALTER TABLE...SET UNUSED
C) ​ALTER TABLE...DROP UNUSED
D) ​ALTER TABLE...SET COLUMN

Quizplus · Accepted Answer

The keyword 'SET UNUSED' is used to mark a column for deletion at a later time. Option A 'MARK UNUSED' is not a valid keyword. Option C 'DROP UNUSED' is used to drop all columns that have been marked as unused. And option D 'SET COLUMN' is not a valid keyword.

Which of the Following Keywords Is Used to Mark a Column