187.Which two statements describe good practices for an application developer to reduce locking
conflicts in Oracle database? (Choose two.)
A.Avoid coding unnecessary long-running transactions.
B.Allow the database to handle locks in default locking mode.
C.Always explicitly code the locks as per the requirement of the application.
D.Allow escalation of row locks to block locks if too many row locks cause problem.
答案:AB
A:正确,减小事务造成锁的时间
B:正确,使用oracle内部机制来进行处理这些
C:错误,这个只是加重了锁
D:错误,如果升级到块锁那锁的范围更大
conflicts in Oracle database? (Choose two.)
A.Avoid coding unnecessary long-running transactions.
B.Allow the database to handle locks in default locking mode.
C.Always explicitly code the locks as per the requirement of the application.
D.Allow escalation of row locks to block locks if too many row locks cause problem.
答案:AB
A:正确,减小事务造成锁的时间
B:正确,使用oracle内部机制来进行处理这些
C:错误,这个只是加重了锁
D:错误,如果升级到块锁那锁的范围更大