DBMS Hash File Organization MCQs

DBMS Hash File Organization MCQs: This section contains multiple-choice questions and answers on Hash File Organization in DBMS.
Submitted by Anushree Goswami, on April 23, 2022

1. A ___ function is computed on some fields of a record in the Hash File Organization.

Hash
Heap
Addition
Multiplication

Answer: A) Hash

Explanation:

A hash function is computed on some fields of a record in the Hash File Organization.

Discuss this Question

2. It is the result of the ___ that determines where the records should be placed on the disk.

Repeat Function
Storage Function
Heap Function
Has Function

Answer: D) Has Function

Explanation:

It is the result of the hash function that determines where the records should be placed on the disk.

Discuss this Question

3. A record is retrieved using the ___ generated using the hash key columns when the record is to be received using the hash key columns.

Number
Address
Name
Data

Answer: B) Address

Explanation:

A record is retrieved using the address generated using the hash key columns when the record is to be received using the hash key columns.

Discuss this Question

4. When a new record needs to be ___, the hash key is used to generate the address, and the record is ___ directly.

Insert
Update
Delete
All of the above

Answer: D) All of the above

Explanation:

When a new record needs to be inserted, updated or deleted, the hash key is used to generate the address, and the record is inserted, updated or deleted directly.

Discuss this Question

5. It is not necessary to ___ the entire file when using a hash file organization.