To resolve query with BITMAP INDEXES
Create patient table, your table name should have your initial as prefixcreate table AP_PATIENT(patient_id number(10),gender char(1),marital_status char(1),race char(1),primary key (patient_id));In this dataset,Gender are: M (male), F (female) Marital_status is: S (single), M (married), D (divorced), W (Widow or Widower)Races are: A (Asian), B (Black), W (White)Populate data to your patient table, with exact data as into ap_patient (patient_id,gender,marital_status,race) values (20001, 'F','S','A');insert into ap_patient (patient_id,gender,marital_status,race) values (20002, 'F','S','W');insert into ap_patient (patient_id,gender,marital_status,race) values (20003, 'F','S','B');insert into ap_patient (patient_id,gender,marital_status,race) values (20004, 'F','M','A');insert into ap_patient (patient_id,gender,marital_status,race) values (20005, 'F','D','B');insert into ap_patient (patient_id,gender,marital_status,race) values (20006, 'F','W','A');insert into ap_patient (patient_id,gender,marital_status,race) values (20007, 'F','M','W');insert into ap_patient (patient_id,gender,marital_status,race) values (20008, 'F','W','B');insert into ap_patient (patient_id,gender,marital_status,race) values (20009, 'M','S','A');insert into ap_patient (patient_id,gender,marital_status,race) values (20010, 'M','S','W');insert into ap_patient (patient_id,gender,marital_status,race) values (20011, 'M','S','B');insert into ap_patient (patient_id,gender,marital_status,race) values (20012, 'M','M','A');insert into ap_patient (patient_id,gender,marital_status,race) values (20013, 'M','D','B');insert into ap_patient (patient_id,gender,marital_status,race) values (20014, 'M','W','A');insert into ap_patient (patient_id,gender,marital_status,race) values (20015, 'M','M','W');insert into ap_patient (patient_id,gender,marital_status,race) values (20016, 'M','W','B');
Identify columns suitable of creating bitmap indexes and write bitmaps of each of such bitmap indexes.bitmaps of each distinct value of each of such bitmap indexes