Question:
What is the result of a Cartesian Product (×) between two relations R(A, B) and S(C, D)?
What is the result of a Cartesian Product (×) between two relations R(A, B) and S(C, D)?
Show Hint
Cross join merges the columns of both relations and multiplies the row counts.
Updated On: Jul 2, 2026
- A relation with the same number of tuples as S
- A relation with attributes (A, B, C, D)
- A relation with the same number of tuples as R
- A relation with fewer tuples than R and S combined
Show Solution
Verified By Collegedunia
The Correct Option is B
Solution and Explanation
Step 1: The Cartesian product pairs every tuple of R with every tuple of S. So the number of resulting tuples is \( |R| \times |S| \), not equal to just \(|R|\) or \(|S|\).
Step 2: The schema of the result is the union of the attributes of both relations. R has (A, B) and S has (C, D), so the result has all four columns (A, B, C, D).
Step 3: This rules out the tuple-count options. The correct description is the one about attributes (A, B, C, D).
Step 2: The schema of the result is the union of the attributes of both relations. R has (A, B) and S has (C, D), so the result has all four columns (A, B, C, D).
Step 3: This rules out the tuple-count options. The correct description is the one about attributes (A, B, C, D).
Was this answer helpful?
0
0
Top CPET Computer Science Questions
- Which of the following is a key reason for choosing DRAM over SRAM for main memory?
- Which of the following components in an FPGA is responsible for implementing combinational and sequential logic?
- What is the main purpose of declaring a base class as virtual in multiple inheritance?
- What happens if a class contains at least one pure virtual function?
- What happens if a derived class defines a function with the same name as a base class function, but with a different parameter list?
View More Questions
Top CPET Questions
- Which of the following is a key reason for choosing DRAM over SRAM for main memory?
- Which of the following components in an FPGA is responsible for implementing combinational and sequential logic?
- What is the main purpose of declaring a base class as virtual in multiple inheritance?
- What happens if a class contains at least one pure virtual function?
- What happens if a derived class defines a function with the same name as a base class function, but with a different parameter list?
View More Questions