Multiple choice technology

When insert or load is aborted

  1. Records inserted till that point are visible to the user

  2. Records inserted till that point are not visible to the user

  3. Records inserted till that point is physically delete from the table

  4. None of the above

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

When an insert or load operation is aborted, any records that were inserted during that transaction are not visible to other users. The transaction is rolled back completely, maintaining atomicity - either all records are visible or none are, preserving data consistency.