Multiple choice

The following INSERT statement was issued:

INSERT /* +APPEND */ INTO arch.curr_order_hist

SELECT * FROM ord.curr_order;

Which of the following types 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 directs Oracle to perform a Direct-Load insert, which bypasses the buffer cache and writes data directly to datafiles, significantly improving performance for large inserts. This is different from Conventional insert (uses buffer cache) and Parallel Direct-Load (requires parallel execution). The hint makes Oracle treat the insert as a direct-path operation.

Keep practicing — related questions