Multiple choice technology packaged enterprise solutions

For bulk insert, inserted rows are buffered and sent to the database server

  1. For every row insert

  2. For every 3 minutes

  3. Inserted rows are not buffered

  4. only when the buffer is full or a commit occurs
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Bulk insert optimization buffers rows in memory and flushes them to the database server only when the buffer is full or when an explicit commit occurs. This reduces network round-trips significantly compared to sending individual rows.

AI explanation

For performance, database drivers commonly accumulate ('buffer') multiple inserted rows in memory and only send them to the server as a batch once the buffer reaches capacity or a commit is issued, rather than making a round-trip for every single row. This batching is the whole point of bulk insert — sending one row at a time or on a fixed timer would defeat its performance purpose.

Keep practicing — related questions