Database store concepts question about blocking 1. [10] La Trobe University has approximately 20,000 active students. On

Database store concepts question about blocking 

 

Transcribed Image Text:

1. [10] La Trobe University has approximately 20,000 active students. On the average, a student data will require 500 characters. The student table is stored in Oracle Database: No Question a Block Size (Bytes) b Blocking Factor (bfr) C d Number of blocks required Total space required (Bytes) e Total used space (Bytes) f Total wasted space (Bytes) Answer 8192 Page 5 of 7 2. [10] The length of student ID is 15 Bytes. If the data is stored in ordered by the student ID, calculate the number of blocks required to obtain these data. We assume that there is only 1 level of block index. We assume that pointer size is OB. No Kth data Without index Dense Index a 1st student data 1 Sparse Index 2 b 1,000 th student data 2 d 10,000th student data 20,000th student data 625 26 1250 3 1. [10] La Trobe University has approximately 20,000 active students. On the average, a student data will require 500 characters. The student table is stored in Oracle Database: No Question a Block Size (Bytes) b Blocking Factor (bfr) C d Number of blocks required Total space required (Bytes) e Total used space (Bytes) f Total wasted space (Bytes) Answer 8192 Page 5 of 7 2. [10] The length of student ID is 15 Bytes. If the data is stored in ordered by the student ID, calculate the number of blocks required to obtain these data. We assume that there is only 1 level of block index. We assume that pointer size is OB. No Kth data Without index Dense Index a 1st student data 1 Sparse Index 2 b 1,000 th student data 2 d 10,000th student data 20,000th student data 625 26 1250 3