Question 4
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 5
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 6
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.
Question 8
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 10
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.