Which two are true about multiple table INSERT statements?
A.
They always use subqueries.
B.
They can transform a row from a source table into multiple rows in a target table.
C.
The conditional INSERT FIRST statement always inserts a row into a single table.
D.
The conditional INSERT ALL statement inserts rows into a single table by aggregating source rows.
E.
The unconditional INSERT ALL statement must have the same number of columns in both the source and target tables.
The Answer Is:
B, E
This question includes an explanation.
Explanation:
B: True. Multiple table insert statements, specifically the conditional INSERT ALL, can transform a single row from the source table into multiple rows in one or more target tables depending on the conditions specified in the WHEN clauses.
E: True. The unconditional INSERT ALL statement will insert rows into multiple target tables without any conditions. However, it does not require the same number of columns in both the source and target tables. The INSERT ALL syntax allows you to specify different columns for each target table into which rows will be inserted.
Multiple table insert operations allow for complex insert scenarios, where based on the data, one can insert into different tables or multiple times into the same table based on different conditions.
References:Oracle SQL reference details the use of INSERT ALL and INSERT FIRST clauses for inserting into multiple tables based on conditions specified.
1z0-071 PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 60% Discount on All Products,
Use Coupon: "8w52ceb345"