PD1 SOQL and SOSL 2

Question 1

What is the primary functional difference between SOQL and SOSL?

Accepted Answer

SOSL can search across multiple objects simultaneously, while SOQL queries one object at a time

Answer

SOSL performs text searches across multiple Salesforce objects simultaneously, whereas SOQL queries a single object (with optional subqueries for related objects).

Question 2

What is the maximum number of records SOSL returns per object in search results?

Accepted Answer

200

Answer

SOSL returns a maximum of 200 records per object included in the search results.

Question 3

Which SOQL clause is used with aggregate functions to group query results by a specified field?

Accepted Answer

GROUP BY

Answer

The GROUP BY clause in SOQL groups query results by specified fields when used alongside aggregate functions like COUNT() or SUM().

Question 4

What is a bind variable in the context of a SOQL query in Apex?

Accepted Answer

An Apex variable referenced in a SOQL query using a colon (:) prefix

Answer

A bind variable is an Apex variable prefixed with a colon in a SOQL query (e.g., WHERE Name = :myVar), safely injecting the value without risk of SOQL injection.

Question 5

Which SOQL clause filters aggregate query results AFTER the GROUP BY operation has been applied?

Accepted Answer

HAVING

Answer

The HAVING clause filters grouped/aggregated results after GROUP BY is applied, unlike WHERE which filters individual records before grouping.

(PD1) Salesforce Certified Platform Developer 1 Practice Test

(PD1) Salesforce Certified Platform Developer 1 Practice Test

PD1 SOQL and SOSL 2