How can you change "EmployeeName" column datatype to VARCHAR(50) in an "Employees" table?ALTER TABLE Employees MODIFY EmployeeName VARCHAR(50); CHANGE TABLE Employees MODIFY EmployeeName VARCHAR(50); ALTER TABLE Employees CHANGE EmployeeName VARCHAR(50);None of the above

What is the correct SQL command to change the data type of a column named age in a table named users from INT to VARCHAR(3)?  *1 pointMODIFY TABLE users ALTER COLUMN age VARCHAR(3)ALTER TABLE users MODIFY age VARCHAR(3)ALTER TABLE users CHANGE COLUMN age VARCHAR(3)ALTER TABLE users ALTER COLUMN age TO VARCHAR(3)

Which of the following options is not correct?Select one:a.alter table emp modify name varchar(30);b.alter table emp drop column column_name;c.alter table emp drop column_name;d.alter table emp add column_name varchar(25);

In MySQL, how would you change the data type of a column in an existing table?ALTER TABLE table_name MODIFY column_name new_data_typeCHANGE TABLE table_name column_name new_data_typeMODIFY TABLE table_name column_name new_data_typeALTER TABLE table_name CHANGE column_name new_data_type

Write a query to modify the datatype of the column departmentId from VARCHAR(30) to INT in the table 'department'.Refer to the existing table DLL given below:

The employee table contains information about employees. One of your employees got married, so herlast name changed. What command should you use to reflect this change in the table?