Consider the following code, and please explain what the outcome will be: ALTER Procedure [dbo]. [Delete StudentTransaction]@ld INT AS BEGIN TRY BEGIN TRANSACTION DELETE FROM Student WHERE Id=@ld RAISERROR('Some Random Error' 16,1) COMMIT END TRY BEGIN CATCH ROLLBACK END CATCH Consider the following code, and please explain what the outcome will be: ALTER Procedure [dbo]. [Delete StudentTransaction]@ld INT AS BEGIN TRY BEGIN TRANSACTION DELETE FROM Student WHERE Id=@ld RAISERROR('Some Random Error' 16,1) COMMIT END TRY BEGIN CATCH ROLLBACK END CATCH