Set - 2

Question 1 :


Answer :

Rollback causes work in the current transaction to be undone.

Question 2 :


Answer :

Savepoint is a point within a particular transaction to which you may rollback without rolling back the entire transaction.

Question 3 :

Set Transaction

Answer :

Set Transaction is to establish properties for the current transaction.

Question 4 :


Answer :

Locking are mechanisms intended to prevent destructive interaction between users accessing data. Locks are used to achieve.

Question 5 :


Answer :

Consistency : Assures users that the data they are changing or viewing is not changed until the are thro' with it.