NPTEL

gulsanchouhan asked Aug 26, 2017

515 views

1 votes

If 5 relations are put through the zig-zag configuration of join tree and the order of join does not matter, how many different join trees are possible?

1. 960

2. 840

3. 1024

4. 512

Databases
nptel-quiz
databases

+ –

gulsanchouhan asked Aug 26, 2017

gulsanchouhan

515 views

See all

0 Please log in or register to add a comment.

Please log in or register to answer this question.

1 Answer

0 votes

960. we can use this formula n!(2power n-2).

Nagamani Chippada answered Sep 4, 2017

Nagamani Chippada

See all

1 1 comment

Kaluti

commented Sep 17, 2017

can u explain this formula how has it come?

0 votes

Please log in or register to add a comment.

Voting & Accepting an answer helps improve the community

← Previous Next →

← Previous in category Next in category →

Related questions

2 votes

0 answers

gulsanchouhan asked Sep 28, 2017

727 views

NPTEL
Which of the following transaction(s) follow 2-phase locking protocol? lock1(a)read1(a)lock2(b)write2(b)lock1(c)unlock2(b)unclock1(c)lock2(c)unlock1(a) lock1(a)lock1(b)unlock1(a)lock2(a)write2(a)unlock2(a)unlock1(b) lock1(a)lock2(b)lock1(c)lock3(d)unlock2(b)lock3(b)unlock1(a)unlock3(d)unlock1(c)lock3(c) 1. Only 1 2. Only 2 3. Only 1 and 3 4. None of them

Which of the following transaction(s) follow 2-phase locking protocol?lock1(a)read1(a)lock2(b)write2(b)lock1(c)unlock2(b)unclock1(c)lock2(c)unlock1(a)lock1(a)lock1(b)unlo...

gulsanchouhan

727 views

gulsanchouhan asked Sep 28, 2017

Databases
databases
nptel-quiz

+ –

2 votes

0 answers

gulsanchouhan asked Sep 28, 2017

963 views

nptel
Which of the following statement is correct ? 1. 2 phase locking protocol does not suffer with problem of cascading rollback 2. Strict 2 phase protocol never results in deadlock 3. In strict 2 phase protocol, restriction of releasing exclusive locks until commit ensures no cascading rollbacks 4. Time-stamp ordering protocol can generate non-recoverable schedules

Which of the following statement is correct ?1. 2 phase locking protocol does not suffer with problem of cascading rollback 2. Strict 2 phase protocol never results in de...

gulsanchouhan

963 views

gulsanchouhan asked Sep 28, 2017

Databases
databases
nptel-quiz

+ –

3 votes

1 answer

gulsanchouhan asked Sep 28, 2017

658 views

nptel
Choose the correct option about the following schedule. S:R2(A);W3(A);(commitT3);W1(A);(commitT1);W2(B);R2(C);(commitT2);R4(A);R4(B);(commitT4) 1. S is both recoverable and conflict serializable 2. S is neither recoverable nor conflict serializable 3. S is recoverable but not conflict serializable 4. S is not recoverable but conflict serializable

Choose the correct option about the following schedule.S:R2(A);W3(A);(commitT3);W1(A);(commitT1);W2(B);R2(C);(commitT2);R4(A);R4(B);(commitT4) 1. S is both recoverable a...

gulsanchouhan

658 views

gulsanchouhan asked Sep 28, 2017

Databases
databases
nptel-quiz

+ –

1 votes

0 answers

gulsanchouhan asked Sep 28, 2017

341 views

NPTEL
Which of the following can be described as a programming model used to develop applications processing massive amounts of data in a distributed and/or parallel manner? 1. Map Reduce 2 .OLAP 3. Mahout 4. Cloud Computing

Which of the following can be described as a programming model used to develop applications processing massive amounts of data in a distributed and/or parallel manner?1. ...

gulsanchouhan

341 views

gulsanchouhan asked Sep 28, 2017

Databases
databases
nptel-quiz

+ –

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

0 reply

Please log in or register to add a comment.

Please log in or register to answer this question.

1 Answer

1 1 comment reply

Please log in or register to add a comment.

Related questions

0

1 1 comment