wiz-icon
MyQuestionIcon
MyQuestionIcon
2
You visited us 2 times! Enjoying our articles? Unlock Full Access!
Question

The physical location of a record is determined by a mathematical formula, which transforms a file key into a record location in ____________.

A
A B-tree file
No worries! We‘ve got your back. Try BYJU‘S free classes today!
B
An indexed file
No worries! We‘ve got your back. Try BYJU‘S free classes today!
C
Hashed file
Right on! Give the BNAT exam to get a 100% scholarship for BYJUS courses
D
A sequential file
No worries! We‘ve got your back. Try BYJU‘S free classes today!
Open in App
Solution

The correct option is C Hashed file

The physical location of a record is determined by a mathematical formula, which transforms a file key into a record location in hashed file.

Hashing is the transformation of a string of characters into a usually shorter fixed-length value or key that represents the original string. Hashing is used to index and retrieve items in a database because it is faster to find the item using the shorter hashed key than to find it using the original value.

Hashing technique comes into picture. Hashing is an efficient technique to directly search the location of desired data on the disk without using index structure. Data is stored at the data blocks whose address is generated by using hash function.


flag
Suggest Corrections
thumbs-up
0
Join BYJU'S Learning Program
similar_icon
Related Videos
thumbnail
lock
Database Structuring
ACCOUNTANCY
Watch in App
Join BYJU'S Learning Program
CrossIcon