📝 Question
#1459
A _______ on the attribute A of relation r consists of one bitmap for each value that A can take.
✓
Correct Answer
A. Bitmap index
💡
Explanation
A bitmap is simply an array of bits. 3. SELECT * FROM r WHERE gender = ’f’ AND income level = ’L2’; a) Union b) Addition c) Combination d) Intersection We compute a new bitmap where bit i has value 1 if the ith bit of the two bitmaps are both 1, and has a value 0 otherwise.
⌨️ Press
A
B
C
D
to select