The Table EMPLOYEE with Primary Key = Empno Uses as Hash

question 73

Multiple Choice

The table EMPLOYEE with primary key = empno uses as hash function empno Mod 100, which gives the physical record number when applied to Empno. The linear probe procedure is used for collision handling. The physical records are created in the order of logical records (= rows) in the table, one physical record for one logical record EMPLOYEE
Empno
2011
2012
2211
2311
2312
2313
2317
-To retrieve logical record 2312,how many physical records will need to be accessed?

• A) 1
• B) 2
• C) 3
• D) 4

---

Definitions:

Computer Software

Programs and operating information used by a computer, encompassing both applications and the operating system.

Fast Food

Quick-service food items, usually part of a chain or franchise, that are prepared and served rapidly.

On-demand Economy

An economic model driven by technology where goods and services are delivered on demand to consumers via digital marketplaces and apps.

Independent Contractors

Individuals who offer their services on a freelance basis and are not considered employees of the companies with which they work, often providing their tools and deciding their work hours.