The values in the primary index and the table are sorted on flight number. Select the...

 

Transcribed Image Text:

The values in the primary index and the table are sorted on flight number. Select the indexes to find the row containing HKG. || secondary index (logical) ATL 40 DME 112 DUB 24 DXB 72 EUG 200 SJC 380 FRA 29 HKG 401 PHL 189 SEA 476 OAK 101 ORD 422 primary index (physical) 24 101 380 ... 24 29 40 72 101 112 189 200 380 401 422 476 Aer Lingus Lufthansa United Airlines Air India sorted table 11:30 DUB 14:00 FRA 6:00 ATL 11:50 DXB American Airlines Air China British Airways Air India 17:05 |OAK 7:35 DME 20:25 PHL 16:10 EUG SJC 22:30 HKG 17:45 ORD 21:00 SEA Southwest Airlines 15:20 Air China American Airlines Delta Airlines Boeing 737 MD 111 Airbus 321 Boeing 747 Airbus 323 Boeing 777 Airbus 323 Boeing 747 Airbus 323 Boeing 787 MD 111 Boeing 747 The values in the primary index and the table are sorted on flight number. Select the indexes to find the row containing HKG. || secondary index (logical) ATL 40 DME 112 DUB 24 DXB 72 EUG 200 SJC 380 FRA 29 HKG 401 PHL 189 SEA 476 OAK 101 ORD 422 primary index (physical) 24 101 380 ... 24 29 40 72 101 112 189 200 380 401 422 476 Aer Lingus Lufthansa United Airlines Air India sorted table 11:30 DUB 14:00 FRA 6:00 ATL 11:50 DXB American Airlines Air China British Airways Air India 17:05 |OAK 7:35 DME 20:25 PHL 16:10 EUG SJC 22:30 HKG 17:45 ORD 21:00 SEA Southwest Airlines 15:20 Air China American Airlines Delta Airlines Boeing 737 MD 111 Airbus 321 Boeing 747 Airbus 323 Boeing 777 Airbus 323 Boeing 747 Airbus 323 Boeing 787 MD 111 Boeing 747