Oracle
1Z0-071 · Question #269
Which three are true about multitable INSERT statements? (Choose three.)
The correct answer is A. They can be performed on external tables using SQL* Loader. B. They can be performed on relational tables. C. They can be performed only by using a subquery. See the full explanation below for the reasoning.
Question
Which three are true about multitable INSERT statements? (Choose three.)
Options
- AThey can be performed on external tables using SQL* Loader.
- BThey can be performed on relational tables.
- CThey can be performed only by using a subquery.
- DThey can insert each computed row into more than one table.
- EThey can be performed on views.
- FThey can be performed on remote tables.
How the community answered
(48 responses)- A81% (39)
- D10% (5)
- E6% (3)
- F2% (1)
Community Discussion
No community discussion yet for this question.