Using the default lock timeout and isolation level, user USER1 drops table TABLE1 however, the transaction is not committed. Subsequently, user USER2 attempts to access table TABLE1 using the default isolation level. What will occur?
A. User USER2 receives an error immediately.
B. User USER2 will wait until user USER1 issues a COMMIT or ROLLBACK statement.
C. User USER1 will receive an error.
D. User USER2 will be able to access the table successfully.
Using the default lock timeout and isolation level, user USER1 drops table TABLE1 however, the transaction is not commit
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Using the default lock timeout and isolation level, user USER1 drops table TABLE1 however, the transaction is not commit
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!