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

Verified
Correct Answer:
Verified
Q66: A(n)_ index references the rows of a
Q67: In a Btree structure,the height of the
Q68: The process of associating a query with
Q69: _ is a collection of disks that
Q70: Figuer: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB4814/.jpg" alt="Figuer: -The
Q71: In RAID technology,striping involves the allocation of
Q72: In a _ index,the order of the
Q74: Which of the following is used in
Q75: A bitmap join index is actually a
Q76: A database consists of the tables