Answer:
The correct answer for the given question is option(D) i.e Join
Explanation:
In database join combined the two table into single tuple on the basis of some common value between the two relation.
Intersection means it return only those rows which are common in both relation thats why option(A) is wrong.
Select are used to fetch the data from database thats why option(B) is wrong
Union means it combines all the tuple between the two relation into single relation thats why option(C) is wrong.
So the correct answer is join which combine two relation by merging pairs of tuples, one from each relation, into a single tuple.
It should be noted that join operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.
Join operation can be regarded as a vast and effective operation which involves combination of two relations by merging pairs of tuples.
This is done by taking one from each relation to make single tuple.
Learn more about operation at:
https://brainly.com/question/1594289
