CSIS-114 Exam 1
Created: 12:07:24 PM EDT

1. / Data that is always accurate and available – not just sometimes.
A. / Precise data
B. / Reliable data
C. / Effective data
D. / Relevant data
2. / Which of the following data attributes pertain to the delivery of the data. Check only the ones that are related to data delivery.

____Simple
__X_Secure
____Complete
__X_Timely

3. / Which of the following are true regarding a GIS. Check all that are true.

__X__A GIS can be used in marketing products
____GIS stands for Graphical Interface System
__X__A GIS links geographical data with descriptive data
__X__A GIS can be used to facilitate decision making
____A GIS only includes metadata

4. / Data that is error free and as close to the truth as possible can be described as
A. / Verifiable
B. / Reliable
C. / Effective
D. / Relevant
E. /

Accurate

5. / Which of the following is the best example of metadata?
A. / The price of a car
B. / A social security number
C. / The creation date of a report
D. / The approximate value of a house
6. / Some data attributes are enemies. For example, secure and accessible are enemies. Making data more accessible decreases the level of security, whereas improving data security may reduce accessibility. Which of the following is the best example of attributes that are enemies.
A. / Reliable and accurate
B. /

Simple and complete

C. / Verifiable and reliable
D. / Flexible and accessible
7. / From you answer above, explain why these two attributes are enemies.

Complete data could be quite massive and complex, i.e., not simple.
Simple data could be a brief summary of complex data, i.e., not complete

8. / Which of the following are examples of Information System Resources. Check all the apply. Hint: Recall the 5 components of Information Systems

____Heating oil
__X__End Users
__X__Hard Disks
__X__Spreadsheet Program
__X__The Internet
__X__Customer Records
____Delivery Trucks
____Paper

9. / What is the difference between a system variable and a system parameter?

A Variable can be changed, whereas a parameter is something that can’t be changed.

10. / A Process Control System is an example of an Information System the supports ______.
A. / Management
B. /

Operations

C. / Re-engineering
D. / Decision Making
11. / Which of the following Information Systems primarily supports Management?
A. /

Decision Support System

B. / Enterprise Collaboration System
C. / Transaction Processing System
D. / Process Control System
12. / Information Systems can be divided into two general categories. What are they?
A. / Re-engineering Systems and Gradual Improvement Systems
B. /

Operations and Management

C. / Decision Support and Enterprise Resource Management
13. / Information Systems include hardware, software, and networks. What are the two other essential components that are often forgotten?

People and Data

14. / A thermostat is an example of a system for controlling a furnace. All systems include some form of input, output, processing, and feedback. Match each specific example with the correct label.
1.Input / The current temperature and the desired temperature / 1
2.Output / Compare the current temperature with the desired temperature / 4
3.Feedback / Turning the furnace on / 2
4.Processing / The current temperature starts to increase / 3
15. / Match each group of examples with the correct label.
1.Output / People, Money, Energy, Data, Materials / 4
2.Processing / Market, Develop, Sort, Summarize, Deliver / 2
3.Feedback / Products, Information, Services, Summaries, Contributions / 1
4.Input / Efficiency rate, accuracy, too low, too high, profit margins / 3____
16. / Match each of the following Information Systems with the most likely user.
1.Decision Support System / Strategic decision makers such as vice presidents or the CEO / 2
2.Executive Information System / End users that make strategic or tactical decisions. / 1
3.Transaction Processing Systems / Operations staff / 3
4.Enterprise Collaboration System / Staff, managers, and executives / 4___
17. / In an information system, which one of the following would be considered the most applicable description of application software?
A. / Controls and supports the operations of a computer.
B. / Consists of programs that direct the processing activities of a particular use of computers by end users.
C. / Are operating instructions for the people who will use an information system.
D. / All of the above.
18. / A petroleum refinery uses electronic sensors linked to computers to continually monitor chemical processes and make instant (real-time) adjustments that control the refinery process. This is an example of a(n):
A. / Transaction processing system.
B. / Process control system.
C. / Enterprise collaboration system.
D. / Decision support system.
19. / A production manager needs a system to determine how much product to manufacture based on the expected sales associated with a future promotion and the location and availability of the raw materials necessary to manufacture the product. The production needs what type of system to meet her needs?
A. / Transaction processing system.
B. / Process control system.
C. / Enterprise collaboration system.
D. / Decision support system.
20. / Which one of the following would NOT be considered a good example of information?
A. / The company’s forklift operator’s social security number is 456-38-1
B. / The retail price of blue widgets is $14
C. / The company owes $3,847 to vendor number 10
D. /

