The Gateway to Computer Science Excellence
For all GATE CSE Questions
Toggle navigation
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
Recent questions tagged joins
0
votes
0
answers
1
Raghuramkrishnan Exercise4.3 question 11 page no127 Relational Algebra
Suppliers(sid, sname, address) Parts(pid, pname, color) Catalog(sid, pid, cost) Find the pids of the most expensive parts supplied by suppliers named Yosemite Sham
asked
May 8, 2019
in
Databases
by
aditi19
Loyal
(
5.2k
points)

80
views
databases
relations
relationalalgebra
relationalcalculus
joins
0
votes
0
answers
2
Raghuramkrishnan Exercise4.3 page127
Given relation catalog(sid, pid, cost) Find pairs of sids such that the supplier with the first sid charges more for some part than the supplier with the second sid what is the relational algebra expression for this?
asked
May 7, 2019
in
Databases
by
aditi19
Loyal
(
5.2k
points)

61
views
databases
relationalcalculus
relations
relationalalgebra
joins
0
votes
1
answer
3
Molina Exercise6.2.2 page267 SQL
Product(maker, model, type) PC(model, speed, ram, hd, price) Laptop(model, speed, ram, hd, screen, price) Find those manufacturers of at least two different computers (PC's or laptops) with speeds of at least 3.0 is my query ... AND count(distinct model)>=2 UNION select maker from Product NATURAL JOIN Laptop where speed>=3 AND count(distinct model)>=2
asked
May 7, 2019
in
Databases
by
aditi19
Loyal
(
5.2k
points)

71
views
databases
sql
naturaljoin
joins
ullman
0
votes
0
answers
4
ISIPCB2015C5
Consider three relations $R_1(\underline{X},Y,Z), R_2(\underline{M},N,P),$ and $R_3(\underline{N,X})$. The primary keys of the relations are underlined. The relations have $100,30,$ and $400$ tuples, respectively. The space requirements for different attributes ... execution of the join. For, (a), Order could be anything and min. cost =$100*30*400*$total size of all the attributes.
asked
Mar 26, 2019
in
Databases
by
ankitgupta.1729
Boss
(
17.6k
points)

44
views
userisi2015
usermod
databases
joins
0
votes
1
answer
5
MadeEasy Test Series: Databases  Joins
Table T1 4000 record and 50 disk block Table T2 300 record 20 block has joined with specific condition, No index is available if nested loop join with most appropriate table in outer loop No of block access to read the data are ………. what it would be if nested block joined used?
asked
Dec 20, 2018
in
Databases
by
Abhisek Tiwari 4
Loyal
(
5.3k
points)

58
views
madeeasytestseries
databases
joins
blocknestedloopjoin
0
votes
0
answers
6
Relational Algebra from Aku paper previous year
asked
Dec 10, 2018
in
Databases
by
gatecrack
(
289
points)

117
views
relationalalgebra
databases
joins
0
votes
0
answers
7
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
Loyal
(
5.2k
points)

36
views
naturaljoin
databases
joins
outerjoin
0
votes
1
answer
8
General Doubt: Databases  Joins
A system where commutativity is considered different, in how many ways the join of n relations r1,r2, . . . ,rn can be taken?
asked
Oct 30, 2018
in
Databases
by
Shukrayani
(
73
points)

61
views
databases
joins
generaldoubt
0
votes
0
answers
9
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
(
5.2k
points)

117
views
relationalalgebra
databases
relations
relationalcalculus
joins
0
votes
1
answer
10
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
Boss
(
10.9k
points)

282
views
ugcnetjuly2018ii
database
rdbms
joins
+2
votes
1
answer
11
MadeEasy Test Series: Databases  Natural Join
Consider a relation r1(A, B, C), r2(C, D, E) and r3(F, G) with primary keys A, C and F respectively. Assume that r1 has 150 tupples, r2 has 100 tupples and r3 has 75 tupples. The number of resultant tuple in are ________.
asked
Jun 14, 2018
in
Databases
by
Na462
Loyal
(
7.1k
points)

361
views
madeeasytestseries
databases
joins
naturaljoin
+3
votes
1
answer
12
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_
(
431
points)

105
views
joins
+2
votes
0
answers
13
MadeEasy Test Series 2018: Databases  joins
How to solve this?
asked
Jan 18, 2018
in
Databases
by
Shubham Kumar Gupta
(
449
points)

144
views
databases
joins
madeeasytestseries
+2
votes
0
answers
14
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
Junior
(
939
points)

128
views
relationalalgebra
databases
relationalcalculus
joins
0
votes
2
answers
15
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
(
9
points)

112
views
databases
joins
referentialintegrity
+2
votes
0
answers
16
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.3k
points)

57
views
databases
joins
+1
vote
1
answer
17
MadeEasy Test Series: Databases  Joins
Can someone explain this question?
asked
Dec 27, 2017
in
Databases
by
rahul sharma 5
Boss
(
25.6k
points)

123
views
madeeasytestseries
databases
joins
+2
votes
2
answers
18
#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
(
8.5k
points)

312
views
general
databases
relationalalgebra
naturaljoin
joins
+1
vote
1
answer
19
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.3k
points)

325
views
relationalcalculus
joins
relations
relationalalgebra
databases
+1
vote
0
answers
20
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
(
8.5k
points)

128
views
joins
databases
naturaljoin
+1
vote
0
answers
21
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
(
8.5k
points)

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

200
views
joins
0
votes
2
answers
23
#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
(
69
points)

285
views
newgradiance
databases
sql
joins
0
votes
1
answer
24
#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
(
69
points)

150
views
newgradiance
databases
sql
joins
0
votes
2
answers
25
#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
(
69
points)

124
views
newgradiance
databases
sql
joins
0
votes
2
answers
26
#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
(
69
points)

209
views
newgradiance
databases
sql
joins
0
votes
1
answer
27
#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
(
69
points)

217
views
newgradiance
databases
sql
joins
0
votes
0
answers
28
MadeEasy Subject Test: Databases  Joins
asked
Feb 2, 2017
in
Databases
by
vaishali jhalani
Active
(
4.8k
points)

87
views
madeeasytestseries
databases
joins
0
votes
0
answers
29
MadeEasy Subject Test: Databases  Joins
Maximum no. of possible records in the result of the following expression is?
asked
Jan 24, 2017
in
Databases
by
Kai
Active
(
2.6k
points)

75
views
madeeasytestseries
databases
joins
0
votes
1
answer
30
MadeEasy Subject Test: Databases  Joins
I think the answer should be 300 because in relation Q, C and E collectively distinguish a tuple from another tuple.So there can be duplicate values in C and then the natural join of P and Q will give 300 tuples.Same case can be considered when we natural join P,Q with R. Am I correct??
asked
Dec 24, 2016
in
Databases
by
sourojit
(
115
points)

58
views
madeeasytestseries
databases
joins
Page:
1
2
next »
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
Contesting Answer Key Link Is Live Now
Answer keys are released for Gate2020
My Experience at IIT Madras and Some Insights
GATE Meetup at CSA IISC on February 29 as part of CSA Open Day
Make Rank Predictor Dynamic (Again?)
Follow @csegate
Recent questions tagged joins
Recent Blog Comments
@jlimbasiya Contesting link available only...
Hi Everyone, As anyone who has appeared for ISRO...
So the written test and interview both do not...
So,O(n^2) remains and might be 0(nlogn) further...
Ideally both should be given marks, it shouldn't...
50,833
questions
57,713
answers
199,428
comments
107,714
users