Question

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

• A. a B-tree file
• B. an indexed file
• C. a hashed file
• D. a sequential file

Answer 1

The correct option is C a hashed file

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

Hashingis 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.

A hashed file is a file that uses a hashing algorithm for distributing records in one or more groups on disk.