Multiple choice technology databases

Pick the correct options about loading parameters

  1. INSERT : Loads rows only if the target table is empty

  2. APPEND: Load rows if the target table is empty or not.

  3. REPLACE: First deletes all the rows in the existing table and then, load rows.

  4. TRUNCATE: First truncates the table and then load rows.
Reveal answer Fill a bubble to check yourself
A,B,C,D Correct answer
Explanation

This multiple-choice multi-select question correctly defines SQL*Loader options: INSERT requires an empty table, APPEND adds to existing data, REPLACE deletes existing rows, and TRUNCATE truncates the table.

Keep practicing — related questions