If @@TRANCOUNT is equal to 1, then the COMMIT TRAN statement decrements @@TRANCO

Question

If @@TRANCOUNT is equal to 1, then the COMMIT TRAN statement

decrements @@TRANCOUNT and commits the transaction

decrements @@TRANCOUNT but doesn’t commit the transaction

commits the transaction but doesn’t decrement @@TRANCOUNT

partially commits the transaction

You have a table called Students and you need to process the data 1 student at a time.What should you use?

Stored Procedure

IF…..ELSE block

< >

< >

You have the following code, what will be the output?

DECLARE @var int

SET @var=2

IF @var=3

      PRINT ‘FIRST STATEMENT’

      PRINT’SECOND STATEMENT’

SECOND STATEMENT

FIRST STATEMENT

SECOND STATEMENT

FIRST STATEMENT

Output will contain nothing

decrements @@TRANCOUNT and commits the transaction

decrements @@TRANCOUNT but doesn’t commit the transaction

commits the transaction but doesn’t decrement @@TRANCOUNT

partially commits the transaction

Explanation / Answer

Answers:

1.decrements @@TRANCOUNT and commits the transaction

2.IF…..ELSE block

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.