Salesforce interview question

You can refer the below link

http://www.srinusfdc.com/p/interview-questions.html

When should I use SOAP and When should I use REST?

• USE SOAP when:
  
  • When the 2 applications are talking to each other need to know in-advance what the contract is going to be.
  • Deals with larger amount of data or Bulk Data or batch
  • Doing more Business to Business type application.
• USE REST API when:
• It is a lightweight protocol
• It does not have an envelope or big header.
• It is used in mobile-application.

When you get the error “Non-selective query against large object type”? how to resolve it

When you get the error “Non-selective query against large object type”? how to resolve it

Whenever an object has greater than 100K records any query on that object must be “selective”. For a query to be selective it must have enough indexed filters (where clauses) so that less than 10% of the records (in our example 10K) are returned before applying the limit statement

Below are some good examples of selective queries for a little inspiration.

Example 1

SELECT Id FROM Contact WHERE Id In ('00Q6000000nuyL2EAI','00Q6000000iyBBhEAM','00Q6000000j007MEAQ')

Example 2

SELECT Id FROM Lead WHERE Email != ' '

This one is a trick. Email is an indexed field on Lead but if you look at my WHERE clause, this is going to return darn near all the Leads. So, I didn't reduce this record set by much and thus this reverts to a 'non-selective' query. 

SELECT Id FROM Lead WHERE Email != ' ' and Status = 'Open' and Owner Id in  ('005d0000001btXoAAI', '005d0000002X1AqAAK')