Explanation:Shared (S) locks on a resource are released as soon as the data has been read. 4. Which is the most restrictive isolation level in transaction ?
A. Repeatable Read
B. Snapshot
C. Read Committed
D. SERIALIZABLE
Answer:A
Explanation:Shared (S) locks on a resource are released as soon as the data has been read. 4. Which is the most restrictive isolation level in transaction ?
A. Repeatable Read B. Snapshot C. Read Committed D. SERIALIZABLE
Explanation:When SERIALIZABLE isolation level is set – a range lock is placed on the data set, preventing other users from updating or inserting rows into the data set until the transaction is complete. 5. Point out the wrong statement :