Question

An emp table contains fields employ name, desig and salary. How do you drop column salary?
Select one:
O a. alter table emp drop column salary
O b. delete from emp where column = salary
O c. alter table emp delete salary
O d. alter table emp delete column salary
​

Answer 1

Answer:

a

Explanation:

alter table emp drop column salary

Answer 2

Option a) alter table emp drop column salary

An emp table contains fields employ name, desig and salary.

• The employee table contains basic personnel information and assigns an employee number to each employee.
• The following is the fundamental syntax for an ALTER TABLE command to modify the DATA TYPE of a column in a table. MODIFY COLUMN table name, column name, datatype; ALTER TABLE table name; The following is the fundamental syntax for an ALTER TABLE command that adds a NOT NULL constraint to a column in a table.
• The first step is to expand the Databases -> Tables menu. Select the required table and expand it in step two. Step 3: Expand the Columns after selecting them. Step 4: Right-click on the name of the column you wish to delete and select Delete.
• A change to an employee's employment contract would be a salary reduction. A contract of employment cannot be unilaterally changed by an employer. Therefore, the affected employees would need to provide their approval to this choice. They are not required to consent and may take legal action to stop the change if they so want.

#SPJ2