<< Prev Question Next Question >>

Question 48/230

A developer creates an Apex Trigger with the following code block:List<Account> customers = new List<Account>();For (Order__c o: trigger.new){Account a = [SELECT Id, Is_Customer__c FROM Account WHERE Id
:o.Customer__c];a.Is_Customer__c = true;customers.add(a);}Database.update(customers, false);The developer tests the code using Apex Data Loader and successfully loads 10 Orders. Then, the developer loads 150 Orders.How many Orders are successfully loaded when the developer attempts to load the 150 Orders?

A. 1

B. 0

C. 150

D. 100

Recent Comments (The most recent comments are at the top.)

Sri - Mar 30, 2024

The answer is B. Because even though the DML statement at the end has the AllOrNone clause set to false, the code execution would not even reach that point. The SOQL query inside the for loop prevents that from happening. The exception is "System.LimitException: Too many SOQL queries: 101." I tested this in the org.

Fa3il khayr - Mar 27, 2024

Total number of SOQL queries issued1 are 100 ,

So it's D

Hari Vignes M E - Jul 04, 2023

Total number of SOQL queries issued = 100

See Salesforce limitations
https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_gov_limits.htm

IN the above soql query is used in for loop. So for each record one soql query will be consued. When 100 records are processed, the total number of SOQL queries limit will be hit and further record will be be update. As in the code database.update with false paratmeter method is using, which indicates partial success.

Abdo - Jul 04, 2023

D. 100 is the right answer

Question 48/230

Recent Comments (The most recent comments are at the top.)

LEAVE A REPLY

Download PDF File