PD1 SOQL and SOSL 3

Question 1

What is the governor limit for total records retrieved via SOQL in a single synchronous Apex transaction?

Accepted Answer

50,000 records

Answer

10,000 records

Answer

25,000 records

Answer

100,000 records

Question 2

Why is placing a SOQL query inside a for loop considered an anti-pattern in Apex?

Accepted Answer

It causes repeated query executions that quickly exceed the 100 SOQL query governor limit

Answer

It improves performance through lazy loading of records

Answer

It automatically batches records into groups of 200 per iteration

Answer

It is required for safely processing large data sets in Apex

Question 3

Which SOQL for loop syntax is the most memory-efficient for processing large record sets in Apex?

Accepted Answer

for (List<Account> batch : [SELECT Id FROM Account])

Answer

for (Account acc : [SELECT Id FROM Account])

Answer

List<Account> accs = [SELECT Id FROM Account]; for (Account acc : accs)

Answer

Both A and B are equally memory-efficient

Question 4

What does the WITH SECURITY_ENFORCED clause in a SOQL query enforce?

Accepted Answer

It throws a QueryException if the running user lacks field-level or object-level read access

Answer

It encrypts query results before returning them to the caller

Answer

It automatically filters out records the running user cannot see based on sharing rules

Answer

It requires System Administrator profile to execute the query

Question 5

What is the purpose of the OFFSET clause in a SOQL query?

Accepted Answer

It specifies the starting row number from which to return query results, enabling pagination

Answer

It shifts numeric field values by a specified amount

Answer

It sets a timezone offset for filtering datetime fields

Answer

It defers query execution to avoid hitting governor limits

Question 6

Which Apex method is used to execute a dynamic SOQL query built as a String at runtime?

Accepted Answer

Database.query()

Answer

SOQL.execute()

Answer

Apex.query()

Answer

Database.soql()

Question 7

What is the maximum number of SOSL queries allowed per synchronous Apex transaction?

Accepted Answer

20

Answer

5

Answer

10

Answer

100