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:

Interaction

The effect of two or more variables is not simply additive, but depends on the levels of the other variables.

Factorial ANOVA

A statistical test used to examine the effects of two or more independent variables on a dependent variable, and their interactions, within an experimental design.

Probability Level

The threshold of significance in hypothesis testing, indicating the likelihood that a result is not due to chance.

Main Effect

The direct influence of an independent variable on a dependent variable in an experiment, ignoring other factors or interactions.