SAP
C_SASEAA_15 · Question #49
For a full-merge join which of the following are TRUE? (Choose two.)
The correct answer is B. Tables being joined have useful indexes on join columns E. Tables do not need to be sorted but can be merged using indexes. See the full explanation below for the reasoning.
Question
For a full-merge join which of the following are TRUE? (Choose two.)
Options
- ASort inner table in join order, then merge with left outer table
- BTables being joined have useful indexes on join columns
- CSort outer table in join order, then merge with the right inner table
- DSort both tables, then merge
- ETables do not need to be sorted but can be merged using indexes
How the community answered
(42 responses)- A2% (1)
- B71% (30)
- C10% (4)
- D17% (7)
Community Discussion
No community discussion yet for this question.