Which of the following options is not correct?
Answer options
A
alter table emp drop column_name;
B
alter table emp drop column salary;
C
alter table emp add column salary number;
D
alter table emp modify salary varchar(20);
Correct answer: alter table emp drop column_name;
Explanation
Quick AnswerThe correct answer is alter table emp drop column_name; because it directly addresses the core logic of Database Management.
The correct syntax is ALTER TABLE emp DROP COLUMN salary; — missing the COLUMN keyword.