1- A developer used the following section of code to “one-up” number a column in his table.Is there
any downside to this method other than gaps?If so what?
Select @new_number = (select max(emp_nbr) from employee)
Select @new_number = @new_number + 1
Insert into employee values (@new_number, “Harry”, “Shasho”)
What is the purpose of a checkpoint(not what happens,but why)?
3-Is there any advantage to using triggers for validation as compared to stored procedures?If so what?
List 2 ways to prevent a deadlock