Conventional Insert reuses free space in table - Oracle Tables

Q.  Which INSERT operation does the database reuses free space in the table, interleaving newly inserted data with the existing data and during such operations, the database also maintains referential integrity constraints?
- Published on 12 Aug 15

a. Direct-path INSERT
b. Conventional Insert
c. Both A & B
d. None of the above

ANSWER: Conventional Insert

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 01 Sep 15
    - Oracle inserts data into a table in one of two ways:

    - Conventional insert operations - Oracle reuses free space in the table, interleaving newly inserted data with existing data.
    - During such operations, Oracle also maintains referential integrity constraints.

    - Direct-path INSERT operations - Oracle appends the inserted data after existing data in the table.
    - Data is written directly into datafiles, bypassing the buffer cache.
    - Free space in the existing data is not reused, and referential integrity constraints are ignored.
    - These procedures combined can enhance performance.

    - You can implement direct-path INSERT operations by using direct-path INSERT statements or by using Oracle's direct-path loader utility, SQL*Loader.

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