Record Locking

Question 1

What does Salesforce lock when you perform an update on any record. What is the risk of lock contention?

Answer 1

Updated record and sharing records are locked.

Updating locks target record and may result in the creation and/or deletion of one or more sharing records in a private sharing model.

Question 2

What does Salesforce lock when you perform a delete on any record. What is the risk of lock contention?

Answer 2

Record being deleted, sharing records are locked.

Deleting locks the record being
deleted and one or more sharing
records in a private sharing
model.

Risk of lock contention is low

Question 3

When updates (or deletes) are done on an account record, what is locked and what is the risk of lock contention?

Answer 3

Group table is locked, and the risk of lock contention is high.

Lock occurs if updating the owner
field of, or deleting, an Account
that has associated community or
portal roles.

Question 4

When inserts (or deletes) are done on an accountTeamMember and CaseTeamMember record, what is locked and what is the risk of lock contention?

Answer 4

Associated Account, Case, or Opportunity is locked and the risk of lock contention is high.

AccountTeamMember inserts,
updates and deletes can result in
the creation and deletion of child
implicit shares on Cases, Contacts
and Opportunities but associated
object records are not locked.
CaseTeamMember and
OpportunityTeamMember
inserts & deletes can result in the
creation or deletion of a parent
implicit account share, however
existing parent implicit shares are
not locked.

Question 5

When inserts (or deletes) are done on a CampaignMember record, what is locked and what is the risk of lock contention?

Answer 5

Associated Campaign, Contact or Lead is locked.

High risk of lock contention.

Question 6

When inserts, updates or deletes are done on a Case record, what is locked and what is the risk of lock contention?

Answer 6

Account and Contacts are locked

High risk of lock contention

Question 7

When inserts or updates are done on a Contact record, what is locked and what is the risk of lock contention?

Answer 7

Parent Account is locked

High risk of lock contention

Question 8

When inserts, updates or deletes are done on an Opportunity record, what is locked and what is the risk of lock contention?

Answer 8

Parent Account is locked

High risk of lock contention

Question 9

Which objects would typically lock the Group table when updates, inserts or deletes are performed on them?

Answer 9

Account
Territory
User
UserRole

Question 10

Which ObjectShares would lock the AccountShare records when inserts/updates or deletes are made?

Answer 10

CaseShare
ContactShare
OpportunityShare