The Gateway to Computer Science Excellence
For all GATE CSE Questions
Toggle navigation
GATE Overflow
Facebook Login
or
Email or Username
Password
Remember
Login
Register

I forgot my password
Activity
Questions
Unanswered
Tags
Subjects
Users
Ask
Prev
Blogs
New Blog
Exams
First time here? Checkout the
FAQ
!
x
×
Close
Use the google search bar on side panel. It searches through all previous GATE/other questions. For hardcopy of previous year questions please see
here
Recent questions tagged joins
0
votes
0
answers
1
Relational Algebra from Aku paper previous year
asked
Dec 10, 2018
in
Databases
by
gatecrack
(
137
points)

63
views
relationalalgebra
databases
joins
0
votes
0
answers
2
JOIN Doubt
in case of outer join for combining two tables, if there is no common attribute does it returns cartesian product just like natural join does?
asked
Nov 2, 2018
in
Databases
by
aditi19
Active
(
2.2k
points)

20
views
naturaljoin
databases
joins
outerjoin
0
votes
0
answers
3
Relational Algebra
Online Site For practicing Relational Algebra https://dbisuibk.github.io/relax/calc.htm
asked
Oct 28, 2018
in
Databases
by
kumar.dilip
Active
(
4.8k
points)

70
views
relationalalgebra
databases
relations
relationalcalculus
joins
0
votes
1
answer
4
UGCNETJuly2018II61
In RDBMS, which type of Join returns all rows that satisfy the join condition? Inner Join Outer Join Semi Join Anti Join
asked
Jul 13, 2018
in
Others
by
Pooja Khatri
Active
(
5.1k
points)

136
views
ugcnetjuly2018ii
database
rdbms
joins
+3
votes
1
answer
5
joins
what is different types of joins and what is difference between them ? please explain with example.
asked
Jan 30, 2018
in
Databases
by
Rahul_Rathod_
Junior
(
549
points)

81
views
joins
+2
votes
0
answers
6
Relational algebra
I have two doubts: 1) A natural join B What will be the result when B don't have any tuple in it. Like in B their is relational algebra expression which is selecting Cars of green color but their is no green color car in table. What will be the ... B In above divison if B is a relational algebra expression returning nothing ( like the B in case 1). What will be the result ?
asked
Jan 14, 2018
in
Programming
by
♥_Less
Active
(
1k
points)

101
views
relationalalgebra
databases
relationalcalculus
joins
0
votes
1
answer
7
Test question
Consider the join of a relation R with a relation S. If R has 100 tuples and S has 9 tuples then the maximum and minimum sizes of the join respectively under referential integrity constraint: 9 and 0 9 and 9 9+100 and 0 9*100 and 9
asked
Dec 31, 2017
in
Databases
by
Priyendu Mori
(
13
points)

81
views
databases
joins
referentialintegrity
+2
votes
0
answers
8
Tuples
Consider a relation R(A,B,C) with the following functional dependency AC→B .A can take 200 distinct values, B can take 100 distinct values and C can take 1000 distinct values. What is the maximum and minimum possible tuples of the self join of R on C?
asked
Dec 30, 2017
in
Databases
by
Anjan
Active
(
1.7k
points)

52
views
databases
joins
+2
votes
2
answers
9
#DBMS What will be the Minimum Number of Tuples?
Say we have two relations R (a,b,c) and S (b,d,e). Now, R has 200 tuples and S has 300 tuples. What will be Minimum number of tuples when we do R ⋈ S ( ⋈ = Natural Join)?
asked
Dec 6, 2017
in
Databases
by
iarnav
Loyal
(
9.4k
points)

216
views
general
databases
relationalalgebra
naturaljoin
joins
+1
vote
1
answer
10
Relational algebra
Consider the relations r1(P, Q, R) and r2(R, S, T) with primary keys P and R respectively. The relation r1 contains 2000 tuples and r2 contains 2500 tuples. The maximum size of the join r1⋈ r2 is equal to r2⋈ r1 true or false?
asked
Dec 3, 2017
in
Databases
by
learner_geek
Active
(
3.7k
points)

