GATE DA · 2026 · DA
Question 42: Database Management and Warehousing
Give it a try, then reveal the answer to check your work.
Question 42
DAMCQ2 marksNeeds review
Consider the given relations
,
and
. The relation
has three columns
,
and
. The relation
has three columns
,
and
. The relation
has two columns
and
.Relation
: | | |
|---|---|---|
P1 | Q1 | R1 |
P2 | Q2 | R2 |
P3 | Q3 | R2 |
Relation
: | | |
|---|---|---|
P1 | Q1 | 2 |
P1 | Q2 | 5 |
P2 | Q1 | 6 |
P3 | Q3 | 1 |
Relation
: | |
|---|---|
P1 | T1 |
P3 | T2 |
P4 | T3 |
P4 | NULL |
Consider the relational algebra expression
where
denotes natural join operation.Which of the following options is the correct output for the given expression?
Your answerChoose one option.
Log in to check the answer
You can attempt this question now. Sign in to view the answer key, explanations and discussion.Log in to check answerEXPLORE & PRACTISE
Paper and topic context
See where this question comes from and choose what to practise next.
2026DA
GATE DA 2026 · Paper 1
Data Science and Artificial Intelligence · Original paper archive
- Section
- Data Science and Artificial Intelligence
- Question type
- Multiple choice (MCQ)
- Marks
- 2 marks
Practise related topics
Explore more previous year questions using this question’s imported topic tags.
data science
GATE DA previous year questions
artificial intelligence
GATE DA previous year questions
computing
GATE DA previous year questions
database management warehousing
GATE DA previous year questions
relational algebra
GATE DA previous year questions
Database Management and Warehousing
GATE DA previous year questions
Comments
Ask a question, share your approach, or help someone understand.
Log in to view the discussion
You’re not logged in. Log in or create an account to see discussions and add comments.