Question: 4) Assume that the database block size is 2K. Also assume that the Oracle database uses PCTFREE 20 percent and PCTUSED 40 percent. For

4) Assume that the database block size is 2K. Also assume that the Oracle database uses PCTFREE 20 percent and PCTUSED 40 percent. For this problem we will assume that any overhead in blocks is zero. Suppose a university has the a table in their database which supports variable length records. Some records are students, others are faculty: I Student Record Attributes StudentID name univAddress majorName Phone Bytes 9 30 40 10 10 Faculty Record Attributes SSN firstName lastName homeAddress deptID OfficePhone email terminal Degree dissertation Title university Committees Bytes 9 10 20 60 11 10 20 5 40 30 Assume there are 15,000 students and 1,200 faculty at the university. A) Assume that the UHCL Student file uses an unspanned organization. That is, no record is may split across disk blocks. Ignore any overhead. Show work for each question below. It is worth a a) Calculate the record size in bytes. (3 points) b) Calculate the blocking factor of the data file. (3 points) c) Calculate the number of file blocks. (4 points) B) Assume that the UHCL Faculty file uses an unspanned organization. That is, no record is may split across disk blocks. Ignore any overhead. Show work for each question below. It is worth a a) Calculate the record size in bytes. (3 points) b) Calculate the blocking factor of the data file. (3 points) c) Calculate the number of file blocks. (4 points)
Step by Step Solution
3.45 Rating (161 Votes )
There are 3 Steps involved in it
A UHCL Student File a Calculate the record size in bytes Student Record StudentID 9 bytes Name 30 by... View full answer
Get step-by-step solutions from verified subject matter experts
