Q. Suppose you have two columns named student_name and student_department inside table student_details and you are asked to update the value of these two columns where ID=4 then what statement you will write?
✅ Correct Answer: (A)
UPDATE student_details SET Student_name="ram", Student_department='Chemical' WHERE ID='4';
Explanation: According to the given situation we will write,
UPDATE student_details SET Student_name="ram", Student_department='Chemical' WHERE ID='4';