In a Merge-Scan Join ____

Multiple Choice

In a merge-scan join ____.

A) neither of the two join attributes has to be in sorted order or has to have an index built over it
B) one of the two join attributes either has to be in sorted order or has to have an index built over it
C) both of the join attributes have to be in sorted order or have to have indexes built over them
D) the only requirement is that every row of one table is compared against every row of the other table looking for a match on the join attributes.
E) None of the above.