Which two statements describe good practices for an application developer to reduce locking conflicts in Oracle database?

Which two statements describe good practices for an application developer to reduce locking
conflicts in Oracle database? (Choose two.)

Which two statements describe good practices for an application developer to reduce locking
conflicts in Oracle database? (Choose two.)

A.
Avoid coding unnecessary longrunning 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.



Leave a Reply 2

Your email address will not be published. Required fields are marked *