Chapter 3: "MANAGING AND USING DATA"
Conferencing tools; online bulletin boards and chat facilities; email; and meeting support applications would be an example of which type of DSS? a) Communications-driven b) Data-driven c) Document-driven d) Knowledge-driven e) Model-driven
Answer: a
_____ includes anything that can be written down, stored, and codified. a) Explicit knowledge b) Implicit knowledge c) Tacit knowledge d) Persistent knowledge e) None of the above
Answer: a
A collection of records is known as a: a) Table b) Entry c) Category d) Field e) Database
Answer: a Difficulty: Easy
A mandatory course that you have to take that is part of your requirements for graduation would be an example of a/an: a) structured decision b) semistructured decision c) unstructured decision d) none of the above e) all of the above
Answer: a Difficulty: Easy
A model-driven DSS: a) emphasizes access to and manipulation of a model b) focuses on retrieval and management of unstructured documents c) emphasizes access and manipulation of internal company data and sometimes external data d) provides special problem-solving tools e) focuses on communications and shared decision making
Answer: a Difficulty: Easy
A specific combination of bits represents each data ______. a) Character b) Bit c) Byte d) Field
Answer: a Difficulty: Easy
Tables consist of _____ represented by the rows of the table: a) records b) items c) entities d) fields
Answer: a Difficulty: Easy
The primary technology used to store, manage, and allow efficient access to data is the: a) database b) data warehouse c) data farm d) cloud computing e) computer network
Answer: a Difficulty: Easy
The stage of business intelligence that produces useful information from the collected data and information is called: a) data analysis b) data sourcing c) situation awareness d) risk assessment e) decision support
Answer: a Difficulty: Easy
_____ is/are raw unorganized facts, numbers, pictures, and so on. a) Data b) Information c) Knowledge d) Wisdom e) None of the above
Answer: a Difficulty: Easy
The goal of visual analytics is the creation of tools and techniques to enable people to: a) Synthesize information and derive insight from massive, dynamic, ambiguous, and often conflicting data. b) Detect the expected and discover the unexpected. c) Provide timely, defensible, and understandable assessments. d) Communicate assessment effectively for action. e) All of the above
Answer: a Difficulty: Hard
The problem solving process consists of which of the following elements: a) investigate, analyze, decide, do b) discovery, transformation, analysis, synthesis, communication c) completeness, accuracy, reliability, relevance, objectivity, timeliness d) decision making, problem solving, communication, technology e) investigate, solving, choose, do
Answer: a Difficulty: Hard
In a large firm, custody of an entity's data is most appropriately maintained by which of the following personnel? a) Data librarian b) Systems analyst c) Computer operator d) Computer programmer e) Data Designer
Answer: a Difficulty: Medium
Problem solving refers to: a) a series of steps or a logical sequence of activities to respond to an event b) a series of steps that transforms an unstructured decision to a structured decision c) a series of steps that synthesizes several sources of information d) a logical sequence of activities to analyze a problem e) none of the above
Answer: a Difficulty: Medium
SQL stands for: a) structured query language b) structured query logic c) simplified query language d) none of the above
Answer: a Difficulty: Medium
This is a novel, complex situation, with no obvious or single correct decision or decision process: a) Unstructured decision b) Fully-structured decision c) Structured decision d) Semi-structured decision e) None of the above
Answer: a Difficulty: Medium
A specific combination of bits represents each data ________. a) mine b) character c) warehouse d) base e) none of the above
Answer: b
An anomaly is: a) A typical case b) An exceptional case c) An average case d) An only case
Answer: b
Decisions can be classified in the following ways: a) structured, unstructured, rational, problematic b) unstructured, semistructured, structured c) rational, irrational, problematic d) complete, accurate, reliable, timely e) unknown, known, uncertain
Answer: b
Which of the following is not an advantage of a database system? a) data independence b) increases data redundancy c) maintains quality of data d) handles security, synchronizes access by users e) allows for improved data access, different views of data, and report generation
Answer: b
Which of the following is one of the four perspectives of a balanced scorecard? a) Just in time. b) Innovation. c) Benchmarking. d) Activity-based costing. e) None of the above
Answer: b
A _____ depicts how data move through a system. a) ERD b) DFD c) Logical Data d) Waterfall Model e) None of the above
Answer: b Difficulty: Easy
A combination of characters representing a data item is known as a a) Table b) Field c) Entry d) Record e) Database
Answer: b Difficulty: Easy
A data ___________ is a means of storing and managing data for information access, typically composed of data from one or more transaction databases. a) base b) warehouse c) entity d) entry e) none of the above
Answer: b Difficulty: Easy
Breaking down the whole into its more discrete parts to better understand how it works describes: a) Discovery b) Analysis c) Transformation d) Synthesis e) Communication
Answer: b Difficulty: Easy
In the context of the IADD model, criteria are applied to evaluate each alternative's relative value and applicability in the __________ step. a) deliberate b) decide c) debate d) do e) delegate
Answer: b Difficulty: Easy
SQL stands for: a) Simple Query Language b) Structured Query Language c) Simple Question Language d) Structured Question Language e) None of the above
Answer: b Difficulty: Easy
A database consists of: a) Unrelated data b) Interrelated data c) Correlated data d) A and B e) B and C
Answer: b Difficulty: Medium
An elective course that you have to take (i.e., you must choose one liberal art course from a list would be an example of a/an: a) structured decision b) semistructured decision c) unstructured decision d) none of the above e) all of the above
Answer: b Difficulty: Medium
Executive information systems (EIS); geographic information systems (GIS); and OLAP-enabled data warehouses would be an example of which type of DSS? a) Communications-driven b) Data-driven c) Document-driven d) Knowledge-driven e) Model-driven
Answer: b Difficulty: Medium
Generating alternative solutions or choices to solve a problem may mean that you may have to gather more data. This means that you will be using which of the following knowledge work activities? a) transformation b) investigation c) analysis d) synthesis e) discovery
Answer: b Difficulty: Medium
If you only have seven digits of a phone number in Toronto, the information is: a) Complete b) Incomplete c) Inaccurate d) Accurate e) None of the above
Answer: b Difficulty: Medium
In order from first to last, the four phases of the decision-making process are: a) analysis, discovery, decision, execution b) discovery, analysis, decision, execution c) analysis, decision, discovery, execution d) decision, discovery, analysis, execution
Answer: b Difficulty: Medium
Knowledge work activities include all of the following except: a) discovery and transformation b) input and output c) analysis and synthesis d) communication of data e) information and knowledge
Answer: b Difficulty: Medium
Names of clients, their phone numbers, and their email addresses in an address book program in a personal digital assistant would be an example of: a) Data b) Information c) Knowledge d) Wisdom e) Fact
Answer: b Difficulty: Medium
Setting one's own schedule for the day represents which of the following decision? a) semistructured b) structured c) unstructured d) destructured e) multistructured
Answer: b Difficulty: Medium
The ASCII encoding scheme will use: a) 8 bytes b) 8 bits c) 16 bits d) 16 bytes
Answer: b Difficulty: Medium
The primary method for accessing and using data in an RDBMS is a: a) Inquiry b) Query c) Investigation d) Analysis e) Find
Answer: b Difficulty: Medium
The quality of the final output of this process (the decision) will likely be based on the quality of the inputs (the information and analysis you create) is the basis for this principle: a) FIDO b) GIGO c) AGO d) IADD e) none of the above
Answer: b Difficulty: Medium
The third stage of the IADD problem solving model is __________. a) deliberate b) decide c) debate d) defer e) delegate
Answer: b Difficulty: Medium
Using the search engines available on the Internet will aid you in which step of knowledge work activity? a) communication b) discovery c) analysis d) synthesis e) transformation
Answer: b Difficulty: Medium
_____ is/are organized and is/are useful to a person. a) Data b) Information c) Knowledge d) Wisdom e) Fact
Answer: b Difficulty: Medium
Management information systems (MIS) typically generate three types of reports. Which of the following isn't one of them? a) Demand reports b) Periodic reports c) Transaction reports d) Exception reports e) a or b
Answer: c
Who is quoted as saying "Knowledge is power"? a) Sir Alec Guinness b) Sir John A. Macdonald c) Sir Francis Bacon d) Sir Anthony Hopkins e) None of the above
Answer: c
_____ includes the know-how that people have through learning and experience, which is difficult to write down and share. a) Explicit knowledge b) Implicit knowledge c) Tacit knowledge d) Persistent knowledge e) Codified knowledge
Answer: c
_____ refers to a series of steps or a process (logical sequence of activities) taken in response to some event or activity a) Conflict resolution b) Debriefing c) Problem solving d) Situational Review e) None of the above
Answer: c
A _____ is a means of storing and managing data for information access, typically composed of data from one or more transaction databases. a) Data Mart b) Data Model c) Data Warehouse d) Data Mine e) Giant Base
Answer: c Difficulty: Easy
A data _____ consists of interrelated data that are stored in files and organized so that computer programs can quickly and easily access specific pieces of data. a) Warehouse b) Centre c) Base d) Hierarchy e) Mart
Answer: c Difficulty: Easy
DBMS stands for: a) Double Base Management System b) Dual Base Management System c) Data Base Management System d) Digital Base Management System e) None of the above
Answer: c Difficulty: Easy
Identifying decision options and evaluating them based on expectations of risk and reward describes which stage of business intelligence? a) Data Sourcing b) Data Analysis c) Risk Assessment d) Decision Support e) Dashboard
Answer: c Difficulty: Easy
The system that enables transaction activities and captures the key data created by the transaction is known as a/an: a) Document management system b) Expert system c) Transaction processing systems d) Slicing-and-Dicing e) Expert system
Answer: c Difficulty: Easy
To support tacit knowledge, knowledge management systems often rely on collaborative software, which supports teamwork with technologies that enable communication and sharing of data and information. This category is known as: a) Shareware b) Freeware c) Groupware d) Software e) Hardware
Answer: c Difficulty: Easy
What is the method used to ask something from a database? a) database demand b) record recall c) query d) request e) none of the above
Answer: c Difficulty: Easy
A/An _____ is one that can be programmed; it is routine or repetitive. a) Unstructured decision b) Fully-structured decision c) Structured decision d) Semi-structured decision
Answer: c Difficulty: Hard
If the mark you receive for this test is not correct, then it would be deemed: a) Complete b) Incomplete c) Inaccurate d) Accurate e) Mistake
Answer: c Difficulty: Hard
Which decision type below represents employing a new advertising campaign? a) Structured decision b Semi-structured decision c) Nonstructured decision d) Recurring decision e) Nonrecurring decision
Answer: c Difficulty: Hard
____ is/are created when a person combines experience and judgement. a) Data b) Information c) Knowledge d) Wisdom e) Idea
Answer: c Difficulty: Hard
A course that does not necessarily fit into the requirements for graduation (i.e. a course after you have graduated) that you decide to take is an example of a/an: a) structured decision b) semistructured decision c) unstructured decision d) none of the above e) all of the above
Answer: c Difficulty: Medium
A/An _____ exists when you find yourself in a situation that fails to meet your goals, needs, or expectations. a) Conflict b) Process c) Problem d) Situation e) None of the above
Answer: c Difficulty: Medium
Decision making can occur at many levels. Which is at the highest level? a) Tactical b) Operational c) Strategic d) None of the above e) a or b
Answer: c Difficulty: Medium
If you put up your umbrella just as the rain begins to fall, your action is: a) Reliable b) Unreliable c) Timely d) Untimely e) risky
Answer: c Difficulty: Medium
The two most commonly used models for designing the organization of a relational database are: a) DFD's and ERD's b) ERD's and Waterfall models c) SDLC and Waterfall d) Logical Data and DFD e) None of the above
Answer: e
The data hierarchy: a) determines which type of data has precedent over another type b) determines which type of data is faster than others c) organizes stored data in increasing levels of complexity d) all of the above e) None of the above
Answer: c Difficulty: Medium
The unique identifier of a record in a database is called a _____ key. a) Public b) Private c) Primary d) Foreign e) Important
Answer: c Difficulty: Medium
This type of DSS focuses on retrieval and management of unstructured documents. Which type is it? a) Communications-driven b) Data-driven c) Document-driven d) Knowledge-driven e) Model-driven
Answer: c Difficulty: Medium
Unicode will store a letter using: a) 8 bytes b) 8 bits c) 16 bits d) 16 bytes
Answer: c Difficulty: Medium
Which of the following is not an Information Characteristic? a) Complete b) Accurate c) Readable d) Timely e) None of the above
Answer: c Difficulty: Medium
_____ is a process for gaining competitive advantage through the intelligent use of data and information in decision making. a) Business process re-engineering b) Decision support c) Business intelligence d) Analysis e) Business engineering
Answer: c Difficulty: Medium
_____ is knowledge work that requires you to use the results to deepen your understanding of the data and information. a) Discovery b) Analysis c) Transformation d) Synthesis e) Communication
Answer: c Difficulty: Medium
_______ are the factors that you think are important and relevant to solving a problem. a) selections b) choices c) criteria d) determinants e) events
Answer: c Difficulty: Medium
This step of the IADD model is where you implement tasks and other physical activities according to your solution. a) Investigate b) Analyze c) Decide d) Do e) None of the above
Answer: d
Work in each of the participating areas, science and technology, focuses on different theoretical and practical aspects of users solving real-world problems using Information Technology. The benefit of collaboration between the science and technology is identified to be two-fold: a) Jointly tackling common problems will arrive at better results on the local level of each discipline, in a more efficient way. b) Integrating appropriate results from each of the disciplines will lay the fundament for significantly improved solutions in many important data analysis applications. c) a or b d) a and b e) none of the above
Answer: d
A _____ is a tool for asking a question of a database. a) Table b) Record c) Field d) Query e) Character
Answer: d Difficulty: Easy
A collection of fields is known as a: a) Table b) Entry c) Category d) Record e) Database
Answer: d Difficulty: Easy
In which method do databases store information about entities? a) entity relationship diagram b) Porter's five forces model c) data entity method d) relational data model e) none of the above
Answer: d Difficulty: Easy
A _____ extracts and reorganizes subject-area-specific data to allow business professionals to focus on a specific subject area. a) Data Model b) Data Warehouse c) Data Mine d) Data Mart e) Data Set
Answer: d Difficulty: Medium
A decision support system is a: a) Highly flexible IT system b) Interactive IT system c) Designed to support decision making d) All of the above e) None of the above
Answer: d Difficulty: Medium
A key that is borrowed from another table to create another table is called a _____ key. a) Public b) Private c) Primary d) Foreign e) Secondary
Answer: d Difficulty: Medium
Decision making can occur at many levels. Which is the most fundamental and lowest level? a) Technical b) Operational c) Strategic d) None of the above e) a and b
Answer: d Difficulty: Medium
Expert systems (ES); artificial intelligence applications; and data mining tools would be an example of which type of DSS? a) Communications-driven b) Data-driven c) Document-driven d) Knowledge-driven e) Model-driven
Answer: d Difficulty: Medium
Sometimes even simple decisions may have increased uncertainty, or doubt about consequences and outcomes, associated with them. This would be an example of a: a) Unstructured decision b) Fully-structured decision c) Structured decision d) Semi-structured decision
Answer: d Difficulty: Medium
There are multiple ways of organizing knowledge management systems. Which of the following isn't one of them? a) balanced scorecard b) dashboard c) measurement matrix d) query e) none of the above
Answer: d Difficulty: Medium
There are two commonly used models for designing the organization of a relational database. Which of the following is one of them? a) RDBMS b) DBMS c) ERP d) ERD e) DFD
Answer: d Difficulty: Medium
This type of DSS provides special problem-solving tools that help decision making by suggesting or recommending actions to users. Which type is it? a) Communications-driven b) Data-driven c) Document-driven d) Knowledge-driven e) Model-driven
Answer: d Difficulty: Medium
Which of the following is not a stage of Business Intelligence? a) Data Sourcing b) Data Analysis c) Situation Awareness d) Risk Avoidance e) All of the above
Answer: d Difficulty: Medium
_____ adds insight and ethics to the experience and professional judgement. a) Data b) Information c) Knowledge d) Wisdom e) None of the above
Answer: d Difficulty: Medium
_____ allows you to interpret trends or patterns that seem to explain the past and the present, and may suggest courses of action likely to favourably influence the future. a) Discovery b) Analysis c) Transformation d) Synthesis e) Communication
Answer: d Difficulty: Medium
A data __________ extracts and reorganizes subject-area-specific data. a) base b) warehouse c) entity d) entry e) none of the above
Answer: e
The top level of the data hierarchy compiles the organized collection of files into a: a) Table b) Entry c) Category d) Field e) Database
Answer: e Difficulty: Easy
) The Balanced Scorecard is a a) causal model of lead indicators of performance. b) causal model of lag indicators of performance. c) causal model of lead and lag indicators of performance. d) cause-and-effect relationship model of financial indicators of performance. e) None of the above.
Answer: e Difficulty: Hard
Which of the following is not a component of a traditional DFD? a) the external entities that send input or receive output from the system b) processes that show activities that move or transform data c) data stores that usually correspond to tables in the data model d) data flows that connect the components e) None of the above
Answer: e Difficulty: Hard
According to the text, knowledge work consists of all of the following activities except: a) communication b) discovery c) analysis d) synthesis e) networking
Answer: e Difficulty: Medium
Database technology is _____ compared to data warehouse technology when discussing response time. a) Much Slower b) A little slower c) About the same d) A little faster e) Much faster
Answer: e Difficulty: Medium
The ability to share your analyses, ideas, and solutions with others refers to: a) Discovery b) Analysis c) Transformation d) Synthesis e) Communication
Answer: e Difficulty: Medium
Which of the following is not a major step in the IADD model? a) Investigate b) Analyze c) Decide d) Do e) None of the above
Answer: e Difficulty: Medium