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 maintain the number of collisions at an adequate level without wasting too much storage,the ratio of used records to the total number of records should be as follows:
A) At least 90%
B) At most 90%
C) At most 70%
D) At most 20%
Correct Answer:
Verified
Q17: In order to optimize queries,some DBMSs allow
Q18: In the processing of an SQL statement
Q19: Bitmap indexes are a good alternative to
Q20: In hash files,if a collision occurs because
Q21: Chose the correct statement regarding memory access
Q23: In selecting an index,a column that has
Q24: During the query optimization process,which phase analyzes
Q25: Which of the following is not an
Q26: During the query optimization process,which phase generates
Q27: Figuer:
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents