Multiple choice

The following INSERT statement was issued: INSERT /* +APPEND */ INTO arch.curr_order_hist

SELECT * FROM ord.curr_order;

What 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 in Oracle INSERT statements enables Direct-Load insert, which bypasses the buffer cache and writes data directly to data files. This method is faster than conventional path inserts and is used for bulk data loading operations. The '+' prefix indicates a hint.

Keep practicing — related questions