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 blocks, with each block containing up to rows. Each row has a flight, airline, time, airport, and aircraft. Rows are sorted on airport.
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: a block with entries, a block with entry, and a block with 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 : Lufthansa, : ABQ, Boeing ;
Row : Delta Air Lines, : ALF, MD ;
Row : British Airways, : BLR Boeing ;
Row : Aer Lingus, : CPO, Boeing ;
Bottom level entry DTW points to a table block containing rows:
Row : Aer Lingus, : DTW Boeing ;
Row : British Airways, : HAV, MD ;
Row : Air China, : JNB Airbus ;
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 : Air India, : MAA, Airbus ;
Row : Aer Lingus, : MAD, Boeing ;
Row : Air China, : NKG Boeing ;
Row : United Airlines, : OAK, MD;
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 : American Airlines, : ONT, MD ;
Row : Lufthansa, : PMO, Boeing ;
Row : Southwest Airlines, : QRO, Airbus A;
Bottom level entry SJC points to a table block containing rows:
Row : Southwest Airlines, : SJC Boeing ;
Row : British Airways, : SVQ MD;
Row : Lufthansa, : THR Airbus A;
Row : Air India, : UTP, Airbus A;
Bottom level entry VAA points to a table block containing rows:
Row : Aer Lingus, : VAA, Boeing ;
Row : United Airlines, : WGA, Airbus A;
Row : Air India, : ZCL MD;
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 'Air India',
: 'GUM', '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
