Oracle 1z0-071 2019.10最新题库&解答51-55

QUESTION 51

Choose two

Which two statements are true about conditional INSERT
ALL?

A) Each row returned by the subquery can be inserted into
only a single target table.

B) It cannot have an ELSE clause.

C) The total number of rows inserted is always equal to
the number of rows returned by the subquery

D) A single WHEN condition can be used for multiple INTO
clauses.

E) Each WHEN condition is tested for each row returned by
the subquery.

Correct Answer: CE  
D正确 DE，见下例  E 测试正确  C 多个INSERT 应该是倍数关系

解析：官档语法：

https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/INSERT.html#GUID-903F8043-0254-4EE9-ACC1-CB8AC0AF3423

https://oracle-base.com/articles/9i/multitable-inserts

conditional_insert_clause

Specify the conditional_insert_clause to perform a
conditional multitable insert. Oracle Database filters each insert_into_clause
through the corresponding WHEN condition, which determines whether that
insert_into_clause is executed. Each expression in the WHEN condition must
refer to columns returned by the select list of the subquery. A single multitable
insert statement can contain up to 127 WHEN clauses.

INSERT ALL

WHEN order_total