Q: Write a query to add new filed which is named as "designation" to the existing table named as "employees".

create table employees(
	id int,
	fname varchar2(50),
	lname varchar2(50),
	salary decimal(10,2)
);

alter table employees add designation varchar(50);

alter table employees add (department varchar(30),location varchar2(40));

Q: Write a query to remove the selected field/column from the existing table?

alter table employees drop (lname);

Q: Write a query to modify the datatype of the existing column in the table?
alter table employees modify salary number(10,2);