124. User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to? (Choose two.)
A) null lock on the row being updated
B) null lock on the table containing the row
C) ROW SHARE lock for the row being updated
D) ROW EXCLUSIVE lock for the row being updated
E) shared row-exclusive lock for the row being updated
F) a shareable table lock for the table containing the row
G) exclusive table-level lock for the table containing the row
答案：DF
D意思是被更新记录是Exclusive lock（排它锁），F是shared table lock。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11312660/viewspace-718625/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
