Question 1
Marks : +2 | -2
Pass Ratio : 100%
What is hashing file organization?
Explanation: Hashing file organization means that a hash function is computed on some attribute and that decides the block. The result of the hash function specifies which block of the file the record should be placed in.
Question 3
Marks : +2 | -2
Pass Ratio : 100%
What is sequential file organization?
Explanation: Sequential file organization means that Records are stored in a sequential order according to a search key. The records are ordered.
Question 4
Marks : +2 | -2
Pass Ratio : 100%
What is a multitable clustering file organization?
Explanation: A multitable clustering file organization stores the related records of two or more relations in each block. This allows us to read records that satisfy a join condition by using one block read.
Question 6
Marks : +2 | -2
Pass Ratio : 100%
What is heap file organization?
Explanation: Heap file organization means that any record can be placed wherever there is space for that record. There is no ordering of records. Typically there is a single file for each relation.
Question 10
Marks : +2 | -2
Pass Ratio : 100%
What is a search key in sequential file organization?
Explanation: A search key in sequential file organization is any attribute or a set of attributes that need not be a primary key or even a superkey.