...
Question 16170 – UGC NET Dec-2020 and June-2021 Paper-1
November 16, 2023
Question 15162 – DSSSB TGT 2021
November 16, 2023
Question 16170 – UGC NET Dec-2020 and June-2021 Paper-1
November 16, 2023
Question 15162 – DSSSB TGT 2021
November 16, 2023

Question 14280 – GATE 2021 CS-Set-2

A data consisting of 1,50,000 student-records is stored on a hard disk with block size of 4096 bytes. The data file is sorted on the primary key RollNo. The size of a record pointer for this disk is 7 bytes. Each student-record has a candidate key attribute called ANum of size 12 bytes. Suppose an index file with records consisting of two fields, ANum value and the record pointer to the corresponding student record, is built and stored on the same disk. Assume that the records of data file and index file are not split across disk blocks. The number of blocks in the index file is ______.

Correct Answer: A

Question 15 Explanation: 

Total no. of records = 150000

Block size = 4096 bytes

Key size = 12 bytes

Record pointer size = 7 bytes

A
698
0 0 votes
Article Rating
Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x
error: Alert: Content selection is disabled!!