1.
Which RAID level gives block level striping with double distributed parity?
2.
Embedded pointer provides
3.
Raid configurations of the disks are used to provide
4.
In the indexed scheme of blocks to a file, the maximum possible size of the file depends on:
5.
In __________ allocation method for disk block allocation in a file system, insertion and deletion of blocks in a file is easy.
6.
Database applications were built directly on top of file system to overcome the following drawbacks of using file-systems:
(i) Data redundancy and inconsistency
(ii) Difficulty in accessing Data
(iii) Data isolation
(iv) Integrity problems
7.
Embedded pointer provides
8.
The physical location of a record determined by a formula that transforms a file key into a record location is
9.
Calculate the order of leaf(pleaf) and non leaf(p) nodes of a B+ tree based on the information given below Search key field = 12 bytes Record pointer = 10 bytes Block pointer = 8 bytes Block size = 1 KB
10.
Given a block can hold either 3 records or 10 key pointers. A database contains n records, then how many blocks do we need to hold the data file and the dense index