Deck 3: Managing and Using Data

Question 1

_____ is/are raw unorganized facts, numbers, pictures, and so on.

A) Data
B) Information
C) Knowledge
D) Wisdom
E) None of the above

Answer 1

Data

Question 2

_____ is/are organized and is/are useful to a person.

A) Data
B) Information
C) Knowledge
D) Wisdom
E) Fact

Answer 2

Information

Question 3

_____ is/are created when a person combines experience and judgement.

A) Data
B) Information
C) Knowledge
D) Wisdom
E) Idea

Answer 3

Knowledge

Question 4

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

Question 5

_____ adds insight and ethics to the experience and professional judgement.

A) Data
B) Information
C) Knowledge
D) Wisdom
E) None of the above

Question 6

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

Question 7

_____ 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

Question 8

_____ 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

Question 9

An anomaly is:

A) A typical case
B) An exceptional case
C) An average case
D) An only case

Question 10

The ability to share your analyses, ideas, and solutions with others refers to:

A) Discovery
B) Analysis
C) Transformation
D) Synthesis
E) Communication

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

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

Question 16

Which of the following is not an Information Characteristic?

A) Complete
B) Accurate
C) Readable
D) Timely
E) None of the above

Question 17

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

Question 18

_____ 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

Question 19

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

Question 20

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

Question 21

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

Question 22

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

Question 23

The third stage of the IADD problem solving model is __________.

A) deliberate
B) decide
C) debate
D) defer
E) delegate

Question 24

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

Question 25

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

Question 26

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

Question 27

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

Question 28

_______ are the factors that you think are important and relevant to solving a problem.

A) selections
B) choices
C) criteria
D) determinants
E) events

Question 29

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

Question 30

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

Question 31

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

Question 32

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

Question 33

According to the text, knowledge work consists of all of the following activities except:

A) communication
B) discovery
C) analysis
D) synthesis
E) networking

Question 34

Setting one's own schedule for the day represents which of the following decision?

A) semistructured
B) structured
C) unstructured
D) destructured
E) multistructured

Question 35

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

Question 36

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

Question 37

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

Question 38

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

Question 39

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

Question 40

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

Question 41

A specific combination of bits represents each data ______.

A) Character
B) Bit
C) Byte
D) Field

Question 42

The ASCII encoding scheme will use:

A) 8 bytes
B) 8 bits
C) 16 bits
D) 16 bytes

Question 43

Unicode will store a letter using:

A) 8 bytes
B) 8 bits
C) 16 bits
D) 16 bytes

Question 44

A combination of characters representing a data item is known as a

A) Table
B) Field
C) Entry
D) Record
E) Database

Question 45

A collection of fields is known as a:

A) Table
B) Entry
C) Category
D) Record
E) Database

Question 46

A collection of records is known as a:

A) Table
B) Entry
C) Category
D) Field
E) Database

Question 47

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

Question 48

The unique identifier of a record in a database is called a _____ key.

A) Public
B) Private
C) Primary
D) Foreign
E) Important

Question 49

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

Question 50

The primary method for accessing and using data in an RDBMS is a:

A) Inquiry
B) Query
C) Investigation
D) Analysis
E) Find

Question 51

A _____ is a tool for asking a question of a database.

A) Table
B) Record
C) Field
D) Query
E) Character

Question 52

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

Question 53

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

Question 54

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

Question 55

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

Question 56

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

Question 57

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

Question 58

Tables consist of _____ represented by the rows of the table:

A) records
B) items
C) entities
D) fields

Question 59

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

Question 60

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

Question 61

A database consists of:

A) Unrelated data
B) Interrelated data
C) Correlated data
D) A and B
E) B and C

Question 62

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

Question 63

A specific combination of bits represents each data ________.

A) mine
B) character
C) warehouse
D) base
E) none of the above

Question 64

A _____ depicts how data move through a system.

A) ERD
B) DFD
C) Logical Data
D) Waterfall Model
E) None of the above

Question 65

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

Question 66

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

Question 67

A data __________ extracts and reorganizes subject-area-specific data.

A) base
B) warehouse
C) entity
D) entry
E) none of the above

Question 68

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

Question 69

What is the correct ascending hierarchy of data in a system?

A) Character, record, file, field.
B) Field, character, file, record.
C) Character, field, record, file.
D) Field, record, file, character
E) File, record, field, character

Question 70

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

Question 71

_____ 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

Question 72

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

Question 73

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

Question 74

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

Question 75

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

Question 76

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

Question 77

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

Question 78

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

Question 79

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

Question 80

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