Oracle Database Administration 2019 Certified Professional — Question 56

Which two statements are true about Instance Locks in Oracle 19c RAC? (Choose two.)

Answer options

• A. They are used to coordinate access across multiple library caches for the same stored procedure.
• B. They are used to coordinate access across multiple library caches for anonymous PL/SQL execution.
• C. They are used to coordinate the next value for a sequence created with the CACHE and ORDER clauses.
• D. They are used when an application uses the DBMS_LOCK package for UL lock types.
• E. They are used to coordinate the next value for a sequence created with the NOCACHE and NOORDER clauses.

Correct answer: A, D

Explanation

The correct answers, A and D, accurately describe the role of Instance Locks in coordinating library cache access and the usage of the DBMS_LOCK package, respectively. Options B, C, and E are incorrect as they either misrepresent the function of Instance Locks or refer to sequence management which is not relevant for Instance Locks.