CUET-UG SERIES

Computer-science

Relational Algebra

3 previous year questions.

Volume: 3 Ques

Yield: Medium

High-Yield Trend

3

2023

Chapter Questions
3 MCQs

01

PYQ 2023

medium

computer-science ID: cuet-ug-

Let us consider two relations Student and Major as shown in Table 1 and Table 2 respectively. Table 1 : Student Sr No. Name Course 1. Aman CS 2. Ravi ECO 3. Mohit HIS 4. Sanjay MATH Table 2 : Major Sr.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.

1

9

2

8

3

20

4

6

02

PYQ 2023

medium

computer-science ID: cuet-ug-

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.

1

1. A only

2

2. B only

3

3. C and E only

4

4. D and E only

03

PYQ 2023

medium

computer-science ID: cuet-ug-

Let us consider two relations HISTORY and SCIENCE as depicted in the following Tables 1 and 2 respectively: Table 1: HISTORY SNo NAME CLASS 1 MOHAN 6A 2 SANJAY 6B 3 YOGESH 7A Table 2: SCIENCE SNo NAME CLASS 1 NARESH 6B 2 SANJAY 6B 3 YOGESH 7A What is the output of HISTORY - SCIENCE?

1

SNo NAME CLASS 1 MOHAN 6A

2

SNo NAME CLASS 1 MOHAN 6A 2 SANJAY 6B 3 YOGESH 7A

3

SNo NAME CLASS 1 NARESH 6B 2 SANJAY 6B 3 YOGESH 7A

4

SNo NAME CLASS 1 NARESH 6B

Official Solution

Correct Option: (1)

To find the result of the set difference operation HISTORY - SCIENCE, follow these steps: 1. The set difference operation will return rows from the HISTORY table that are not present in the SCIENCE table. 2. Compare each row from HISTORY with every row in SCIENCE. 3. Identify rows in HISTORY with no matching row in SCIENCE based on 'NAME' and 'CLASS'. The rows in HISTORY are: - (1, MOHAN, 6A) - (2, SANJAY, 6B) - (3, YOGESH, 7A) The rows in SCIENCE are: - (1, NARESH, 6B) - (2, SANJAY, 6B) - (3, YOGESH, 7A) By comparing, - (1, MOHAN, 6A) is present in HISTORY but not in SCIENCE. - (2, SANJAY, 6B) is present in both tables. - (3, YOGESH, 7A) is present in both tables. Thus, the only row not present in SCIENCE is: SNo NAME CLASS 1 MOHAN 6A