(A) Swap space
(B) Cache
(C) Partition
(D) Symbol Table
Category: Database Mcqs
Database Mcqs for Screening tests, Interviews, Viva and Other competitive exams. Database Mcqs section will help users to prepare mcqs of Database for various exams. Aspirants of Lecturer Computer Science, SST Computer Science, Subject Specialist Computer Science, Data Entry operator, Computer Programmer, Computer Operator, System administrator, Database Administrator and all other Exams can prepare their Database portion from here.
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