Which statement will successfully execute in the second session with no blocking?

Your Prod database resides on a SQL Server 2008 instance. You have a PurchaseOrderHeader table defined as follows in the Prod database:


You open a session and execute the following Transact-SQL:
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ
BEGIN TRANSACTION SELECT * FROM PurchaseOrderHeader;
You open another session.
Which statement will successfully execute in the second session with no blocking?
A. DELETE FROM PurchaseOrderHeader
WHERE PurchaseOrderID = 1;
B. UPDATE PurchaseOrderHeader
SET ShipMethodID = 2
WHERE PurchaseOrderID = 1;
C. ALTER TABLE PurchaseOrderHeader
ADD ProjectID int;
D. INSERT INTO PurchaseOrderHeader(Status, VendorID, ShipMethodID,OrderDate, ShipDate, SubTotal, TaxAmt,
Freight, ModifiedDate)VALUES(0,0,0,’02-13-2009′,NULL, 10, 10, 10, GETDATE());

microsoft-exams

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.