Question: A table contains 4 blocks, with each block containing 3 rows. Each row has a flight, airline, time, airport, and aircraft. Rows are sorted on

A table contains 4 blocks, with each block containing 3 rows. Each row has a flight, airline, time, airport, and aircraft. Rows are sorted on flight.
A multi-level index has 2 levels, a top and bottom level. Each index block can hold up to 4 entries. The top level has 1 block with 4 entries, and the bottom level has 4 blocks.
The first 2 bottom level blocks each have 4 entries, and the last 2 bottom level blocks each have 2 entries.
The index entries and related table rows are:
Top level entry ABQ points to a bottom level block containing entries ABQ, ALF, BLR, and DTW.
Bottom level entry ABQ points to Row 2: 251, Lufthansa, 10:45, ABQ, Boeing 737.
Bottom level entry ALF points to Row 5: 496, Delta Air Lines, 5:30, ALF, MD 11.
Bottom level entry BLR points to Row 6: 588, British Airways, 4:30, BLR, Boeing 747.
Bottom level entry DTW points to Row 4: 390, Aer Lingus, 4:05, DTW, Boeing 777.
Top level entry HAV points to a bottom level block containing entries HAV, JNB, MAA, and MAD.
Bottom level entry HAV points to Row 1: 101, British Airways, 18:15, HAV, MD 11.
Bottom level entry JNB points to Row 9: 822, Air China, 2:40, JNB, Airbus 321.
Bottom level entry MAA points to Row 3: 323, Air India, 2:00, MAA, Airbus 321.
Bottom level entry MAD points to Row 8: 775, Aer Lingus, 16:25, MAD, Boeing 787.
Top level entry ONT points to a bottom level block containing entries ONT and QRO.
Bottom level entry ONT points to Row 12: 1161, American Airlines, 6:00, ONT, MD 11.
Bottom level entry QRO points to Row 7: 650, Southwest Airlines, 4:30, QRO, Airbus A320.
Top level entry SVQ points to a bottom level block containing entries SVQ and VAA.
Bottom level entry SVQ points to Row 11: 1078, British Airways, 12:45, SVQ, MD-90.
Bottom level entry VAA points to Row 10: 973, Aer Lingus, 16:50, VAA, Boeing 777.
The table is sorted on Flight.
The index on Airport is dense.
Check any blocks that split when the following query executes:INSERT INTO FlightTable
VALUES (219, 'Southwest Airlines', '9:20', 'POA', 'Boeing 787')

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!