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 blocks, with each block containing rows. Each row has a flight, airline, time, airport, and aircraft. Rows are sorted on flight.
A multilevel index has levels, a top and bottom level. Each index block can hold up to entries. The top level has block with entries, and the bottom level has blocks.
The first bottom level blocks each have entries, and the last bottom level blocks each have 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 : Lufthansa, : ABQ, Boeing
Bottom level entry ALF points to Row : Delta Air Lines, : ALF, MD
Bottom level entry BLR points to Row : British Airways, : BLR Boeing
Bottom level entry DTW points to Row : Aer Lingus, : DTW Boeing
Top level entry HAV points to a bottom level block containing entries HAV, JNB MAA, and MAD.
Bottom level entry HAV points to Row : British Airways, : HAV, MD
Bottom level entry JNB points to Row : Air China, : JNB Airbus
Bottom level entry MAA points to Row : Air India, : MAA, Airbus
Bottom level entry MAD points to Row : Aer Lingus, : MAD, Boeing
Top level entry ONT points to a bottom level block containing entries ONT and QRO.
Bottom level entry ONT points to Row : American Airlines, : ONT, MD
Bottom level entry QRO points to Row : Southwest Airlines, : QRO, Airbus A
Top level entry SVQ points to a bottom level block containing entries SVQ and VAA.
Bottom level entry SVQ points to Row : British Airways, : SVQ MD
Bottom level entry VAA points to Row : Aer Lingus, : VAA, Boeing
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 'Southwest Airlines', : 'POA', 'Boeing
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
