Salesforce interview questions and answers : All about SOQL : Part 1

Que 1. What is replacement of SELECT *  in SOQL?

Ans 1. SELECT FIELDS(ALL) FROM Account.

            SELECT FIELDS(STANDARD) FROM Account

            SELECT FIELDS(CUSTOM) FROM Account

* Can not add duplicates fields in select statement

Que 2. Which standard objects acts as Junction object ?

Ans 2. 

1. OpportunityLineItem

2. OpportunityContactRole

3. CaseSolution

4. CaseArticle

5 PriceBookEntry

Que 3. What is FOR UPDATE in SOQL?

Ans 3. FOR UPDATE is used for - prevent race conditions

                                                    - thread safety problems

      e.g. Account[] accts=[Select Id from Account limit 2 FOR UPDATE];

To lock records,records can't be modified by other user either through code or UI.

Que 4. What are types of SOQL queries?

Ans 4. 

1. Parent to Child (Inner query)

When we want to get related child records from for a particular parent records or set of parent record then we use concept of inner query.

e.g. SELECT Id,Name,(SELECT Id,Name from Contacts ) From Account where Id in :accList

2. Child to Parent

Sometimes we want to fetch Parent records while working on child records then we go for child to Parent query

e.g SELECT Id,AccountId,Name,Account.ShippingAddrerss From Contact

Que 5. Write SOQL query to Select All Contacts from Contact object where FirstName is equal to LastName.

Ans 5.

1. Create a formula field checkbox IsFirstAndLastNameSame on Contact.
2. Write the condition as FirstName==LastName .
3. Now you can write SOQL As below :
[ SELECT Id,FirstName ,LastName FROM Contact where IsFirstAndLastNameSame__c=true]

Comments

Post a Comment

Popular posts from this blog

Salesforce Journey

 I   started my career as dot net developer with Datamatics Global Services Ltd in  March 2011 . Then I got chance to work with Orion India System Pvt Ltd from Aug 2013 till date. Upto Dec 2016 I was working on dot net technologies in Orion India Sys Pvt Ltd. Later I was introduced to Salesforce Technologies ,specifically in Service Cloud. After working on Service Cloud for one year I was shifted to Sales Cloud project.  In  Dec 2021 I was going on Maternity Leave. So I was told to work on dot net project POC for few days which was about 3 months. I was promised to return to Salesforce project after returning from Maternity leave which did not happen and I was assigned to same dot net project 😟. After working for a month I decided to resign and started giving interviews  as Salesforce Developer. It was very difficult for me to return as Salesforce Developer as I was having almost more than year of gap because of  dot net project and my maternity ...
Read more

All About Future methods

What are future methods ? Ans :  1. Methods used when you want to run apex transaction asynchronously 2. Static methods with @future annotation and void return type 3. Accepts only primitive types as arguments 4. Only 50 future calls are allowed per apex invocation 5. You can not call one future method from another future method When we generally use future methods? Ans: 1. When you want to make callouts to external web service in trigger 2. When you want to make callout after DML operation 3. When process needs to run in their own thread for processing records or complex calculaions 4. Isolating DML operations on different SObjects types to prevent mixed DML error . When we try to insert set up and Non set up object at a time we come across mixed DML exception. Why we can not pass Sobjects to future methods? Ans: The reason why objects can’t be passed as arguments to future methods is because the object can change between the time you call the method and the time that it actually ...
Read more