384 views
1 votes
1 votes

Consider a relation R (A B C) with attribute size of A as 8 bytes. Disk block size is 512 bytes and block pointer is 8 bytes. The best choice for degree (maximum value) for B+ tree, if B+ tree was used for creating indexing on  R(A B C) is__________

 

1 Answer

2 votes
2 votes
8(n-1)+8n<=512

solving these u get

n=32

Related questions

2 votes
2 votes
2 answers
1
srestha asked Jan 29, 2017
882 views
Here loading result should take in ALU ,rt?
1 votes
1 votes
1 answer
2
`JEET asked Dec 19, 2018
425 views
Consider a relation R(ABCDE) and functional dependency F1 = {A → B, C → E, B → D}.If the relation is decomposed into BCNF with lossless decomposition and dependency...
0 votes
0 votes
2 answers
3
Suvam Chatterjee asked Sep 9, 2015
520 views
I think conservative 2PL prevents deadlock also. What should be the answer?