Q-1.Create this table and use enum for the priority column


Id Grade Priority
1 Good Grade High
5 Good Grade High
3 Mediocre Grade Medium
2 Poor Grade Low
4 Poor Grade Low

Q-2.In the above table delete the id 2 and update the id 4 and perform the commit and rollback function