To ace your Salesforce interview, along with understanding theory and having hands-on practical knowledge, practicing as many Salesforce Development Interview questions and answers is essential. Cloudely experts present you the Salesforce interview questions and answers through a series of articles in this section.
You can also find multiple real-time scenarios, use cases, errors, turnarounds and more. This article is the second in our Salesforce interview questions and answers series. We hope you will find it helpful.
1. DML has partial behavior or complete execution behavior?
Either all success or no success.
2. Can we use records of multiple objects in one UPSERT command?
No, we cannot.
3. What is multi-tenant architecture?
Whenever any platform shares resources with all customers, then this system is called multi-tenant architecture (MTA). Similar is the case with Salesforce Application.
4. ALL ROWS query will give non-deleted records or deleted records or both?
Note: That is why the name “ALL ROWS”
5. What are the differences between SOQL and SOSL?
SOQL(Salesforce Object Query Language)
- Using SOQL the user can make queries only on 1 object at a time.
- The user can query fields of any data type.
- The user can perform DML operations on query results.
- Return type: List
SOSL(Salesforce object Search Language)
- Using SOSL the user can make queries on many objects at an instance.
- We can query only on fields having type Name, phone, or Email.
- The user cannot perform DML operations on the search results.
- Return type: List of list
Suggested Reading: Salesforce Technical Questions and Answers
6. Why do we need 2 query languages in Salesforce?
SOQL is for “fetching” records based on some parameters/conditions.
get the records from the database where the country of customer = India
Here, Query has some conditions. We will not do any random table searches. Everything has to be clearly mentioned.
SOSL = for “searching” some information in the database.
If the user would like to write a code so that he/she can see records where the word “Andrew” is used in the database. (has no connection to any criteria like the above)
Search queries will have a “text” to search.
7. What are the variations in Count ()?
- Count(Field’s API Name)
- Count_Distinct(Field’s API Name)
(THESE ARE ALSO CALLED AS AGGREGATE FUNCTIONS)
Count will display the result of all records while Count Distinct will display only distinct count. For example, a table has 5 records namely a,a,b,b,c then Count results in 5 while Count distinct results in 3.
8. What are Wild Characters / LIKE keywords and when are they used?
When we want to make a query on something which is not an exact value, like Name : “Andrew”, Tech : “Salesforce” etc., (these are exact values), and we only know the approx. format of it, in this case we can use the Wild characters.
This helps to find those records matching the xyz pattern.
We do not know that it’s “Salesforce” but we know it starts with “Sal” or ends with “ce”.
9. What are aggregate functions in SF?
MIN, MAX, COUNT, SUM, and AVG
SELECT MAX(Andy__Experience__c) FROM
Object __Name __c
10. Which function do we use to load data from .CSV and do testing?
Suggested Reading: Salesforce Interview Questions Series 1
Learn Salesforce with Cloudely
Salesforce is one of the career paths that any software job aspirant can choose. You can learn the technology with ease under the expert guidance and dedication.
Begin your Salesforce career with our online Salesforce training programs. Enroll now.
Found this article informative? Share this article.
Looking for expert answers to Salesforce questions? Send them to firstname.lastname@example.org. Our Salesforce experts will answer your queries.