Oracle Database SQL — Question 82

Which three are true about multitable INSERT statements? (Choose three.)

Answer options

• A. They can insert each computed row into more than one table.
• B. They can be performed on remote tables.
• C. They can be performed on external tables using SQL*Loader.
• D. They can be performed on views.
• E. They can be performed only by using a subquery.
• F. They can be performed on relational tables.

Correct answer: A, E, F

Explanation

The correct answers are A, E, and F because multitable INSERT statements allow inserting into multiple tables simultaneously, can only be performed using a subquery, and are applicable to relational tables. Options B, C, and D are incorrect since multitable INSERT statements do not support operations on remote or external tables, nor can they be performed directly on views.