Databases · Relational Algebra

Official IIT answer key · IISc Bangalore · Audited Aug 2026

GATE CSE 2024 Set 1 Q35 · NAT · 1 mark

Consider the following two relations, $R(A,B)$ and $S(A,C)$ : The total number of tuples obtained by evaluating the following expression $\sigma_{B < C}(R \bowtie_{R.A=S.A} S)$ is ________

Numerical answer

Enter a value to check

Key concept

Relational Algebra

Step-by-step verified solution

Examiner trap & misconception

Topic notes

How GATE tests Relational Algebra

Relational Algebra in GATE CS is tested through both procedural evaluation (calculating the size or contents of an output relation from given instance tables) and semantic/algebraic properties (query optimization equivalences and self-join query semantics). Questions test core operators such as selection ( ), projection ( ), set union ( ), renaming ( ), and theta/equi-joins ( ). Questions alternate between 1-mark mechanical/equivalence checks and 2-mark semantic interpretation or multi-step tuple evaluations.

Full Relational Algebra guide →

More on Relational Algebra

All 4 questions on Relational Algebra →

Independent practice explanation verified by the GateAI team. GATE is conducted by the IITs; question text follows the official paper.

Databases · Relational Algebra

Official IIT answer key · IISc Bangalore · Audited Aug 2026

Take topic test

GATE CSE 2024 Set 1 Q35 · NAT · 1 mark

Consider the following two relations, $R(A,B)$ and $S(A,C)$ : The total number of tuples obtained by evaluating the following expression $\sigma_{B < C}(R \bowtie_{R.A=S.A} S)$ is ________

Numerical answer

Enter a value to check

Key concept

Relational Algebra

Step-by-step verified solution

Examiner trap & misconception

Topic notes

How GATE tests Relational Algebra

Full Relational Algebra guide →

More on Relational Algebra

All 4 questions on Relational Algebra →

Independent practice explanation verified by the GateAI team. GATE is conducted by the IITs; question text follows the official paper.

Consider the following two relations, $R(A,B)$ and $S(A,C)$ : The total number of tuples obtained by evaluating the following expression $\sigma_{B < C}(R \bowtie_{R.A=S.A} S)$ is ________

Step-by-step verified solution

Check you can still solve Relational Algebra under a clock

More from GATE CSE 2024 Set 1

More on Relational Algebra

Consider the following two relations, $R(A,B)$ and $S(A,C)$ : The total number of tuples obtained by evaluating the following expression $\sigma_{B < C}(R \bowtie_{R.A=S.A} S)$ is ________

Step-by-step verified solution

Check you can still solve Relational Algebra under a clock

More from GATE CSE 2024 Set 1

More on Relational Algebra

Consider the following two relations, R(A,B)R(A,B)R(A,B) and S(A,C)S(A,C)S(A,C): The total number of tuples obtained by evaluating the following expression σB<C(R⋈R.A=S.AS)\sigma_{B < C}(R \bowtie_{R.A=S.A} S)σB<C​(R⋈R.A=S.A​S) is ________

Step-by-step verified solution

Check you can still solve Relational Algebra under a clock

More from GATE CSE 2024 Set 1

More on Relational Algebra

Share this solution

Consider the following two relations, R(A,B)R(A,B)R(A,B) and S(A,C)S(A,C)S(A,C): The total number of tuples obtained by evaluating the following expression σB<C(R⋈R.A=S.AS)\sigma_{B < C}(R \bowtie_{R.A=S.A} S)σB<C​(R⋈R.A=S.A​S) is ________

Step-by-step verified solution

Check you can still solve Relational Algebra under a clock

More from GATE CSE 2024 Set 1

More on Relational Algebra

Share this solution

Consider the following two relations, $R(A,B)$ and $S(A,C)$ : The total number of tuples obtained by evaluating the following expression $\sigma_{B < C}(R \bowtie_{R.A=S.A} S)$ is ________

Consider the following two relations, $R(A,B)$ and $S(A,C)$ : The total number of tuples obtained by evaluating the following expression $\sigma_{B < C}(R \bowtie_{R.A=S.A} S)$ is ________