Which four Transact-SQL segments should you use to develop the solution?

DRAG DROP
You have a database that contains three encrypted store procedures named dbo.Proc1, dbo.Proc2 and dbo.Proc3. The stored procedures include INSERT,
UPDATE, DELETE and BACKUP DATABASE statements.
You have the following requirements:
-You must run all the stored procedures within the same transaction.
-You must automatically start a transaction when stored procedures include DML statements.
-You must not automatically start a transaction when stored procedures include DDL statements.
You need to run all three stored procedures.
Which four Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments to the answer area and arrange then in the correct order.
Select and Place:

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.