Which of the following commands will drop any columns marked as unused from the TABLEA table?
A) DROP COLUMN FROM tablea WHERE column_status = UNUSED;
B) ALTER TABLE tablea DROP UNUSED COLUMNS;
C) ALTER TABLE tablea DROP (unused);
D) DROP UNUSED COLUMNS:

Question

Which of the following commands will drop any columns marked as unused from the TABLEA table?​
A) ​DROP COLUMN FROM tablea WHERE column_status = UNUSED;
B) ​ALTER TABLE tablea DROP UNUSED COLUMNS;
C) ​ALTER TABLE tablea DROP (unused);
D) ​DROP UNUSED COLUMNS:

Quizplus · Accepted Answer

The correct syntax to drop any columns marked as unused is "ALTER TABLE table_name DROP UNUSED COLUMNS;". Option B is the only one that follows this syntax. Option A is incorrect because the syntax for dropping a column is "ALTER TABLE table_name DROP COLUMN column_name". Option C is incorrect because it is missing the keyword "COLUMNS" after the table name and incorrect syntax for dropping multiple columns. Option D is incorrect because it is missing the table name.

Which of the Following Commands Will Drop Any Columns Marked