ADVERTISEMENT
ADVERTISEMENT

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



ADVERTISEMENT
ADVERTISEMENT


Comments and Discussions!



ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT

Languages: » C » C++ » C++ STL » Java » Data Structure » C#.Net » Android » Kotlin » SQL
Web Technologies: » PHP » Python » JavaScript » CSS » Ajax » Node.js » Web programming/HTML
Solved programs: » C » C++ » DS » Java » C#
Aptitude que. & ans.: » C » C++ » Java » DBMS
Interview que. & ans.: » C » Embedded C » Java » SEO » HR
CS Subjects: » CS Basics » O.S. » Networks » DBMS » Embedded Systems » Cloud Computing
» Machine learning » CS Organizations » Linux » DOS
More: » Articles » Puzzles » News/Updates

© https://www.includehelp.com some rights reserved.