Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 30 of 91

Grouping Records, Joins in SQL — Question 8

Back to all questions
8
Question

Question 8

The operation whose result contains all pairs of tuples from the two relations, regardless of whether their attribute values match.

  1. Join
  2. Cartesian product
  3. Intersection
  4. Set difference
Answer

Cartesian product

Reason — In an unrestricted join or Cartesian product of two relations, all possible combinations are formed by pairing each row from the first table with every row from the second table, regardless of whether their attribute values match. This operation returns n1 * n2 rows, where n1 is the number of rows in the first table, and n2 is the number of rows in the second table.