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);

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

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

Which SQL statement is used to change the name of a table?OptionsRENAMEMODIFYCHANGE TABLEALTER TABLE

Which command is used to change a table's behavior? Select one:RENAMEALTER DROPCREATE

correct answerWhich SQL statement is used to change the data type of an existing column in a table?OptionsMODIFY COLUMNCHANGE COLUMNALTER COLUMNUPDATE COLUMN