Select from following answers:- drop department_master where dept_id = 5;
- truncate table department_master where dept_id = 5;
- truncate department_master where dept_id = 5;
- delete from department_master where dept_id = 5;

- All Above
delete from department_master where dept_id = 5;
Above query is the right way to delete row where department id is 5.Rest queries will produce an error.
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator