database
closed

closed by
261 views
0 votes
0 votes
closed as a duplicate of: GATE CSE 2008 | Question: 70
Consider a file of 16384 records. Each record is 32 B long and its key field is orderd on a non key field and the file organisation is unspanned . The file is stored in a file system with block size 1024 B and the size of block pointer is 10B . If the secondary index is built on the key field of the file and a multi level index scheme is used to store the secondary index the number of first level and second level blocks in the multi level index are respectively

A) 8 ,0     

B) 128,6

C)256,4

D)512,5
closed by

Related questions

157
views
0 answers
1 votes
peter09 asked Apr 16
157 views
Give an appropriate tree-structure diagram for the following relational database:Employee (person_name, street, city)Works (person_name, company_name, salary)Company (company_name, city)Manages (person_name, manager_name)
228
views
0 answers
0 votes
RishabhSahu325 asked Feb 22
228 views
Use the following information to answer Questions 7 and 8.A sorted file has the following details: Number of records = 13,10,720; record length = 200 ... in the first level index file is:a)131072b)1311c)1310d)1286Accepted Answers:1286
278
views
1 answers
0 votes
phaniphani asked Nov 16, 2023
278 views
is it allowed in a B+ tree, while deletion to leave behind a key in internal nodes while deleting it from the leaf ?
396
views
0 answers
0 votes
khushwant2 asked Oct 10, 2023
396 views
T1: R1(A), W1(A), R1 (B). W1(B); T2: R2(A), W2(A), R2(B). W₂(B) S1: R2(A), W2(A), R1 (A), W1(A), R1 (B), W1(B), R2(B) ... serializable schedules.S1 R1(x) R3(y) W1(x) W2(y) R3(x) W2(x)Find out whether S₁ is conflict serializable schedules.