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





👇 More MCQs (Category-Wise) 👇

Web Technologies MCQs

Computer Science Subjects MCQs

Databases MCQs

Programming MCQs

Testing Software MCQs

Digital Marketing Subjects MCQs

Cloud Computing Softwares MCQs

AI/ML Subjects MCQs

Engineering Subjects MCQs

Office Related Programs MCQs

Commerce MCQs

Graphic Design Softwares MCQs

General Knowledge (GK) MCQs

Class-wise MCQs

Others

Comments and Discussions!

Load comments ↻





Copyright © 2024 www.includehelp.com. All rights reserved.