253
views
relationalcalculus
joins
relations
relationalalgebra
databases
+1
vote
0
answers
11
DBMS SELF DOUBT
Let R and S be two relations with the following schema R(P−−,Q−−,R1,R2,R3) S(P−−,Q−−,S1,S2) where {P,Q} is the key for both schemas? R:{⟨"1","abc","p1","p2","p3"⟩, ⟨"2","xyz", ... ;,"q3"⟩ ⟨"2","def","q1","q2","q3"⟩ WHat is R *S? WHERE * IS NATURAL JOIN.
asked
Nov 27, 2017
in
Databases
by
iarnav
Loyal
(
9.4k
points)

107
views
joins
databases
naturaljoin
+1
vote
0
answers
12
relational algebra question
Given two union compatible relations R1(A,B) and R2(C,D), what is the result of the operation R1 ⋈ (A=C∨B=D)R2? R1∪R2 R1×R2 R1–R2 R1∩R2
asked
Nov 27, 2017
in
Databases
by
iarnav
Loyal
(
9.4k
points)

133
views
relationalalgebra
databases
relations
joins
+2
votes
1
answer
13
Relational Algebra
what is difference between full outer join and cross product?
asked
Aug 21, 2017
in
Databases
by
deepakhbtu
(
85
points)

131
views
joins
0
votes
2
answers
14
#newgradiance #dbms #sql #joins Q5
Suppose relations R(A,B) and S(B,C,D) have the tuples shown below: R = A B 1 2 3 4 5 6 S = B C D 2 4 6 4 6 8 4 7 9 Compute the result of the join query: SELECT A, R.B, C, D FROM R, S WHERE R.B = S.B Then, identify which of the following tuples is in the result. a) (1,4,7,9) b) (5,6,4,6) c) (3,4,7,9) d) (3,4,2,6)
asked
May 5, 2017
in
Databases
by
Mubashirulislam
(
89
points)

197
views
newgradiance
databases
sql
joins
0
votes
1
answer
15
#newgradiance #dbms #sql #joins Q4
Suppose relations R(A,B) and S(B,C,D) have the tuples shown below: R = A B 1 2 3 4 5 6 S = B C D 2 4 6 4 6 8 4 7 9 Compute the result of the join query: SELECT A, R.B, S.B, C, D FROM R, S WHERE R.A < S.C AND R.B < S.D Then, identify one of the tuples in the result from the list below. a) (1,2,2,6,8) b) (1,2,2,4,6) c) (3,4,4,7,8) d) (3,4,5,7,9)
asked
May 5, 2017
in
Databases
by
Mubashirulislam
(
89
points)

127
views
newgradiance
databases
sql
joins
0
votes
2
answers
16
#newgradiance #dbms #sql #joins Q3
Here are two relations, R(A,B) and S(C,D). Their current values are: R = A B 1 2 3 4 5 6 7 8 S = C D 2 10 4 12 6 14 8 16 Compute the result of the query: SELECT A, D FROM R, S WHERE B+C = 10 Identify, in the list below, the row that appears in the result. a) (7,10) b) (1,10) c) (1,12) d) (3,10)
asked
May 5, 2017
in
Databases
by
Mubashirulislam
(
89
points)

107
views
newgradiance
databases
sql
joins
0
votes
2
answers
17
#newgradiance #dbms #sql #joins Q2
Here are three relations, R(a,b), S(a,b), and T(a,b). Their current values are: R S T a b 0 0 0 1 1 0 1 1 a b 0 0 0 1 1 0 1 1 a b 0 0 0 1 1 0 1 1 Compute the result of the query: SELECT R.a, R.b, S.b, T.b FROM R, S, T WHERE R.b = S ... times it appears. a) (1,0,0,1) appears once. b) (0,0,1,1) appears twice. c) (0,1,1,1) does not appear. d) (1,1,1,0) appears once.
asked
May 5, 2017
in
Databases
by
Mubashirulislam
(
89
points)

175
views
newgradiance
databases
sql
joins
0
votes
1
answer
18
#newgradiance #dbms #sql #joins Q1
The latest scores from the Japanese Baseball League are in the table with schema Scores(Team, Opponent, RunsFor, RunsAgainst) The data in this table is as follows: Team Opponent RunsFor RunsAgainst Dragons Tigers 5 3 Carp Swallows 4 6 Bay Stars Giants 2 ... , a row of the result. a) Ham Fighters Lions b) Bay Stars Buffaloes c) Lions Marines d) Golden Eagles Lions
asked
May 5, 2017
in
Databases
by
Mubashirulislam
(
89
points)

166
views
newgradiance
databases
sql
joins
+2
votes
2
answers
19
UGCNETDec2015III63
Consider the following three tables R, S and T. In this question, all the join operations are natural joins ($\bowtie$). ($\pi$) is the projection operation of a relation: Possible answer tables for this question are also given as below: (a) (b) (c) (d)
asked
Aug 11, 2016
in
Databases
by
jothee
Veteran
(
112k
points)

