Skip to content
Related Articles

Related Articles

ISRO | ISRO CS 2017 | Question 12

Improve Article
Save Article
  • Difficulty Level : Basic
  • Last Updated : 16 Mar, 2018
Improve Article
Save Article

Consider a table that describes the customers :

Customers(custid, name, gender, rating)

The rating value is an integer in the range 1 to 5 and only two values (male and female) are recorded for gender. Consider the query “how many male customers have a rating of 5”? The best indexing mechanism appropriate for the query is

(A) Linear hashing
(B) Extendible hashing
(C) B+ Tree
(D) Bit-mapped hashing

Answer: (D)

Explanation: Since we require only 2 bits 0 and 1 to record gender of customers we easily implement it using bit-mapped index.
So, the correct answer is (D)

Quiz of this Question

My Personal Notes arrow_drop_up
Related Articles

Start Your Coding Journey Now!