Answer to Question #44338 in Databases | SQL | Oracle | MS Access for Aucun Désir

Question

Consider the following table:

Student_Subjects

StudentID SubjectCode ExamCenter
124 CS614 PVC001
455 CS001 PVC002
367 CS614 PVC001
486 CS403 PVC001
524 CS101 PVC003
657 CS614 PVC002

Question:

Use bitmap index to execute the following queries:
Select * from Student_Subjects where SubjectCode=”CS614” and ExamCenter=”PVC001”
Select * from Student_Subjects where SubjectCode=”CS001” and ExamCenter=”PVC001”

Specify each and every step including index tables, bit vectors etc.