What will occur when two tables are joined together and the data is NOT collocated?

A.
“No data movement is required.

B.
“A merge join operation will be performed.

C.
“A cluster based join method is performed.

D.
“Data is dynamically redistributed or broadcasted.

Explanation: