How many Accounts will be inserted by the following block of code?

How many Accounts will be inserted by the following block of code?

A . 100
B . 0
C . 500
D . 150

View Answer

Answer: D

Explanation:

Understanding the Code:

for (Integer i = 0; i < 500; i++) {

Account a = new Account (Name=’New Account ‘ + i);

insert a;

}

What the Code Does:

Loops from i = 0 to i = 499 (total of 500 iterations).

In each iteration:

Creates a new Account record with the name ‘New Account ‘ + i.

Performs an insert DML operation for each account.

Salesforce Governor Limits:

DML Statements Limit:

Maximum of 150 DML statements per Apex transaction.

Reference: Apex Governor Limits – DML Statements

Analyzing the Code Against Limits:

Number of DML Statements Used:

The code performs one DML statement per iteration.

Total DML statements attempted: 500.

Governor Limit Exceeded:

After 150 DML statements, the code exceeds the limit.

At the 151st insert, a LimitException is thrown.

Number of Accounts Successfully Inserted:

Only the first 150 accounts are inserted before the exception halts execution.

Option Analysis:

Option A: 100

This would imply a limit at 100 DML statements, which is incorrect.

Conclusion: Incorrect.

Option B: 0

This would suggest that no accounts are inserted, possibly due to an exception thrown before any DML operations.

Conclusion: Incorrect, as 150 accounts are inserted before hitting the limit.

Option C: 500

This would mean all accounts are inserted successfully.

Conclusion: Incorrect, because the governor limit prevents more than 150 DML statements.

Option D: 150

Matches the maximum allowed DML statements before hitting the governor limit.

Conclusion: Correct.

Optimizing the Code:

Bulk DML Operations:

Best Practice: Perform DML operations on lists rather than individual records to reduce the number

of DML statements.

Optimized Code:

List<Account> accountList = new List<Account>();

for (Integer i = 0 ; i < 500; i++) {

Account a = new Account (Name=’New Account ‘ + i);

accountList.add(a);

}

insert accountList;

Benefits:

Only one DML statement is used (insert accountList).

All 500 accounts are inserted successfully.

Reference: Apex Developer Guide – Bulk DML Operations

Final Answer

D. 150

Additional Notes:

Governor Limits Enforcement:

Salesforce enforces governor limits to ensure efficient use of resources in a multi-tenant environment.

Exceeding limits results in a runtime exception (System.LimitException) that cannot be caught.

Exception Handling:

In this scenario, a System.LimitException is thrown, which cannot be handled by try-catch blocks.

Reference: Apex Developer Guide – Uncatchable Exceptions Best Practices Summary:

Use Collections for DML Operations: Process records in bulk using lists or maps.

Avoid Loops with DML Statements: Do not place DML operations inside loops.

Reference: Apex Developer Guide – Best Practices for DML Operations