Number of tuple in Joins

Question

Number of tuple in Joins

shivani2010 asked May 29, 2016

446 views

See all

1 Answer

Best answer

See all

Related questions

1 votes

2 answers

1

tarunmaganti asked Apr 15, 2018

773 views

Tuple Relational Calculus - What is the difference between these two types of bounded variables in the expressions?

If there are three tables to choose from -Sailors(sid,sname); Reserves(sid,bid); Boats(bid,color)Question is to choose a sailor who reserved a red boat.My question is wha...

tarunmaganti

773 views

tarunmaganti asked Apr 15, 2018

1 votes

1 answer

2

yg92 asked Feb 8, 2017

1,492 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?

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

yg92

1.5k views

yg92 asked Feb 8, 2017

0 votes

1 answer

3

Abhisek Tiwari 4 asked Dec 19, 2018

610 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?

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

Abhisek Tiwari 4

610 views

Abhisek Tiwari 4 asked Dec 19, 2018

0 votes

1 answer

4

Shukrayani asked Oct 30, 2018

352 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?

A system where commutativity is considered different, in how many ways the join of n relations r1,r2, . . . ,rn canbe taken?

Shukrayani

352 views

Shukrayani asked Oct 30, 2018

Ans- A

https://gateoverflow.in/30009/maximum-and-minimum-size-of-the-join-of-two-relations — vijaycs, May 29, 2016

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

Number of tuple in Joins

Please log in or register to add a comment.

Please log in or register to answer this question.

1 Answer

Please log in or register to add a comment.

Related questions

1 1 comment reply

Please log in or register to add a comment.

Please log in or register to answer this question.

1 Answer

0 reply

Please log in or register to add a comment.

Related questions

1 1 comment

0