Recent activity by Mubashirulislam / GATE Overflow for GATE CSE

1 answer

1

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

Suppose relations R(A,B) and S(B,C,D) have the tuples shown below:R =AB123456S =BCD246468479Compute the result of the join query:SELECT A, R.B, S.B, C, D FROM R, S WHERE ...

456 views

commented May 5, 2017

2 answers

2

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

418 views

commented May 5, 2017

2 answers

3

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

Suppose relations R(A,B) and S(B,C,D) have the tuples shown below:R =AB123456S =BCD246468479Compute the result of the join query:SELECT A, R.B, C, D FROM R, S WHERE R.B =...

1.2k views

commented May 5, 2017

2 answers

4

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

805 views

asked May 5, 2017

0 answers

5

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

624 views

asked May 5, 2017

1 answer

6

#newgradiance #toc #dfa
Which automata define the same language? Note: (b) and (d) use transitions on strings. You may assume that there are non-accepting intermediate states, not shown, that are in the middle of these transitions, or just accept the extension to the conventional finite automaton that allows ... the start state to an accepting state. a) c and d b) a and c c) b and d d) a and d

Which automata define the same language? Note: (b) and (d) use transitions on strings. You may assume that there are non-accepting intermediate states, not shown, that ar...

471 views

asked Mar 20, 2017

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