IT Project Engineer Interview Questions and Answers

You can write only one SQL query in each case of a switch statement.

• Each case in a switch statement can only contain one SQL query.

• If you need to execute multiple SQL queries, you can use separate switch cases or other control structures.

• Example: switch (variable) { case 1: query1; break; case 2: query2; break; default: defaultQuery; }

SOQL queries in a for loop should be avoided due to governor limits

• Avoid writing SOQL queries inside for loops to prevent hitting governor limits

• Use collections like lists or maps to query data outside of loops

• Limit the number of SOQL queries to stay within governor limits