Salesforce Admin Basic Questions and Answers
What are the different field types available in Salesforce?
Text, Number, Currency, Date, Date/Time, Percent, Picklist, Multi-Select Picklist,
Checkbox, Email, Phone, URL, Text Area, Long Text Area, Rich Text Area,
Auto Number, Formula, Roll-Up Summary, Geolocation.
What is the difference between a standard field and a custom field?
Standard fields are provided by Salesforce by default.
Custom fields are created by users as per business needs.
What is a formula field? Can you give an example?
A formula field calculates values using other fields.
Example: A formula field showing Total Price = Quantity * Unit Price.
What is a roll-up summary field? On which relationship can you create it?
It calculates values (SUM, MIN, MAX, COUNT) from child records.
It can only be created on Master-Detail relationships.
What is an auto-number field? Where have you used it?
It auto-generates a unique number for each record.
Used in objects like Invoice, Order, Case for tracking.
What is the difference between text, long text area, and rich text area fields?
Text: short strings (up to 255 chars)
Long Text Area: large text blocks (up to 131,072 chars)
Rich Text Area: same as long text + formatting options (bold, images, etc.)
What is a checkbox field used for?
It's used for Yes/No (True/False) kind of data. Example: Is Active, Is Approved.
What is the difference between a picklist and a multi-select picklist?
Picklist allows only one value to be selected; multi-select picklist allows multiple values.
What are dependent picklists?
A picklist that shows values based on the selection of another field.
Example: State picklist depends on Country field.
Can we change the data type of a field once it is created?
Yes, but with restrictions. Some types like changing from Text to Number may cause data loss.
DATA TYPES
What are the different data types in Salesforce?
Text, Number, Percent, Currency, Date, Date/Time, Checkbox, Picklist, etc.
What is the difference between number, currency, and percent data types?
Number: for regular numbers
Currency: shows currency symbol (e.g. Rs.)
Percent: displays as percentage
When would you use a formula field with return type "Checkbox" or "Text"?
Checkbox: when the result is true/false. Example: IF(Amount > 1000, TRUE, FALSE)
Text: when output is a string. Example: IF(Stage = 'Closed Won', "Success", "In Progress")
What happens when you change the data type of a field from text to number?
It may lead to data loss or errors if existing data has letters or symbols.
RELATIONSHIPS
What are the different types of relationships in Salesforce?
Lookup, Master-Detail, Many-to-Many (via junction object), External Lookup, Indirect Lookup, Hierarchical.
What is the difference between Lookup and Master-Detail relationships?
Lookup: loosely coupled, child can exist without parent
Master-Detail: tightly bound, child cannot exist without parent
Can we convert a Lookup to Master-Detail? And vice versa?
Yes, if all records have parent values and there are no existing roll-up summaries.
What is a junction object?
A custom object used to create many-to-many relationships between two objects.
Example: Student <-> Course <-> Enrollment (junction).
How does a roll-up summary field work in a Master-Detail relationship?
It calculates values on the master object from related detail records.
What happens to child records when a parent is deleted in both Lookup and Master-Detail relationships?
Master-Detail: child records are deleted (cascade delete)
Lookup: child records stay (unless we manually set behavior)
Can a child record have two master records?
Yes, only one primary master and one secondary in a junction object.
Can we create a relationship between standard and custom objects?
Yes, both directions are possible.
What is an external lookup relationship?
It links a Salesforce object to an external object using an external ID.
What is an indirect lookup relationship?
It links an external object to a Salesforce object using a custom field that matches an external ID.
What are hierarchical relationships? Where are they used?
A special lookup available only on the User object to represent org structure (e.g., manager-subordinate).
Comments
Post a Comment