Multiple choice technology platforms and products

Which of the following is true about Bulk Loading

  1. Recovery can be performed

  2. Can improve performance of a session that inserts a large amount of data to a db2,sysbase,oracle or MS SQL server database.

  3. Target database can perform Rollback

  4. Similar to Normal loading
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Bulk loading bypasses database logging to significantly improve insertion performance for large datasets in databases like DB2, Oracle, or SQL Server. Because it bypasses transaction logging, rollback and standard recovery operations cannot be performed, making distractors false.

Keep practicing — related questions