The Table EMPLOYEE with Primary Key = Empno Uses as Hash

question 50

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 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%

---

Definitions:

Epithelial Tissue

A tissue type that lines the tubes, hollow organs, and cavities of the body.

Connective Tissues

Tissues that support, bind together, and protect the organs of the body. This includes bone, cartilage, tendons, and ligaments among others.

Chemotherapy

A type of cancer treatment that uses drugs to destroy or slow the growth of cancer cells.

Melanoma

A serious form of skin cancer that arises from the pigment-producing cells known as melanocytes.