Quiz Space

Database Management Systems · End Term · 13 Sept 2026 · May 2026 term

Question 15: Consider the following relation Employee. A bitmap index…

Question 15

+2 marksOne or more correct options

Consider the following relation Employee.

A bitmap index is constructed on the attribute Team, with one bitmap for each distinct value of Team. The bits in each bitmap correspond to the rows of the table in the order shown above.
Which of the following statements are correct?

Select all that apply.

  1. A
  2. B
  3. C
  4. D
Show answer

Correct answers

  • A
  • B
  • C
See the whole paperTake it as a mock test

Question 15 of 18 in the IIT Madras BS Database Management Systems (DBMS) End Term paper sat on 13 Sept 2026, in the May 2026 term (Database Management 13 Sep 26). It carries 2 marks.

More questions from this paper

  1. Q1Figure question
  2. Q2Figure question
  3. Q3Consider the relational schema R(A, B, C, D, E, F), where the domains for A, B, C, D, E and F include atomic values onl…
  4. Q4Figure question
  5. Q5Consider the following ER relationship: Which of the following statements is correct?
  6. Q6Figure question
  7. Q7Which of the following could be the hash function used by the file?
  8. Q8Figure question
  9. Q9Figure question
  10. Q10Figure question
  11. Q11Figure question
  12. Q12Figure question
  13. Q13Figure question
  14. Q14Consider the following schedule S and answer question Which of the following is/are correct?
  15. Q16Consider the following statements.\ In RAID 2, the Hamming code is used for parity. 2. RAID 4 has a striping unit of di…
  16. Q17Consider a Block nested loop join for the two relations, employee and project. Assuming the worst-case memory availabil…
  17. Q18Consider the following backup schedule used by a company: If a system failure occurs on Sunday before the backup for th…