IBM
P2090-050 · Question #19
P2090-050 Question #19: Real Exam Question with Answer & Explanation
Sign in or unlock P2090-050 to reveal the answer and full explanation for question #19. The question stem and answer options stay visible for context.
Question
Click on the exhibit. Given the following query: SELECT * FROM TableA, TableB WHERE TableA.c_custkey = TableB.o_custkey; What type of join processing will occur when the query is executed?
Exhibit
Options
- ACollocation hash join processing
- BDistributed hash join processing
- CBroadcast sort merge join processing
- DReplication sort merge join processing
Unlock P2090-050 to see the answer
You've previewed enough free P2090-050 questions. Unlock P2090-050 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.