Oracle
1Z0-052 · Question #195
Which two statements describe good practices for an application developer to reduce locking conflicts in Oracle database? (Choose two.)
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #195. The question stem and answer options stay visible for context.
Managing Data and Concurrency
Question
Which two statements describe good practices for an application developer to reduce locking conflicts in Oracle database? (Choose two.)
Options
- AAvoid coding unnecessary longrunning transactions.
- BAllow the database to handle locks in default locking mode.
- CAlways explicitly code the locks as per the requirement of the application.
- DAllow escalation of row locks to block locks if too many row locks cause problem.
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#locking best practices#row locks#long-running transactions#concurrency control