SALESFORCE-PD1 Developer Fundamentals Practice Question
A developer writes a SOQL query to fetch Account records and wants to bind a list of strings called 'targetNames' as filter criteria. Which syntax is correct?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
SELECT Id FROM Account WHERE Name IN :targetNames
Using IN :targetNames allows binding a collection variable directly into a SOQL WHERE clause.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
SELECT Id FROM Account WHERE Name IN targetNames
Why it's wrong here
Variables must be bound using a colon (:) prefix in SOQL.
- ✗
SELECT Id FROM Account WHERE Name IN {targetNames}
Why it's wrong here
Curly braces are not valid bind variable syntax in SOQL.
- ✗
SELECT Id FROM Account WHERE Name IN STRING.valueOf(targetNames)
Why it's wrong here
Method calls inside SOQL bind clauses are not supported this way.
- ✓
SELECT Id FROM Account WHERE Name IN :targetNames
Why this is correct
The colon syntax (:targetNames) correctly binds the Apex collection variable to the query.
About these practice questions
This SALESFORCE-PD1 question is part of Courseiva's 488-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed August 2026 · checked against the official Salesforce exam blueprint
This SALESFORCE-PD1 practice question is part of Courseiva's free Salesforce certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the SALESFORCE-PD1 exam.