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
Number of tuple in Joins
shivani2010
asked
in
Databases
May 30, 2016
277
views
1
vote
1
vote
shivani2010
asked
in
Databases
May 30, 2016
by
shivani2010
277
views
answer
comment
Follow
share this
share
1 comment
by
vijaycs
commented
May 30, 2016
reply
Follow
share this
Ans- A
https://gateoverflow.in/30009/maximum-and-minimum-size-of-the-join-of-two-relations
0
0
Please
log in
or
register
to add a comment.
Please
log in
or
register
to answer this question.
1
Answer
0
votes
0
votes
Best answer
cross join(or cross product) produces max tuples so here it should be mxn
Sanjay Sharma
answered
May 30, 2016
selected
May 31, 2016
by
shivani2010
by
Sanjay Sharma
comment
Follow
share this
0 Comments
Please
log in
or
register
to add a comment.
← Previous
Next →
← Previous in category
Next in category →
Related questions
1
vote
1
vote
2
answers
1
tarunmaganti
asked
in
Databases
Apr 15, 2018
517
views
Tuple Relational Calculus - What is the difference between these two types of bounded variables in the expressions?
tarunmaganti
asked
in
Databases
Apr 15, 2018
by
tarunmaganti
517
views
tuple-relational-calculus
databases
relational-calculus
1
vote
1
vote
1
answer
2
yg92
asked
in
Databases
Feb 8, 2017
1,112
views
Count(*) when one of the tuple has null values in all column?
Ideally Count(*) will count no of rows in which atleast one column is Non NULL otherwise discard that row. Is this statement true? But when I am trying practically it is returning the count including the null tuple where all columns ... // Returning 2 rows which is correct select count(*) from stud; // Returning 4 rows. Is this correct?
yg92
asked
in
Databases
Feb 8, 2017
by
yg92
1.1k
views
databases
sql
0
votes
0
votes
1
answer
3
Abhisek Tiwari 4
asked
in
Databases
Dec 20, 2018
358
views
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
358
views
made-easy-test-series
databases
joins
block-nested-loop-join
0
votes
0
votes
1
answer
4
Shukrayani
asked
in
Databases
Oct 30, 2018
279
views
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
279
views
databases
joins
general-doubt
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
GATE CSE 2023 Paper & Analysis - Memory Based
From GATE to Australia
DRDO Previous Year Papers
From Rank 4200 to 64: My Journey to Success in GATE CSE Exam
What are the key things to focus on during the final 10-15 days before the GATE exam to improve performance?
Subjects
All categories
General Aptitude
(2.5k)
Engineering Mathematics
(9.3k)
Digital Logic
(3.3k)
Programming and DS
(5.9k)
Algorithms
(4.6k)
Theory of Computation
(6.7k)
Compiler Design
(2.3k)
Operating System
(5.0k)
Databases
(4.6k)
CO and Architecture
(3.8k)
Computer Networks
(4.6k)
Non GATE
(1.3k)
Others
(2.4k)
Admissions
(649)
Exam Queries
(842)
Tier 1 Placement Questions
(17)
Job Queries
(75)
Projects
(9)
Unknown Category
(853)
Recent Blog Comments
@Aakash_Bhardwaj all the best bro . For your...
What's the answer for keystroke question
Same,easy to moderate
I felt paper was very much like AIMT 3!!
very easy paper, I don't want to discuss paper...
Twitter
WhatsApp
Facebook
Reddit
LinkedIn
Email
Link Copied!
Copy
