The Table EMPLOYEE with Primary Key = Empno Uses as Hash

question 29

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
-Which logical record (identified by empno) is stored at physical address 13?

• A) 2313
• B) 2211
• C) 2012
• D) 2311

---

Definitions:

Variable Manufacturing Costs

Costs that vary directly with the level of production, including expenses like raw materials and direct labor.

Variable Costing Income

An income calculation method that only includes variable costs - costs that fluctuate with production levels - in determining net income.

Absorption Costing Income

A company's income statement approach which includes all costs of production (both fixed and variable) in the cost of goods sold, thereby fully absorbing them.

Variable Cost Ratio

The proportion of variable costs to sales, showing the impact of production volume on total costs.