Which of the following is true of the generated native SQL below?

A.
The derived table is executed independently, using Pass-Through SQL, and then processed
locally.

B.
The derived table is used to retrieve one data set, in order to fulfill the join condition of another
data set.

C.
The parent select statement uses an inner join to directly match columns from physical tables in
the database.

D.
The outer projection list will return more columns than listed, due to extra columns retrieved in
the derived table.

Explanation: