IBM Exam C2090-632 Topic 1 Question 2 Discussion

Actual exam question for IBM's C2090-632 exam

Question #: 2
Topic #: 1

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

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

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

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

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

Show Suggested Answer

Suggested Answer: B

by Eladia at Dec 29, 2022, 10:31 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!