Salesforce Real Time Interview Questions

 1. In the role hierarchy you have agents in different country  and they are reporting to respective leads of each country  & Organization-Wide Default (OWD) for objects set as private. So agents can't see each other records by default. What about country leads ? Can one country lead see other country agents owned records?

  

No, Even though country leads are at the same level only agents reporting roles can only see the lower level hierarchy records.

2. How to improve the slow running SOQL ?

• Rearrange the where condition to take the index fields precedence
• Remove the unnecessary fields in the select query especially if any long text area fields
• Add additional business filter conditions where ever possible
• Add Limit on number of returning records. 
• If the data is very large and required to use non index fields in where condition try to see the possibility of making them as external id which will automatically get indexed.

3. Renaming Field Labels Considerations/ Any ramifications ?

No, In your business logic as best practice always should use the API names instead of Label, In that design no impact because field label is a static text. Only impact could be an email template merge fields, Apart from that all should work fine.

4.  New Mandatory Field Impact on Existing Records ?

Even though you create new field which is mandatory it will not impact any existing records, In case any of the old record is trying to update that time you see the validation as field required for this new mandatory field.