Multiple choice

The following INSERT statement was issued:

INSERT /* +APPEND */ INTO arch.curr_order_hist

SELECT * FROM ord.curr_order;

Which type of INSERT is performed?

  1. Conventional

  2. Direct-Load

  3. Parallel Direct-Load

  4. Serial-Conventional
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The APPEND hint enables Direct-Load INSERT, which bypasses the buffer cache and writes data directly to datafiles. This is much faster than conventional path INSERT which uses the buffer cache. Option C (Parallel) is wrong because no parallel hint was used; options A and D describe conventional path inserts.

Keep practicing — related questions