Dark Mode

Recent questions tagged block-nested-loop-join

0 votes

1 answer

1

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

597 views

0 votes

0 answers

2

Nested Quantifiers
If we have ∀x(p(x)) then in boolean algebra form we can write this statement as (P1 + P2) where + signifies OR which makes it very easy to deal with. So likewise is there any way to have a view of a statement like ∀x∀y(R(x,y)) into boolean form?

sushil1997 asked in Mathematical Logic Sep 28, 2018

468 views

0 votes

0 answers

3

compile design syntax directed defination

Ronish Jariwala 1 asked in Compiler Design Apr 15, 2018

by Ronish Jariwala 1

483 views

1 vote

0 answers

4

Block nested loop join
Are block transfers and block access same ?

Pawan Kumar 2 asked in Databases Jan 2, 2018

by Pawan Kumar 2

589 views

1 vote

1 answer

5

ACE Test Series, Gate2018

ashish pal asked in Databases Nov 29, 2017

435 views

1 vote

0 answers

6

block nested query
please cjheck this

raviyogi asked in Databases Nov 10, 2017

400 views

2 votes

2 answers

7

Block Nested Loop Join
Consider a relation R with 2000 records and relation S with 500 records. Size of each record is 5 Byte and block size is 100 Byte, then minimum number of block access that are needed block nested loop join. I think its answer should be 2525.

Shubhanshu asked in Databases Aug 18, 2017

1.3k views

To see more, click for the full list of questions or popular tags.

Recent questions tagged block-nested-loop-join