Which query should you use?

You have a table named JobCandidate. You are tasked to delete a row in the JobCandidate table. You need to write a transaction that allows the database to be restored to the exact point the record was deleted without knowing the time of execution. Which query should you use?

You have a table named JobCandidate. You are tasked to delete a row in the JobCandidate table. You need to write a transaction that allows the database to be restored to the exact point the record was deleted without knowing the time of execution. Which query should you use?

A.
BEGIN TRANSACTION
DELETE FROM JobCandidate
WHERE JobCandidateID = 10;
COMMIT TRANSACTION;

B.
BEGIN TRANSACTION WITH MARK N’Deleting a Job Candidate’;
DELETE FROM JobCandidate
WHERE JobCandidateID = 10;
COMMIT TRANSACTION

C.
BEGIN TRANSACTION Delete_Candidate WITH MARK
DELETE FROM JobCandidate
WHERE JobCandidateID = 10;
COMMIT TRANSACTION Delete_Candidate;

D.
DECLARE @CandidateName varchar(50) = ‘Delete_Candidate’
BEGIN TRANSACTION @CandidateName
DELETE FROM JobCandidate
WHERE JobCandidateID = 10;
COMMIT TRANSACTION @CandidateName;



Leave a Reply 1

Your email address will not be published. Required fields are marked *


sabin

sabin

C

at B N’Deleting a Job Candidate’ – represent the description of the trans.
but the name of the trans isn’t specify. So B is not the answer

A, D don’t have <WITH MARK'