Figuer:
-The following operation should be performed in AA:
A) Sort(CI
B) Sort(MAK
C) Merge join
D) Restriction operations

Question

Figuer: 
-The following operation should be performed in AA:
A) Sort(CI
B) Sort(MAK
C) Merge join 
D) Restriction operations

Quizplus · Accepted Answer

Merge join combines two sorted sets based on a join condition, which is ideal for this situation where we need to join the two sorted sets based on the car model's MAKE and CID. Sorting the sets before performing the merge join can further optimize the operation but is not necessary. The restriction operations could be useful if we needed to filter the records based on specific conditions, but it is not required in this scenario.

Figuer: -The Following Operation Should Be Performed in AA