Which two statements are true about Instance Locks in O…

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

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

A.
They are used when an application uses the DBMS_LOCK package for UL lock types.

B.
They are used to coordinate the next value for a sequence created with the CACHE and ORDBR clauses.

C.
They are used to coordinate the next value for a sequence created with the NOCACHE and NOORDER
clauses.

D.
They are used to coordinate access across multiple library caches for the same stored procedure.

E.
They are used to coordinate access across multiple library caches for anonymous PL/SQL execution.



Leave a Reply 1

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