Multiple choice technology databases

Conventional path load (the default) uses the SQL INSERT statement and a bind array buffer to load data into database tables. When SQL*Loader performs a conventional path load, it wont competes equally with all other processes for buffer resources. This can slow the load significantly. Extra overhead is added as SQL statements are generated, passed to Oracle, and executed. Although appropriate during normal use, this can slow bulk loads dramatically.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Conventional path loads use SQL INSERT statements and do compete with other processes for buffer resources, which can slow down loading. The statement correctly describes that this overhead makes conventional loads slower than direct path loads for bulk data operations.

Keep practicing — related questions