Question: 1 ) Alter table dept add column dep _ phone number ( 5 ) ; 2 ) Alter table dept drop dep _ phone; 3

1) Alter table dept add column dep_phone number(5);
2) Alter table dept drop dep_phone;
3) Select count * from customer;
4) Update employee emp_name=Jack where dep_no=119;
5) Delete * from employee;
6) Select empno, empname from emp_susan where empno=!150;
7) select depno, max(salary) from emp_susan order by depno group by depno;

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!