Which three data types can a SOQL query return? Choose 3 answers

Which three data types can a SOQL query return? Choose 3 answers
A . sObject
B . Double
C . Long
D . List
E . Integer

View Answer

Answer: A, D, E

Explanation:

A SOQL query can return the following data types:

Option A: sObject

A SOQL query can return a single sObject when the query returns only one record.

Example:

Account acc = [SELECT Id, Name FROM Account WHERE Id = :accountId]; Option D: List

A SOQL query can return a list of sObjects when multiple records are retrieved.

Example:

List<Contact> contacts = [SELECT Id, Name FROM Contact WHERE AccountId = :accountId];

Option E: Integer

When using aggregate functions like COUNT(), SOQL can return an Integer value.

Example:

Integer contactCount = [SELECT COUNT() FROM Contact WHERE AccountId = :accountId];

Why Other Options Are Incorrect:

Option B: Double

Aggregate functions like SUM() return Decimal, not Double.

Reference: "Aggregate functions other than COUNT() must be aliased (using the AS keyword) so that they can be retrieved in the records."

― SOQL and SOSL Reference Option C: Long

Long is not a data type returned by SOQL queries.