(A) Swap space
(B) Cache
(C) Partition
(D) Symbol Table
Tag: Database Interview Questions
In the index allocation scheme of blocks to a file, the maximum possible size of the file depends on?
(A) The size of the blocks, the size of the address of the blocks
(B) The number of blocks used for index, and the size of the index blocks
(C) The size of the blocks, the number of blocks used for the index, and the size of the address of the blocks
(D) None of the above
Index consists of?
(A) Pointer to the matter list
(B) Keys
(C) Both A & B
(D) None of the above
In a hierarchical data a hashing function is used to locate the?
(A) Records
(B) Foreign key
(C) Root
(D) Collision
Which among following is dense index?
(A) Secondary index
(B) Clusters index
(C) Primary index
(D) None of the above
Physical location of a record determined by a formula that transforms a file key into a record location is?
(A) Indexed file
(B) B-Tree file
(C) Sequential file
(D) Hashed file
File organization that provides very fast access to any arbitrary record of a file is called?
(A) B-Tree
(B) Hashed file
(C) Ordered file
(D) Unordered file
The structure of multilevel indexes are similar to?
(A) Tree structures
(B) Hash structures
(C) Array structures
(D) Stack structures