Oracle
1Z0-068 · Question #121
Which two statements are true about Instance Locks in Oracle 12c RAC? (Choose two.)
The correct answer is B. They are used to coordinate the next value for a sequence created with the CACHE and ORDBR D. They are used to coordinate access across multiple library caches for the same stored procedure. See the full explanation below for the reasoning.
Question
Which two statements are true about Instance Locks in Oracle 12c RAC? (Choose two.)
Options
- AThey are used when an application uses the DBMS_LOCK package for UL lock types.
- BThey are used to coordinate the next value for a sequence created with the CACHE and ORDBR
- CThey are used to coordinate the next value for a sequence created with the NOCACHE and
- DThey are used to coordinate access across multiple library caches for the same stored procedure.
- EThey are used to coordinate access across multiple library caches for anonymous PL/SQL
How the community answered
(47 responses)- A2% (1)
- B81% (38)
- C4% (2)
- E13% (6)
Community Discussion
No community discussion yet for this question.