GATEverse
← GATE IT 2004

Q79

MCQ2 marks, −0.5

Consider a table TT in a relational database with a key field KK. A BB-tree of order pp is used as an access structure on KK, where pp denotes the maximum number of tree pointers in a B-tree index node. Assume that KK is 1010 bytesbytes long; disk block size is 512512 bytesbytes; each data pointer PD is 88 bytes long and each block pointer PB is 55 bytes long. In order for each BB-tree node to fit in a single disk block, the maximum value of pp is

Sign in to save attempts.

Loading…