A. They are used to coordinate access across multiple library caches for the same stored procedure. True
In RAC, Instance Locks are used to synchronize access across multiple library caches, ensuring that shared resources like stored procedures are correctly synchronized across instances.
D: They are used when an application uses the DBMS_LOCK package for UL lock types. TRUE
Instance Locks are utilized when applications use the DBMS_LOCK package for user-defined locks (UL), allowing coordination and synchronization among different instances in an Oracle RAC environment.
C. Instance locks are used to coordinate the generation of sequence numbers when a sequence is created with the CACHE and ORDER clauses to ensure consistency across multiple instances in a RAC environment.
D. The DBMS_LOCK package can be used to create user-defined locks (UL locks), and these locks are managed as instance locks in a RAC environment to ensure synchronization.
upvoted 1 times
...
This section is not available anymore. Please use the main Exam Page.1z0-078 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Tunglinfo9
2 months, 4 weeks ago217972f
5 months, 2 weeks ago