Dark Mode

Recent questions tagged joins

0 votes

1 answer

1

ISRO 2024
In SQL the statement $\text{select * from R, S}$ is equivalent to $\text{select * from R natural join S}$ $\text{select * from R cross join S}$ $\text{select * from R outer join S}$ $\text{select * from R inner join S}$

Ramayya asked in Databases Jan 7

187 views

0 votes

1 answer

2

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

384 views

1 vote

1 answer

3

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

685 views

0 votes

2 answers

4

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

admin asked in Databases Mar 30, 2020

by admin

815 views

1 vote

2 answers

5

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

admin asked in Databases Mar 30, 2020

by admin

534 views

1 vote

2 answers

6

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

1.2k views

0 votes

1 answer

7

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

917 views

0 votes

1 answer

8

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

0 votes

0 answers

9

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

540 views

0 votes

1 answer

10

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 19, 2018

by Abhisek Tiwari 4

595 views

0 votes

0 answers

11

Relational Algebra from Aku paper previous year

gatecrack asked in Databases Dec 10, 2018

828 views

0 votes

0 answers

12

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

299 views

0 votes

1 answer

13

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

352 views

0 votes

0 answers

14

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

kumar.dilip asked in Databases Oct 27, 2018

536 views

0 votes

5 answers

15

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

2.4k views

5 votes

1 answer

16

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

4.2k views

3 votes

1 answer

17

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_

584 views

2 votes

0 answers

18

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

Shubham Kumar Gupta asked in Databases Jan 18, 2018

by Shubham Kumar Gupta

440 views

2 votes

0 answers

19

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 in C Jan 14, 2018

433 views

0 votes

2 answers

20

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

494 views

2 votes

0 answers

21

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 29, 2017

by Anjan

273 views

1 vote

1 answer

22

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

rahul sharma 5 asked in Databases Dec 27, 2017

by rahul sharma 5

349 views

3 votes

2 answers

23

#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

1.3k views

2 votes

1 answer

24

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

1 vote

0 answers

25

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

577 views

1 vote

0 answers

26

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

1.2k views

9 votes

1 answer

27

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

619 views

2 votes

1 answer

28

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

deepakhbtu asked in Databases Aug 21, 2017

1.4k views

0 votes

2 answers

29

#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

1.2k views

0 votes

1 answer

30

#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

444 views

Page:

Recent questions tagged joins