Question 1 |
A data file 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 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 ______
235 | |
248 | |
488 | |
698 |
Question 1 Explanation:
Question 2 |
Consider a linear list based directory implementation in a file system. Each directory is a list of nodes, where each node contains the file name along with the file metadata, such as the list of pointers to the data blocks. Consider a given directory foo.
Which of the following operations will necessarily require a full scan of foo for successful completion?
[MSQ]
Which of the following operations will necessarily require a full scan of foo for successful completion?
[MSQ]
Creation of a new file in foo | |
Deletion of an existing file from foo | |
Renaming of an existing file in foo | |
Opening of an existing file in foo |
Question 2 Explanation:
Question 3 |
Consider a database implemented using B+ tree for file indexing and installed on a disk drive with block size of 4 KB. The size of search key is 12 bytes and the size of tree/disk pointer is 8 bytes. Assume that the database has one million records. Also assume that no node of the B+ tree and no records are present initially in main memory. Consider that each record fits into one disk block. The minimum number of disk accesses required to retrieve any record in the database is _______
2 | |
3 | |
4 | |
5 |
Question 3 Explanation:
Question 4 |
Which one of the following statements is NOT correct about the B^+ tree data structure used for creating an index of a relational database table?
B^+ Tree is a height-balanced tree | |
Non-leaf nodes have pointers to data records | |
Key values in each node are kept in sorted order | |
Each leaf node has a pointer to the next leaf node |
Question 4 Explanation:
Question 5 |
Which of the following is dense index?
Primary index | |
Clustered index | |
Secondary index | |
Secondary non-key index |
Question 5 Explanation:
Question 6 |
in a file which contains 1 million records and the order of the tree is 100, then what is the maximum number of nodes to be accessed if B+ tree index is used?
5 | |
4 | |
3 | |
10 |
Question 6 Explanation:
Question 7 |
A B-Tree used as an index for a large database table has four levels including the root node. If a new key is inserted in this index, then the maximum number of nodes that could be newly created in the process are
5 | |
4 | |
3 | |
2 |
Question 7 Explanation:
Question 8 |
Which of these is characteristic of RAID 5?
Dedicated parity | |
Double parity | |
Hamming code parity | |
Distributed parity |
Question 8 Explanation:
Question 9 |
In a B^{+} tree, if the search -key value is 8 bytes long, the block size is 512 bytes and the block pointer size is 2 bytes, then maximum order of the B^{+} tree is _______________.
64 | |
32 | |
52 | |
12 |
Question 9 Explanation:
Question 10 |
A clustering index is defined on the fields which are of type
non-key and ordering | |
non-key and non-ordering | |
key and ordering | |
key and non-ordering |
Question 10 Explanation:
There are 10 questions to complete.