Page 1 of 1
Person(PersonID, FirstName, LastName, Birthyear, DepartmentNo) This time however, the records are stored in a heap file
Posted: Wed Apr 27, 2022 3:40 pm
by answerhappygod
- Person Personid Firstname Lastname Birthyear Departmentno This Time However The Records Are Stored In A Heap File 1 (73.07 KiB) Viewed 36 times
Person(PersonID, FirstName, LastName, Birthyear, DepartmentNo) This time however, the records are stored in a heap file containing 1250 blocks. In addition to this we have an unclustered B+ tree with LastName as the search key. At the leaf level in this tree we will have pointers to the records stored in the heap. Assume that the B+ tree has 300 blocks at the leaf level and with 3 levels. Give an estimate for how many blocks are accessed by the following SQL queries. Write a short explanation for each answer, and remember to write down any assumptions that you find necessary 2 1. SELECT * From Person; 2. SELECT * From Person WHERE PersonlD = 195800; 3. SELECT PersonID WHERE LastName = "Søkerud"; 4. SELECT DISTINCT LastName FROM Person; 5. INSERT INTO Person(195230, 'Per', 'Persen', 1971, 185);