Performance interview questions

1. A.the optimization where multiple insert, update, or delete statements are sent to the database in fewer round trips on save
2. B.a query whose translation is cached explicitly via a delegate so repeated execution skips the expression-compilation overhead
3. C.an option that loads a query and its collection includes as several separate SQL statements to avoid the row explosion of a single join
4. D.the method, added in version 7, that issues a bulk set-based update directly against the database without loading or tracking the affected rows

Answer + AI explanation with Pro

1. A.batching
2. B.ExecuteUpdate
3. C.split query
4. D.compiled query

Answer + AI explanation with Pro

1. A.compiled query — the optimization where multiple insert, update, or delete statements are sent to the database in fewer round trips on save
2. B.compiled query — a query whose translation is cached explicitly via a delegate so repeated execution skips the expression-compilation overhead
3. C.compiled query — an option that loads a query and its collection includes as several separate SQL statements to avoid the row explosion of a single join
4. D.compiled query — the method, added in version 7, that issues a bulk set-based update directly against the database without loading or tracking the affected rows

Answer + AI explanation with Pro

1. A.a query whose translation is cached explicitly via a delegate so repeated execution skips the expression-compilation overhead
2. B.the method, added in version 7, that issues a bulk set-based update directly against the database without loading or tracking the affected rows
3. C.an option that loads a query and its collection includes as several separate SQL statements to avoid the row explosion of a single join
4. D.the optimization where multiple insert, update, or delete statements are sent to the database in fewer round trips on save

Answer + AI explanation with Pro

1. A.compiled query
2. B.split query
3. C.ExecuteUpdate
4. D.batching

Answer + AI explanation with Pro

1. A.split query — the method, added in version 7, that issues a bulk set-based update directly against the database without loading or tracking the affected rows
2. B.split query — the optimization where multiple insert, update, or delete statements are sent to the database in fewer round trips on save
3. C.split query — a query whose translation is cached explicitly via a delegate so repeated execution skips the expression-compilation overhead
4. D.split query — an option that loads a query and its collection includes as several separate SQL statements to avoid the row explosion of a single join

Answer + AI explanation with Pro

1. A.a query whose translation is cached explicitly via a delegate so repeated execution skips the expression-compilation overhead
2. B.the optimization where multiple insert, update, or delete statements are sent to the database in fewer round trips on save
3. C.the method, added in version 7, that issues a bulk set-based update directly against the database without loading or tracking the affected rows
4. D.an option that loads a query and its collection includes as several separate SQL statements to avoid the row explosion of a single join

Answer + AI explanation with Pro

1. A.compiled query
2. B.batching
3. C.split query
4. D.ExecuteUpdate

Answer + AI explanation with Pro

1. A.batching — a query whose translation is cached explicitly via a delegate so repeated execution skips the expression-compilation overhead
2. B.batching — the optimization where multiple insert, update, or delete statements are sent to the database in fewer round trips on save
3. C.batching — an option that loads a query and its collection includes as several separate SQL statements to avoid the row explosion of a single join
4. D.batching — the method, added in version 7, that issues a bulk set-based update directly against the database without loading or tracking the affected rows

Answer + AI explanation with Pro

1. A.an option that loads a query and its collection includes as several separate SQL statements to avoid the row explosion of a single join
2. B.a query whose translation is cached explicitly via a delegate so repeated execution skips the expression-compilation overhead
3. C.the optimization where multiple insert, update, or delete statements are sent to the database in fewer round trips on save
4. D.the method, added in version 7, that issues a bulk set-based update directly against the database without loading or tracking the affected rows

Answer + AI explanation with Pro

1. A.batching
2. B.ExecuteUpdate
3. C.compiled query
4. D.split query

Answer + AI explanation with Pro

1. A.ExecuteUpdate — the optimization where multiple insert, update, or delete statements are sent to the database in fewer round trips on save
2. B.ExecuteUpdate — a query whose translation is cached explicitly via a delegate so repeated execution skips the expression-compilation overhead
3. C.ExecuteUpdate — the method, added in version 7, that issues a bulk set-based update directly against the database without loading or tracking the affected rows
4. D.ExecuteUpdate — an option that loads a query and its collection includes as several separate SQL statements to avoid the row explosion of a single join

Answer + AI explanation with Pro