Using the default lock timeout and isolation level, user USER1 drops table TABLE1 however, the transaction is not commit
Posted: Fri Aug 26, 2022 9:58 am
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.
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.