OCP CBT Question 594

Please solve the following question.

Which statement accurately describes how Oracle handles lock escalation?

Understanding Oracle's approach to locking and resource management is critical for high-performance, high-concurrency environments.

Oracle automatically escalates row-level locks to table-level locks when the number of locked rows in a table exceeds a predefined threshold.

Oracle uses page-level locks, which are escalated to table-level locks if contention is high.

Oracle does not perform lock escalation; it maintains row-level locks for DML operations regardless of the number of locked rows.

Oracle escalates locks from shared to exclusive mode if multiple sessions request shared locks on the same resource.