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

A table contains 6 blocks, with each block containing up to 4 rows. Each row has a flight, airline, time, airport, and aircraft. Rows are sorted on airport.
A multi-level index has 2 levels, a top and bottom level. Each index block can hold up to 3 entries.
The top level has 1 block with 3 entries, and the bottom level has 3 blocks: a block with 2 entries, a block with 1 entry, and a block with 3 entries.
Entries are sorted on airport.
The index entries and related table rows are:
Top level entry ABQ points to a bottom level block containing entries ABQ and DTW.
Bottom level entry ABQ points to a table block containing rows:
Row 1: 151, Lufthansa, 10:45, ABQ, Boeing 737;
Row 2: 1038, Delta Air Lines, 5:30, ALF, MD 11;
Row 3: 588, British Airways, 4:30, BLR, Boeing 747;
Row 4: 857, Aer Lingus, 9:30, CPO, Boeing 737;
Bottom level entry DTW points to a table block containing rows:
Row 5: 834, Aer Lingus, 4:05, DTW, Boeing 777;
Row 6: 752, British Airways, 18:15, HAV, MD 11;
Row 7: 1129, Air China, 2:40, JNB, Airbus 321;
Top level entry MAA points to a bottom level block containing entry MAA.
Bottom level entry MAA points to a table block containing rows:
Row 8: 659, Air India, 2:00, MAA, Airbus 321;
Row 9: 393, Aer Lingus, 16:25, MAD, Boeing 787;
Row 10: 900, Air China, 11:50, NKG, Boeing 747;
Row 11: 837, United Airlines, 22:20, OAK, MD-90;
Top level entry ONT points to a bottom level block containing entries ONT, SJC, and VAA.
Bottom level entry ONT points to a table block containing rows:
Row 12: 390, American Airlines, 6:00, ONT, MD 11;
Row 13: 1157, Lufthansa, 8:25, PMO, Boeing 787;
Row 14: 650, Southwest Airlines, 4:30, QRO, Airbus A320;
Bottom level entry SJC points to a table block containing rows:
Row 15: 368, Southwest Airlines, 17:45, SJC, Boeing 737;
Row 16: 973, British Airways, 12:45, SVQ, MD-90;
Row 17: 789, Lufthansa, 6:20, THR, Airbus A321;
Row 18: 559, Air India, 3:10, UTP, Airbus A320;
Bottom level entry VAA points to a table block containing rows:
Row 19: 822, Aer Lingus, 16:50, VAA, Boeing 777;
Row 20: 913, United Airlines, 10:50, WGA, Airbus A320;
Row 21: 167, Air India, 9:20, ZCL, MD-90;
The table is sorted on Airport.
The index on Airport is sparse.
Yes
Are any blocks split when the
following query executes?INSERT INTO FlightTable
VALUES (473, 'Air India',
'17:15', 'GUM', 'Boeing 737')

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!