Contact records need to be retrieved that meet the following criteria: all contacts with a mailing address in the state of California or whose last name is equal to Smith. Only the first and last names are needed. An administrator decided to use the Data Loader to retrieve these records using the Export feature. What Sales force Object query Language (SOQL) statement could be used to retrieve the desired records?

Question

Examsnet · Accepted Answer

Correct Answer is :  Select first name. last name. where last name= "Smith" OR state=" CA"

SF Administrative Essentials for Experienced Admin (ADM-211) Test 4