The numbers 12367892, 436897458, and 837621

21. / Within the context of an information system, which one of the following would be considered a typical end user?
A. / Managers.
B. / Accountants.
C. / Customers.
D. / All of the above.
22. / Transaction processing systems work in two basic ways: batch processing and real-time processing. In real-time processing, transactions are accumulated over a period of time and processed periodically.

TrueFalse

23. / Data is the derivative of manipulating, organizing, summarizing, and presenting information in a form suitable for decision-making or further analysis.

TrueFalseNote: Derivative meand “resulting from” data is not a result of information. Information is the result of processing data.

24. / Your text defines ______as a type of language found in many database management packages. They are becoming a standard for advanced databases management system packages. A basic form is SELECT ... FROM ... WHERE.

Structured Query Language; SQL

25. / A data______can be defined as a subset of a data warehouse, in which a highly summarized or focused portion of the data warehouse is kept.

Mart

26. / In a database management system, a group of related records is referred to as a ______.

File or Table

27. / A major use of data warehouse databases is data ______. In this activity, the data in a data warehouse are processed to identify key factors and trends in historical patterns of business activity.

Data Mining

28. / Your text discusses the organization of data in an information system. A record represents:
A. / A single alphabetic, numeric, or other symbol.
B. / A grouping of characters.
C. / A collection of attributes that describes an entity.
D. / A group of related records.
29. / This database model consists of data values describing the attributes of an entity, and the operations that can be performed upon the data:
A. / Hierarchical structure.
B. / Network structure.
C. / Relational structure.
D. / Object-oriented structure.
30. / A graphic method of representing entity classes and their relationships is
A. / A query-by-example tool.
B. / An entity-relationship diagram.
C. / An intersection relation diagram.
D. / A flowchart.
31. / When you bring together logically associated files or tables, you create a
A. / Character.
B. / Field.
C. / Record.
D. / Database.
32. / If employees from more than one department can work on more than one project, the best choice of data structure model to handle this database structure would be the hierarchical data structure. The hierarchical data structure can easily handle this many-to-many relationship.

TrueFalse, hierachical can not support many-to-many relationships

33. / According to your text, data may be logically organized into characters, fields, records, files, and databases. A database consolidates records previously stored in separate files into a common pool of data records that provides data for many applications.

TrueFalse

34. / Give an example of a one to many relationship. Draw a diagram that clearly indicates the two entities and the relationship that connects them.

An employee can work on many projects. A project can be worked on by many employees.

35. / In a relational database, how many tables total are required to store and represent a many to many relationship between two entities.

At least 3 tables. 1 table for each entity and a third table to store the relationship.

36. / Which software technology is more applicable for creating charts and graphs?
A. / Spreadsheet software
B. / Database Management software
37. / Which software technology is more applicable for storing vital financial data.
A. / Spreadsheet software
B. / Database Management software
38. / In relational database, two entities (i.e., Customers and Products) can be related in more than one way.

True, a customer could order a product, buy a product, return a product, etc.False

39. / As long as tables in a database ______, they can be linked to provide useful information.
A. / can be projected
B. / share a common entity
C. / share a common attribute
D. / have the same data type
40. / Briefly explain a specific advantage of centralizing data in a database.

(1) Reduces redundancy (2) Easier to update (3) Easier to share information