Recent questions tagged joins / GATE Overflow for GATE CSE

0 votes

2 answers

31

#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)

Here are two relations, R(A,B) and S(C,D). Their current values are:R =AB12345678S =CD210412614816Compute the result of the query:SELECT A, D FROM R, S WHERE B+C = 10Iden...

Mubashirulislam

418 views

Mubashirulislam asked May 5, 2017

0 votes

2 answers

32

#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.

Here are three relations, R(a,b), S(a,b), and T(a,b). Their current values are:RSTab00011011ab00011011ab00011011Compute the result of the query:SELECT R.a, R.b, S.b, T.b ...

Mubashirulislam

805 views

Mubashirulislam asked May 5, 2017

0 votes

0 answers

33

#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

The latest scores from the Japanese Baseball League are in the table with schemaScores(Team, Opponent, RunsFor, RunsAgainst)The data in this table is as follows:TeamOppon...

Mubashirulislam

624 views

Mubashirulislam asked May 5, 2017

10 votes

2 answers

34

Test by Bikram | Mock GATE | Test 3 | Question: 30
Consider three tables with the following number of tuples in each: $X$\left ( a,b,c \right )$ $= 100$ || $Y$\left ( a,d,e \right )$ $= 80$ || $Z$\left ( x,d,f \right )$ $= 90$ Tuples in $X$ and $ ... value of attribute '$d$' $= 70$. The maximum number of tuples in ( $X$ left outer join $Y$ ) full outer join $Z$ is ________.

Consider three tables with the following number of tuples in each:$X$$\left ( a,b,c \right )$ $= 100$ || $Y$$\left ( a,d,e \right )$ $= 80$ || $Z$$\left ( x,d,f \...

Bikram

865 views

Bikram asked Feb 9, 2017

0 votes

0 answers

35

MadeEasy Subject Test: Databases - Joins

vaishali jhalani

444 views

vaishali jhalani asked Feb 2, 2017

0 votes

0 answers

36

MadeEasy Subject Test: Databases - Joins
Maximum no. of possible records in the result of the following expression is?

Maximum no. of possible records in the result of the following expression is?

Kai

233 views

Kai asked Jan 24, 2017

0 votes

1 answer

37

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??

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 nat...

sourojit

244 views

sourojit asked Dec 24, 2016

2 votes

2 answers

38

UGC NET CSE | December 2015 | Part 3 | Question: 63
Consider the following three tables $R, S$ and $T.$ In this question, all the join operations are natural joins $(\bowtie )$. $(\pi )$ ... (a) (b) (c) (d)

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 re...

go_editor

4.2k views

go_editor asked Aug 11, 2016

0 votes

1 answer

39

MadeEasy Test Series: Databases - Joins
plz explain ..is natural join commutative and associative.

plz explain ..is natural join commutative and associative.

vikas khuswaha

466 views

vikas khuswaha asked Jan 25, 2016

48 votes

4 answers

40

GATE IT 2005 | Question: 82b
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 ... outer loop, the reduction in number of block accesses required for reading the data will be $0$ $30400$ $38400$ $798400$

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 ...

Ishrat Jahan

16.4k views

Ishrat Jahan asked Nov 3, 2014

51 votes

3 answers

41

GATE IT 2005 | Question: 82a
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 ... to be used in outer loop, the number of block accesses required for reading the data are $800000$ $40080$ $32020$ $100$

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 ...

Ishrat Jahan

8.7k views

Ishrat Jahan asked Nov 3, 2014

42 votes

4 answers

42

GATE IT 2006 | Question: 14
Consider the relations $r_{1}\text{(P, Q, R)}$ and $r_{2}\text{(R, S, T)}$ with primary keys $\text{P}$ and $\text{R}$ respectively. The relation $r_{1}$ contains $2000$ tuples and $r_{2}$ contains $2500$ tuples. The maximum size of the join $r_1⋈ r_2$ is : $2000$ $2500$ $4500$ $5000$

Consider the relations $r_{1}\text{(P, Q, R)}$ and $r_{2}\text{(R, S, T)}$ with primary keys $\text{P}$ and $\text{R}$ respectively. The relation $r_{1}$ contains $2000$ ...

Ishrat Jahan

17.5k views

Ishrat Jahan asked Oct 31, 2014

60 votes

4 answers

43

GATE IT 2007 | Question: 68
Consider the following relation schemas : b-Schema = (b-name, b-city, assets) a-Schema = (a-num, b-name, bal) d-Schema = (c-name, a-number) Let branch, account and depositor be respectively instances of the above schemas. Assume that account and ... depositor) Пc-name (σb-city = "Agra" branch ⋈ (σb-city = "Agra" ⋀ bal < 0 account ⋈ depositor))

Consider the following relation schemas :b-Schema = (b-name, b-city, assets)a-Schema = (a-num, b-name, bal)d-Schema = (c-name, a-number)Let branch, account and depositor ...

Ishrat Jahan

13.0k views

Ishrat Jahan asked Oct 30, 2014

70 votes

6 answers

44

GATE CSE 2012 | Question: 50
Consider the following relations $A, B$ and $C:$ ... is the same as that of $A$. $(A\cup B)\bowtie _{A.Id > 40 \vee C.Id < 15} C$ $7$ $4$ $5$ $9$

Consider the following relations $A, B$ and $C:$$$\overset{\text{A}}{\begin{array}{|c|c|c|} \hline \text {ID} & \text {Name} & \text {Age} \\\hline\text{12}& \text{Arun}...

gatecse

29.4k views

gatecse asked Sep 29, 2014

45 votes

6 answers

45

GATE CSE 2014 Set 2 | Question: 30
Consider a join (relation algebra) between relations $r(R)$ and $s(S)$ using the nested loop method. There are $3$ ... $s(S)$ is more than $0.5$. join selection factor between $r(R)$ and $s(S)$ is less than $0.5$.

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 w...

go_editor

20.9k views

go_editor asked Sep 28, 2014

64 votes

7 answers

46

GATE CSE 2004 | Question: 14
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 ... Student * Enroll), where *' denotes natural join? $8, 8$ $120, 8$ $960, 8$ $960, 120$

Consider the following relation schema pertaining to a students database:Students (rollno, name, address)Enroll (rollno, courseno, coursename)where the primary keys are s...

Kathleen

28.9k views

Kathleen asked Sep 18, 2014

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