Home » MCQs » DBMS MCQs

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.

1. Hash
2. Heap
3. Addition
4. 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.

1. Repeat Function
2. Storage Function
3. Heap Function
4. 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.

1. Number
2. Address
3. Name
4. 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.

1. Insert
2. Update
3. Delete
4. 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.

1. Search
2. Sort
3. Both A and B
4. None of the above

Answer: C) Both A and B

Explanation:

It is not necessary to search and sort the entire file when using a hash file organization.

Discuss this Question

---

6. Hash files are stored in memory in a ___ order.

1. Consecutive
2. Random
3. Simultaneous
4. Line by line

Answer: B) Random

Explanation:

Hash files are stored in memory in a random order.

Discuss this Question

---

---