187.Which two statements describe good practices for an application developer to reduce locking conf

来源:互联网 发布:手机检索专利软件 编辑:程序博客网 时间:2024/05/16 14:35
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:错误,如果升级到块锁那锁的范围更大
0 0
原创粉丝点击