Exam 2 Study Guide 2 1 
STUDY GUIDE
Exam 2, Chapters 5-8
CIT 3013 Sinclaire
SPRING 2015
1. What is the purpose of IT infrastructure? Define IT infrastructure. Describe the purpose of IT infrastructure.
Describe the five major categories of IT infrastructure and provide several examples of each.
2. Three contemporary hardware trends are mobile computing, consumeriation of IT and BYOD, and virtualization. Define and describe each of these trends (provide details and examples) and discuss the impact of each trend on business organizations.
3. Distinguish between application software and system software, and explain the role played by the operating system of a computer. Define application software. Define system software. Describe the role of each and provide several examples of each. Define proprietary software and open source software and describe the difference.
4. List and describe the major components of the total cost of ownership (TCO) model of information technology assets. Why do you think these costs are sometimes referred to as “hidden costs”?
5. What is a database? How does a relational database organize data? Define database and explain how a relational database organizes data. Define and explain the significance of entities, attributes, and key fields and provide an example of each. Include a diagram of two tables to improve the clarity of your discussion. Note which fields are primary keys and which are foreign keys. See figures 6.1 and 6.2.
6. What is the role of information policy and data administration in the management of organizational data resources? Define information policy and data administration and explain how they help organizations manage their data.
7. Why is data quality assurance so important for a business? List and describe the most common data quality problems. List and describe the most important tools and techniques for assuring data quality.
8. What are the principle components of telecommunications networks and key networking technologies? Describe
the
Exam 2, Chapters 5-8
CIT 3013 Sinclaire
SPRING 2015
1. What is the purpose of IT infrastructure? Define IT infrastructure. Describe the purpose of IT infrastructure.
Describe the five major categories of IT infrastructure and provide several examples of each.
2. Three contemporary hardware trends are mobile computing, consumeriation of IT and BYOD, and virtualization. Define and describe each of these trends (provide details and examples) and discuss the impact of each trend on business organizations.
3. Distinguish between application software and system software, and explain the role played by the operating system of a computer. Define application software. Define system software. Describe the role of each and provide several examples of each. Define proprietary software and open source software and describe the difference.
4. List and describe the major components of the total cost of ownership (TCO) model of information technology assets. Why do you think these costs are sometimes referred to as “hidden costs”?
5. What is a database? How does a relational database organize data? Define database and explain how a relational database organizes data. Define and explain the significance of entities, attributes, and key fields and provide an example of each. Include a diagram of two tables to improve the clarity of your discussion. Note which fields are primary keys and which are foreign keys. See figures 6.1 and 6.2.
6. What is the role of information policy and data administration in the management of organizational data resources? Define information policy and data administration and explain how they help organizations manage their data.
7. Why is data quality assurance so important for a business? List and describe the most common data quality problems. List and describe the most important tools and techniques for assuring data quality.
8. What are the principle components of telecommunications networks and key networking technologies? Describe
the