Question:
Let us consider two relations Student and Major as shown in Table 1 and Table 2 respectively.
Table 1 : StudentSr No. Name Course 1. Aman CS 2. Ravi ECO 3. Mohit HIS 4. Sanjay MATH
Table 2 : MajorSr.No Name Course 1. Sanjay MATH 2. Abhay ENG 3. Sita HINDI 4. Aman CS 5. Ravi ECO
How many Tuples will be in the result table after Student U Major operation.
Let us consider two relations Student and Major as shown in Table 1 and Table 2 respectively.
Table 1 : Student
Table 2 : Major
How many Tuples will be in the result table after Student U Major operation.
Table 1 : Student
| Sr No. | Name | Course |
| 1. | Aman | CS |
| 2. | Ravi | ECO |
| 3. | Mohit | HIS |
| 4. | Sanjay | MATH |
| Sr.No | Name | Course |
| 1. | Sanjay | MATH |
| 2. | Abhay | ENG |
| 3. | Sita | HINDI |
| 4. | Aman | CS |
| 5. | Ravi | ECO |
Updated On: Feb 21, 2026
- 9
- 8
- 20
- 6
Hide Solution
Verified By Collegedunia
The Correct Option is D
Solution and Explanation
The correct option is (D) :6.
Was this answer helpful?
0
0
Top CUET Computer Science Questions
- Given table 'StudAtt' with structure as (Rno, Attdate, Attendance). Identify the suitable command to add a primary key to the table after creation.
Note: We want to make both Rno and Attdate columns as primary key. Given the following table:
ENO SALARY A101 4000 B109 NULL C508 6000 A305 2000 State the output of the following query:
SELECT COUNT(SALARY) FROM EMPLOYEE;
- The SELECT command when combined with DISTINCT clause is used to:
- Match List-I with List-II:
List-I (Aggregate function) List-II (Description) (A) count(marks)(III) Count all non null values of marks column (B) count()(I) Count all rows (C) avg(marks)(II) Finding average of non null values of marks (D) sum(marks)(IV) Finding sum of all marks Give the output of the query: SELECT MONTH("2010-03-05");
View More Questions
Top CUET Relational Algebra Questions
- Which of the following statement(s) is/are true?
A. Selection operation yields horizontal subset of a relation.
B. Selection operation yields vertical subset of a relation.
C. Union operator can work on relation with different degree.
D. Intersection and Cartesian product operations are not binary.
E. A record is a column on a datasheet.- CUET (UG) - 2023
- Computer Science
- Relational Algebra
- Let us consider two relations HISTORY and SCIENCE as depicted in the following Tables 1 and 2 respectively:
Table 1: HISTORYSNo NAME CLASS 1 MOHAN 6A 2 SANJAY 6B 3 YOGESH 7A
Table 2: SCIENCESNo NAME CLASS 1 NARESH 6B 2 SANJAY 6B 3 YOGESH 7A
What is the output of HISTORY - SCIENCE?- CUET (UG) - 2023
- Computer Science
- Relational Algebra
Top CUET Questions
- Find the ratio of de-Broglie wavelengths of deuteron having energy E and \(\alpha\)-particle having energy 2E :
- CUET (UG) - 2026
- Dual nature of radiation and matter
- Match List-I with List-II \[ \begin{array}{|l|l|} \hline \textbf{List-I} & \textbf{List-II} \\ \hline (A) \; \text{Clostridium butylicum} & (I) \; \text{Lactic acid} \\ \hline (B) \; \text{Aspergillus niger} & (II) \; \text{Butyric acid} \\ \hline (C) \; \text{Acetobacter aceti} & (III) \; \text{Citric acid} \\ \hline (D) \; \text{Lactobacillus} & (IV) \; \text{Acetic acid} \\ \hline \end{array} \]
- Calculate the molality of KI if the density of 20% (mass/mass) aqueous solution of KI is (1)202 g mL$^{-1}$.
(Molar mass of KI is 166 g mol$^{-1}$)- CUET (UG) - 2025
- Mole concept and Molar Masses
- Find the correct statement/statements. (A) Goods which are consumed together are called complementary goods.
(B) The market demand curve can be derived as a vertical summation of the individual demand curves.
(C) Price elasticity of demand is a measure of the responsiveness of the demand for a good to changes in its price.
(D) If the consumer’s preferences change in favor of a good, the demand curve for such a good shifts leftward.
- CUET (UG) - 2025
- Demand analysis
- The value of van't Hoff factor, i, for CH₃COOH solution in water will be
- CUET (UG) - 2025
- General Chemistry
View More Questions