1.2k
views
ugcnetdec2015iii
databases
joins
+27
votes
3
answers
20
GATE2005IT82b
A database table $T_1$ has $2000$ records and occupies $80$ disk blocks. Another table $T_2$ has $400$ records and occupies $20$ disk blocks. These two tables have to be joined as per a specified join condition that needs to be evaluated for every pair of ... the outer loop, the reduction in number of block accesses required for reading the data will be $0$ $30400$ $38400$ $798400$
asked
Nov 4, 2014
in
Databases
by
Ishrat Jahan
Boss
(
19.1k
points)

3.2k
views
gate2005it
databases
normal
joins
+29
votes
3
answers
21
GATE2005IT82a
A database table $T_1$ has $2000$ records and occupies $80$ disk blocks. Another table $T_2$ has $400$ records and occupies $20$ disk blocks. These two tables have to be joined as per a specified join condition that needs to be evaluated for every pair of ... table to be used in outer loop, the number of block accesses required for reading the data are $800000$ $40080$ $32020$ $100$
asked
Nov 4, 2014
in
Databases
by
Ishrat Jahan
Boss
(
19.1k
points)

2k
views
gate2005it
databases
normal
joins
+25
votes
2
answers
22
GATE2006IT14
Consider the relations r1(P, Q, R) and r2(R, S, T) with primary keys P and R respectively. The relation r1 contains 2000 tuples and r2 contains 2500 tuples. The maximum size of the join r1⋈ r2 is : 2000 2500 4500 5000
asked
Oct 31, 2014
in
Databases
by
Ishrat Jahan
Boss
(
19.1k
points)

2.2k
views
gate2006it
databases
joins
naturaljoin
normal
+36
votes
5
answers
23
GATE2007IT68
Consider the following relation schemas : bSchema = (bname, bcity, assets) aSchema = (anum, bname, bal) dSchema = (cname, anumber) Let branch, account and depositor be respectively instances of the above schemas. Assume that account and depositor ... ⋈ depositor) Пcname (σbcity = "Agra" branch ⋈ (σbcity = "Agra" ⋀ bal < 0 account ⋈ depositor))
asked
Oct 30, 2014
in
Databases
by
Ishrat Jahan
Boss
(
19.1k
points)

2.8k
views
gate2007it
databases
joins
relationalalgebra
normal
+34
votes
2
answers
24
GATE201250
Consider the following relations A, B and C: A Id Name Age 12 Arun 60 15 Shreya 24 99 Rohit 11 B Id Name Age 15 Shreya 24 25 Hari 40 98 Rohit 20 99 Rohit 11 C Id Phone Area 10 2200 02 99 2100 01 How many tuples does the result of the following relational algebra expression contain? Assume ... is the same as that of $A$. $(A\cup B)\bowtie _{A.Id > 40 \vee C.Id < 15} C$ 7 4 5 9
asked
Sep 29, 2014
in
Databases
by
gatecse
Boss
(
18.3k
points)

5.5k
views
gate2012
databases
joins
normal
+21
votes
2
answers
25
GATE2014230
Consider a join (relation algebra) between relations $r(R)$ and $s(S)$ using the nested loop method. There are 3 buffers each of size equal to disk block size, out of which one buffer is reserved for intermediate results. Assuming size(r(R))<size(s(S)) , the join will have fewer ... $s(S)$ is more than 0.5. join selection factor between $r(R)$ and $s(S)$ is less than 0.5.
asked
Sep 28, 2014
in
Databases
by
jothee
Veteran
(
112k
points)

4k
views
gate20142
databases
normal
joins
+36
votes
5
answers
26
GATE200414
Consider the following relation schema pertaining to a students database: Students (rollno, name, address) Enroll (rollno, courseno, coursename) where the primary keys are shown underlined. The number of tuples in the student and Enroll tables are $120$ and $8$ respectively. What are the ... in (Student * Enroll), where *' denotes natural join? $8, 8$ $120, 8$ $960, 8$ $960, 120$
asked
Sep 19, 2014
in
Databases
by
Kathleen
Veteran
(
59.8k
points)

4.8k
views
gate2004
databases
easy
joins
naturaljoin
To see more, click for the
full list of questions
or
popular tags
.
Quick search syntax
tags
tag:apple
author
user:martin
title
title:apple
content
content:apple
exclude
tag:apple
force match
+apple
views
views:100
score
score:10
answers
answers:2
is accepted
isaccepted:true
is closed
isclosed:true
Recent Posts
question on digital electronics
PSU's
Decidability Slides
AAI JE IT results out! Adv no 02/2018
Graph Theory Slides for GATECSE
Follow @csegate
Gatecse
Recent questions tagged joins
Recent Blog Comments
@
love you sir and great work Subarna and...
18th jan was the last date
anyone from west bengal plss solve above query as...
47,109
questions
51,359
answers
177,868
comments
66,688
users