An emp table contains fields employ name, desig and salary. How do you drop column salary?
Answer options
A
alter table emp drop column salary;
B
drop column salary from emp;
C
alter emp drop salary;
D
delete column salary from emp;
Correct answer: alter table emp drop column salary;
Detailed Solution & Conceptual Analysis
This question has been retained as-is due to its unique context.
Key Engineering Takeaway
In Database Management, understanding the underlying mechanics of Database Management is critical for writing performant, bug-free production code and passing rigorous technical architecture reviews.