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.)
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.

Download Printable PDF. VALID exam to help you PASS.

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.