Login
Register
@
Dark Mode
Profile
Edit my Profile
Messages
My favorites
Register
Activity
Q&A
Questions
Unanswered
Tags
Subjects
Users
Ask
Previous Years
Blogs
New Blog
Exams
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
by
anupamsworld
77
views
rdbms
databases
natural-join
joins
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
by
tusharb
219
views
sql
databases
joins
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
459
views
nielit2017july-scientistb-it
databases
joins
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
299
views
nielit2017july-scientistb-it
databases
joins
tuple-relational-calculus
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
by
aditi19
762
views
databases
relations
relational-algebra
relational-calculus
joins
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
by
aditi19
619
views
databases
relational-calculus
relations
relational-algebra
joins
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
by
aditi19
1.1k
views
databases
sql
natural-join
joins
ullman
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
355
views
userisi2015
usermod
databases
joins
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
313
views
made-easy-test-series
databases
joins
block-nested-loop-join
0
votes
0
answers
10
Relational Algebra from Aku paper previous year
gatecrack
asked
in
Databases
Dec 10, 2018
by
gatecrack
411
views
relational-algebra
databases
joins
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
by
aditi19
202
views
natural-join
databases
joins
outer-join
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
by
Shukrayani
258
views
databases
joins
general-doubt
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
by
kumar.dilip
361
views
relational-algebra
databases
relations
relational-calculus
joins
0
votes
4
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
854
views
ugcnetcse-july2018-paper2
databases
rdbms
joins
4
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.3k
views
made-easy-test-series
databases
joins
natural-join
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_
478
views
joins
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
255
views
databases
joins
made-easy-test-series
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
by
♥_Less
301
views
relational-algebra
databases
relational-calculus
joins
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
320
views
databases
joins
referential-integrity
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
133
views
databases
joins
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
238
views
made-easy-test-series
databases
joins
2
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
727
views
general
databases
relational-algebra
natural-join
joins
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.1k
views
relational-calculus
joins
relations
relational-algebra
databases
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
330
views
joins
databases
natural-join
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
878
views
relational-algebra
databases
relations
joins
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
427
views
tbb-dbms-2
numerical-answers
databases
joins
2
votes
1
answer
27
Relational Algebra
what is difference between full outer join and cross product?
deepakhbtu
asked
in
Databases
Aug 21, 2017
by
deepakhbtu
956
views
joins
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
754
views
newgradiance
databases
sql
joins
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
295
views
newgradiance
databases
sql
joins
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
237
views
newgradiance
databases
sql
joins
Page:
1
2
next »
Subscribe to GATE CSE 2023 Test Series
Subscribe to GO Classes for GATE CSE 2023
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
Aptitude Overflow Book
Participate in Machine Learning benchmarking
GATE Overflow Tikz Templates
UPSC One Time Registration OTR Online Form 2022
DRDO CEPTAM 10 Online Form 2022
Subjects
All categories
General Aptitude
(2.4k)
Engineering Mathematics
(8.9k)
Digital Logic
(3.2k)
Programming and DS
(5.7k)
Algorithms
(4.5k)
Theory of Computation
(6.5k)
Compiler Design
(2.2k)
Operating System
(4.8k)
Databases
(4.4k)
CO and Architecture
(3.6k)
Computer Networks
(4.4k)
Non GATE
(1.2k)
Others
(2.5k)
Admissions
(644)
Exam Queries
(838)
Tier 1 Placement Questions
(17)
Job Queries
(72)
Projects
(9)
Unknown Category
(851)
Recent questions tagged joins
Recent Blog Comments
@Arjun I am not able to see GATE 2010...
Should be working now
@Arjun Sir but it is not working. i dont know...
@Nisha Bharti. What exactly is not working...
@Hira Thakur Why are you personaly reply me....