Home » MCQs » SQL MCQs » SQL Table MCQs

Select the statement which is TRUE (2)?

3. Select the statement which is TRUE?

1. In case a transaction is rolled back, the data allied with table variable also get rolled back.
2. In case a transaction is rolled back, the data allied with table variable does not roll back.
3. In case a transaction is not rolled back, the data allied with table variable get rolled back.
4. None of the above.

Answer: B) In case a transaction is rolled back, the data allied with table variable does not roll back

Explanation:

In case a transaction is rolled back, the data allied with table variable does not roll back.