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
Correct Answer:

Verified
Correct Answer:
Verified
Q24: A dominant RAID architecture which uses both
Q25: A physical record:<br>A) May contain exactly one
Q26: In selecting an index,a column that has
Q27: A(n)_ file is a specialized file structure
Q28: One of the dominant RAID architectures,_ involves
Q30: A Sequential File is a simple file
Q31: Bitmap indexes are a good alternative to
Q32: The B+tree structure improves the performance of
Q33: In hash files,if a collision occurs because
Q34: A logical record may be split across