4) Assume that the database block size is 2K. Also assume that the Oracle database uses...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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) 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)
Expert Answer:
Answer rating: 100% (QA)
A UHCL Student File a Calculate the record size in bytes Student Record StudentID 9 bytes Name 30 by... View the full answer
Related Book For
Essentials Of Business Analytics
ISBN: 9781337406420
3rd Edition
Authors: Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson, Dennis J. Sweeney, Thomas A. Williams
Posted Date:
Students also viewed these programming questions
-
For this problem we will use the data in the file Global100 that was referenced in Section 3.4 as an example for creating a treemap. Here we will use these data to create a GIS chart. A portion of...
-
Suppose a university has 10,000 full-time students and 5,000 half-time students. Using the concept of equivalent units, compute the number of full-time equivalent students.
-
An Oracle database uses a block size of 4 KB for its I/O operation. The application that uses this database primarily performs a sequential read operation. Suggest and explain the appropriate values...
-
Determine the order of growth of the running time of this statement in ThreeSum as a function of the number of integers \(n\) on standard input: int[] a = StdIn. readA11Ints(); Answer: Linear. The...
-
Why might the profession allow some services to be performed for non-public clients that cannot be performed for public company clients?
-
Two irregular objects A and B carry charges of opposite sign. Figure Q21.19 shows the electric field lines near each of these objects. (a) Which object is positive, A or B? How do you know? (b) Where...
-
Fleetwood Homebuilders issued S200,000 of \(6 \%, 10\)-year bonds at par on August 31. Fleetwood pars semiannual interest on February 28 and August 31. Journalize for Fleetwood: a. Issuance of the...
-
On January 1, 2015, a city entered into the following leases for equipment items. Each of the leases qualifies as a capital lease. Initial payments are on December 31, 2015. An interest rate of 12...
-
a) . Consider a portfolio of 20 domestic stocks with $10m in each stock. Explain how you can use the variance-covariance (VCV) method and the single index model (SIM) to calculate the Value at Risk...
-
Alaska Airlines showed the following items in its balance sheet as of December 31, 2011, the end of the fiscal year ($ in millions): Inventories and supplies .............. $ 44.3 Prepaid expenses...
-
PLEASE HELP I CANT MAKE THIS CODE WORK FOR ME,... JAVA import javax.swing.*; public class Dictionary { public static void main(String[] args){ WordList newDictionary = new WordList("school");...
-
Discuss the complexities involved in international financial management, including foreign exchange risk management, global capital budgeting, and cross-border investment strategies.
-
5. Solve the equations AX=Y, where: 13 -8 -3 [20 X1 10-1,Y=-5, X = X2 A=-8 -3-1 -1 11 0 X3 Attach the results
-
how do you know which equation to use for sustainable growth? There are several: g*=PRAT g*= R x ROEbop g* = change in equity / equity bop g*= R x Earnings / Equity What is the formula for Actual...
-
What are the implications of incorporating machine learning algorithms, such as deep learning neural networks, in the identification and mitigation of operational risks within large-scale financial...
-
How can I overcome the challenges of measuring marketing effectiveness?
-
The shape of demand curves firms face may change from one form of market structure to another. In addition, there are several factors that influence the nature of firms, including the level of...
-
Teasdale Inc. manufactures and sells commercial and residential security equipment. The comparative unclassified balance sheets for December 31, 2015 and 2014 are provided below. Selected missing...
-
A European put option on a currency allows you to sell a unit of that currency at the specified strike price (exchange rate) at a particular point in time after the purchase of the option. For...
-
Marilyn Marshall, a Professor of sports economics, has obtained a data set of home attendance for each of the 30 major league baseball franchises for each season from 2010 through 2016. Dr. Marshall...
-
Zeitlers Department Stores sells its products online and through traditional brick-andmortar stores. The following parallel-coordinates plot displays data from a sample of 20 customers who purchased...
-
United Technologies Corporation (UTC), based in Hartford, Connecticut, owns a wide variety of companies that operate in different businesses and industries. Some of the companies in UTCs portfolio...
-
How does the auditors professional duty of confidence affect disclosures to third parties?
-
When can auditors disclose unlawful acts to the police?
Study smarter with the SolutionInn App