Multiple choice technology databases

For Fast load script to be restartable which of the following should hold true?

  1. Target table should not be created in the script

  2. target table should be created in the script

  3. Error tables should not be dropped in the script

  4. Checkpoint should be declared in the script

  5. Target table should not be dropped in the script
Reveal answer Fill a bubble to check yourself
A,C,D,E Correct answer
Explanation

Fast Load restartability requires maintaining the state across runs. The target and error tables must exist before the script runs and persist after. Dropping them would lose restart information. Checkpoints provide recovery points so FL can resume from the last successful point rather than starting over.

Keep practicing — related questions