A deadlock occurs when two users hold shared locks on portions of a table that are needed to complete the transaction of the other user.
Correct Answer:
Verified
Q28: The COMMIT command is used to add
Q29: The DROP command can be used to
Q30: A shared lock is automatically obtained when
Q31: After a COMMIT command is executed,the ROLLBACK
Q32: A shared lock prevents another user from
Q34: If a user has a shared lock
Q35: The USER_TAB_COLUMNS data dictionary object may be
Q36: The SELECT...FOR UPDATE can be used to
Q37: Commands used to modify data are known
Q38: The WHERE clause of the DELETE command
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents