Reference no: EM131357840
QUESTIONS
1. Describe the following disk concepts or components.
a. Platter and recording surface.
b. Track.
c. Cylinder.
d. Read/write head.
e. Access-arm mechanism.
2. Why is it important to store files on a cylinder-by-cylinder basis?
3. Describe the four steps in the transfer of data from disk to primary memory.
4. What is a file organization? What is an access method? What do they accomplish?
5. What is an index? Compare the concept of the index in a book to an index in an information system.
6. Describe the idea of the simple linear index. What are its shortcomings?
7. What is an indexed-sequential file?
8. Describe the idea of the B+-tree index. What are its advantages over the simple linear index?
9. Describe how a direct search works using a B+-tree index.
10. Describe what happens to the index tree when you insert new records into a file with a B+-tree index.
11. Answer the following general questions about indexes:
a. Can an index be built over a non-unique field?
b. Can an index be built over a field if the file is not stored in sequence by that field?
c. Can an index be built over a combination of fields as well as over a single field?
d. Is there a limit to the number of indexes that can be built for a file?
e. How is an index affected when a change is made to a file? Does every change to a file affect every one of its indexes?
f. Can an index be used to achieve sequential access? Explain.
12. Describe the idea of the hashed file. What are its advantages and disadvantages in comparison to indexes?
13. Describe how a direct search works in a hashed file using the division-remainder method of hashing.
14. What is a collision in a hashed file? Why do collisions occur? Why are they of concern in the application environment?
15. What is physical database design?
16. Describe why physical database design is necessary.
17. Explain why the need to perform joins is an important factor affecting application and database performance.
18. Why does the degree to which data is dispersed over a disk affect application and database performance?
19. Explain why the volume of data access operations can adversely affect application and database performance.
20. Which "input" is the starting point for physical database design?
|
Assume that market is in equilibrium
: Assume that the market is in equilibrium. MY stock is currently selling for $30 per share. The stock is expected to pay a $3 dividend at the end of the year. The stock’s dividend is expected to grow at a constant rate of 7 percent per year forever. T..
|
|
Deduce that the sample derived by this sampling mechanism
: In the exercise above, examine the impact of using a truncated exponential distribution Exp(λ) on the variance of the approximation of the tail probability.
|
|
What is the company current stock price
: Your company paid a dividend of $3.00 last year (D0 =3.0). The growth rate is expected to be 10 percent for first year, 8 percent the second year, then 7 percent for the third year, and then the growth rate is expected to be a constant 6 percent ther..
|
|
Economy the marshall-lerner condition
: Assume that for an economy the Marshall-Lerner condition does not hold, and further, elasticities are such that the depreciation of the domestic currency actually worsens the current account balance. Also assume that the economy is operating under..
|
|
Describe why physical database design is necessary
: What is physical database design? Describe why physical database design is necessary. Explain why the need to perform joins is an important factor affecting application and database performance.
|
|
What is the firm required rate of return
: Cool Company's stock has a beta of 1.40, the risk-free rate is 4.25%, and the market risk premium (rM – rRF) is 5.50%. What is the firm's required rate of return?
|
|
Reducing federal government discretionary powers
: Reducing federal government's discretionary powers Tax incentives for saving Evaluate both the advocates' position and the critics' position.
|
|
What is the required rate of return on bs stock
: Stock A's stock has a beta of 1.30, and its required return is 12.00%. Stock B's beta is 0.80. If the risk-free rate is 3.50%, what is the required rate of return on B's stock?
|
|
Deduce a monte carlo approximation
: Express the probability as an integral and use an obvious change of variable to rewrite this integral as an expectation under a U(0, 1/20) distribution. Deduce a Monte Carlo approximation to Pr(X > 20) along with an error assessment.
|