IBM Exam C1000-065 Topic 9 Question 19 Discussion

Actual exam question for IBM's C1000-065 exam

Question #: 19
Topic #: 9

In a Data Module a developer creates a joined view from two tables (a and b) and then joins this to another table (c). What would be the execution logic in the database?

AAll queries are collapsed and a standard join across all three tables (a, b, c) is performed.

BThe columns used in table (c) are are joined on the key to table (b) first and then the results are post-joined to table (a).

CIt makes no difference to the execution as a joined view is only used to group data items in a logical manner to help the business user find their data.

DThe joined view (a and b) is evaluated and all results are then post-joined to the other table (c).

Show Suggested Answer

Suggested Answer: D

by Bernardine at May 07, 2022, 02:24 PM

Limited Time Offer

25%

Off

Get Premium C1000-065 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

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