Dark Mode

Recent questions tagged joins

0 votes

1 answer

1

DBMS Join | Test Series | MadeEasy
In relational databases, the natural join of two tables: Can be equivalent to cartesian product of these two tables Is combination of union and filtered cartesian product Is combination of selection and filtered cartesian product Is combination of projection and filtered cartesian product MSQ Please describe your choice(s).

anupamsworld asked in Databases Aug 7, 2022

by anupamsworld

144 views

1 vote

1 answer

2

Self Doubt
I want to join the two tables of movies and actors and then output only those results that have gender =”F”, can you tell me where I am going wrong?

tusharb asked in Databases Mar 27, 2022

340 views

0 votes

2 answers

3

NIELIT 2017 July Scientist B (IT) - Section B: 55
A table joined with itself is called Join Self Join Outer Join Equi Join

Lakshman Patel RJIT asked in Databases Mar 30, 2020

by Lakshman Patel RJIT

531 views

0 votes

2 answers

4

NIELIT 2017 July Scientist B (IT) - Section B: 56
Consider the join of a relation $R$ with relation $S$. If $R$ has $m$ tuples and $S$ has $n$ tuples, then the maximum size of join is $mn$ $m+n$ $(m+n)/2$ $2(m+n)$

Lakshman Patel RJIT asked in Databases Mar 30, 2020

by Lakshman Patel RJIT

341 views

1 vote

2 answers

5

Raghuramkrishnan Exercise-4.3 question 11 page no-127 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

aditi19 asked in Databases May 8, 2019

922 views

0 votes

1 answer

6

Raghuramkrishnan Exercise-4.3 page-127
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?

aditi19 asked in Databases May 7, 2019

673 views

0 votes

1 answer

7

Molina Exercise-6.2.2 page-267 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

aditi19 asked in Databases May 7, 2019

1.2k views

0 votes

0 answers

8

ISI-PCB-2015-C5
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.

ankitgupta.1729 asked in Databases Mar 26, 2019

by ankitgupta.1729

402 views

0 votes

1 answer

9

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?

Abhisek Tiwari 4 asked in Databases Dec 20, 2018

by Abhisek Tiwari 4

370 views

0 votes

0 answers

10

Relational Algebra from Aku paper previous year

gatecrack asked in Databases Dec 10, 2018

470 views

0 votes

0 answers

11

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?

aditi19 asked in Databases Nov 2, 2018

226 views

0 votes

1 answer

12

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?

Shukrayani asked in Databases Oct 30, 2018

287 views

0 votes

0 answers

13

Relational Algebra
Online Site For practicing Relational Algebra https://dbis-uibk.github.io/relax/calc.htm

kumar.dilip asked in Databases Oct 28, 2018

418 views

0 votes

5 answers

14

UGC NET CSE | July 2018 | Part 2 | Question: 61
In RDBMS, which type of Join returns all rows that satisfy the join condition? Inner Join Outer Join Semi Join Anti Join

Pooja Khatri asked in Databases Jul 13, 2018

by Pooja Khatri

1.2k views

5 votes

1 answer

15

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

Na462 asked in Databases Jun 14, 2018

by Na462

3.6k views

3 votes

1 answer

16

joins
what is different types of joins and what is difference between them ? please explain with example.

Rahul_Rathod_ asked in Databases Jan 30, 2018

by Rahul_Rathod_

516 views

2 votes

0 answers

17

MadeEasy Test Series 2018: Databases - joins
How to solve this?

Shubham Kumar Gupta asked in Databases Jan 18, 2018

by Shubham Kumar Gupta

280 views

2 votes

0 answers

18

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 ?

♥_Less asked in Programming Jan 14, 2018

338 views

0 votes

2 answers

19

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

Priyendu Mori asked in Databases Dec 31, 2017

by Priyendu Mori

360 views

2 votes

0 answers

20

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?

Anjan asked in Databases Dec 30, 2017

by Anjan

165 views

1 vote

1 answer

21

MadeEasy Test Series: Databases - Joins
Can someone explain this question?

rahul sharma 5 asked in Databases Dec 27, 2017

by rahul sharma 5

256 views

3 votes

2 answers

22

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

iarnav asked in Databases Dec 6, 2017

by iarnav

853 views

2 votes

1 answer

23

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?

learner_geek asked in Databases Dec 3, 2017

by learner_geek

1.2k views

1 vote

0 answers

24

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.

iarnav asked in Databases Nov 27, 2017

by iarnav

395 views

1 vote

0 answers

25

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

iarnav asked in Databases Nov 27, 2017

by iarnav

971 views

9 votes

1 answer

26

Test by Bikram | Databases | Test 2 | Question: 11
Relation $L( p,q)$ is stored in $100$ blocks, with $50$ records per block (or tuples) of $L$ fitting in one block. Relation $K(m,n)$ is stored in $200$ blocks with $100$ ... $K$. Therefore, the total number of blocks required in the result of join operation is: ______ blocks.

Bikram asked in Databases Aug 26, 2017

by Bikram

455 views

2 votes

1 answer

27

Relational Algebra
what is difference between full outer join and cross product?

deepakhbtu asked in Databases Aug 21, 2017

1.1k views

0 votes

2 answers

28

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

Mubashirulislam asked in Databases May 5, 2017

by Mubashirulislam

893 views

0 votes

1 answer

29

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

Mubashirulislam asked in Databases May 5, 2017

by Mubashirulislam

333 views

0 votes

2 answers

30

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

Mubashirulislam asked in Databases May 5, 2017

by Mubashirulislam

286 views

Page:

Recent questions tagged joins