Multiple choice technology databases

When we should truncate the working table ?

  1. At the end of the run

  2. Beginning of next run

  3. At any point of Time

  4. Can't be done
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Working tables should be truncated at the beginning of the next run, not at the end of the current run. This allows verification that the previous run completed successfully before clearing data. Truncating at the end risks losing the working data if an error occurs before verification. The beginning of the next run ensures a clean slate while preserving the previous run's data for audit purposes.

Keep practicing — related questions