Which of the following statements is NOT true for Rollback statements in SQL?

PYQ KVS TGT/PGT 2013

Which of the following statements is NOT true for Rollback statements in SQL?

  1. A.

    All savepoints marked after the savepoint to which you rolled back, are erased.

  2. B.

    It does not free any resources held by the transaction.

  3. C.

    The savepoint to which you rollback is not erased.

  4. D.

    The Rollback statement will erase all data modifications made from the start of the transaction to the savepoint.

Attempted by 1165 students.

Sign up free to check your answer

Sign up free

Explore the full course: Kvs Nvs Tier 2 Computer Science

Loading lesson…