The join operation can be defined as

2008

Answer: A. a cartesian product of two relations followed by a selection — The join operation is used to combine rows from two or more tables based on a related column between them.

A.
a cartesian product of two relations followed by a selection
B.
a cartesian product of two relations
C.
a union of two relations followed by cartesian product of the two relations
D.
a union of two relations

Attempted by 685 students.

Show answer & explanation

Correct answer: A

The join operation is used to combine rows from two or more tables based on a related column between them.

A video solution is available for this question — log in and enroll to watch it.

Explore the full course: Iocl Engineers Officers Grade A Paper 2