ITC 4175 Unit V Assessment

Question 1

What is a cache? What types of cache are used in databases? How are they used to impact performance? Your response should be at least 200 words in length. You are required to use at least your textbook as source material for your response. All sources used, including the textbook, must be referenced; paraphrased and quoted material must have accompanying citations.

Question 2

Identify and briefly discuss the various components that affect system performance. Your response should be at least 200 words in length. You are required to use at least your textbook as source material for your response. All sources used, including the textbook, must be referenced; paraphrased and quoted material must have accompanying citations.

Question 3

Choose three or four of the twelve SQL Rules of Thumb presented in Chapter 12 that you think are the most crucial. Why are these rules so important? Provide examples of when each of the rules you chose are applicable. Your response should be at least 200 words in length. You are required to use at least your textbook as source material for your response. All sources used, including the textbook, must be referenced; paraphrased and quoted material must have accompanying citations.

Question 4

Explain the relationship between system performance, database performance, and application performance. Your response should be at least 200 words in length. You are required to use at least your textbook as source material for your response. All sources used, including the textbook, must be referenced; paraphrased and quoted material must have accompanying citations.

References

Kriegel, A. (2011). Discovering SQL: A hands-on guide for beginners. Indianapolis, IN: Wiley Publishing.

Mullins, C. S. (2013). Database administration: The complete guide to DBA practices and procedures (2nd ed.). Upper Saddle River, NJ: Addison-Wesley Professional.