Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

ISRO | ISRO CS 2017 | Question 12

  • Difficulty Level : Basic
  • Last Updated : 16 Mar, 2018

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
Recommended Articles
Page :

Start Your Coding Journey Now!