Salesforce SOQL & SOSL Interview Question's

Questions And Answers   


Company Asked: Salesforce                                                                              Experience : 3+ years

1) write a SOQL Query to fetch top 2nd highest marks in student object(table) and English subject(field).

Ans:  Student is table. 

           English is field. 

Query: select id, Name, English __c from Student__c order by English __c DESC limit 1 offset 1


Company Asked: Salesforce for TSE Position                                                      Experience: 2+ years.

2) write a SOQL Query to parent to child and child to parent.

Ans:

Parent to child

Query: Select name, (select name FROM Contacts) from Account

Child to parent

Query: Select Contact.Name, Contact.Account.Name from Contact


Company Asked: Salesforce for TSE Position                                                      Experience: 2+ years.

3)Can you please explain me the difference between SOQL & SOSL.

Ans:

SOQL:

It is stands for Salesforce object Quary language.

It is used to fetch the records from object and related objects.

It can be used in apex classes and apex triggers.

SOSL:

It is stands for salesforce object search language.

It is used to fetch the records from multiple objects and only date ,text ,phone fields.

It is used in apex classes.


Company Asked: Salesforce for TSE Position, TCS                                             Experience: 2+ years.

4)What Is Dynamic SOQL ? Give an example. 

Ans:

It Refers to creation of SOQL string at run time using apex code. It gives to chance to create more flexible application in our project. 

Example :

We can create SOQL string based on the input of the End user.

Company Asked: Salesforce for TSE Position                                                        Experience: 3+ years.

5)Write a SOQL Quary to find accounts with associated contacts that do not have any email IDs associated.

Ans) 

SELECT Name FROM Account WHERE Id IN (SELECT AccountId FROM Contact WHERE Email = NULL)





Feel free to post any comments regarding mistakes, corrections, ideas, and suggestions related to the article.

Thank you for reading the article.

Jayanth A


Comments

Post a Comment

Popular posts from this blog

Salesforce Admin Notes

  What is cloud computing Cloud computing is a technology that allows you to access and store data and applications over the internet instead of on your local computer or server. It provides on-demand availability of computing resources, such as servers, storage, databases, networking, software, and more, without the need for direct active management by the user. Key Characteristics of Cloud Computing: On-Demand Self-Service : Users can provision computing resources as needed without human intervention. Broad Network Access : Resources are available over the network and accessed through standard mechanisms. Resource Pooling : Computing resources are pooled to serve multiple users, with different physical and virtual resources dynamically assigned and reassigned according to demand. Rapid Elasticity : Resources can be quickly scaled up or down to meet demand. Measured Service : Resource usage is monitored, controlled, and reported, providing ...
Read more

Salesforce Limitations

  Salesforce, like any platform, has certain limitations to ensure optimal performance and maintain system integrity. Here are some key limitations: Data Storage Limits ·         Data Storage : Varies by edition and number of users. For example, Enterprise Edition provides 10 GB of data storage plus 20 MB per user. ·         File Storage : Varies by edition and number of users. For example, Enterprise Edition provides 10 GB of file storage plus 2 GB per user. API Limits ·         API Call Limits : Vary by edition and are based on the number of user licenses. For example, Enterprise Edition allows up to 100,000 API calls per 24-hour period. Governor Limits ·         SOQL Queries : Maximum of 100 SOQL queries per transaction. ·         DML Statements : Maximum of 150 DML statements per transactio...
Read more

Salesforce Order of Execution

  The order of execution in Salesforce is a sequence of steps that occur when a record is saved. Understanding this order is crucial for developers and administrators to ensure that customizations and automations work as expected. Here is the order of execution in Salesforce: 1.      System Validation Rules : Salesforce performs system validations to check for required fields, data types, and field formats. 2.      Before Triggers : Executes before any record is saved to the database. 3.      Custom Validation Rules : Executes custom validation rules defined by administrators. 4.      Duplicate Rules : Executes duplicate rules to check for duplicate records. 5.      After Triggers : Executes after the record is saved to the database. 6.      Assignment Rules : Executes assignment rules, such as lead assignment rules. 7.      Auto-...
Read more