Data And Knowledge Management Full Test Bank Ch.5 9e - Info Systems 9e | Test Bank by Rainer by R. Kelly Rainer. DOCX document preview.
Package Title: Chapter 5, Testbank
Course Title: Rainer, IS 9e
Chapter Number: 5
Question type: Multiple Choice
1) The use of ____ genetic databases has ignited a debate regarding the ____ Amendment.
a) cloud computing; First
b) cloud computing; Fourth
c) open-source; First
d) open-source; Fourth
Difficulty: Easy
Section Reference 1: Opening Case
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
2) GEDmatch requires its customers to opt ____ to allow law enforcement agencies to access their ____ data.
a) in; clickstream
b) in; genetic
c) out; clickstream
d) out; genetic
Difficulty: Easy
Section Reference 1: Opening Case
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
3) _________ is a data management and business intelligence company that specializes in data integration and analytics.
a) Avast
b) GEDmatch
c) Enigma
d) Scada
Difficulty: Easy
Section Reference 1: IT’s About Business 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
4) Enigma uses ____ algorithms to collect, clean, organize, integrate, and analyze data.
a) expert system
b) intelligent system
c) machine learning
d) neural network
Difficulty: Easy
Section Reference 1: IT’s About Business 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
5) Enigma uses hard-to-find data such as _____
a) FAA flight logs
b) FCC data
c) FOIA requests
d) FEC results
Difficulty: Easy
Section Reference 1: IT’s About Business 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
6) The amount of data is ____ over time. Data sources are often in the form of data ____.
a) decreasing; streams
b) decreasing; waterways
c) increasing; streams
d) increasing; waterways
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
7) ________ are those data that visitors and customers produce when they visit a website and click on hyperlinks.
a) Clickstream data
b) Cookies
c) ERP
d) RFID
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
8) Which of the following is an example of an internal source of data?
a) commercial databases
b) corporate databases
c) corporate websites
d) personal experiences
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
9) Which of the following is an example of an personal source of data?
a) company documents
b) corporate databases
c) corporate websites
d) opinions
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
10) Which of the following is an example of an external source of data?
a) commercial databases
b) company documents
c) corporate databases
d) personal experiences
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
11) Which of the following is an example of an external source of data?
a) commercial databases
b) company documents
c) government reports
d) opinions
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
12) Which of the following is NOT a reason managing data is difficult?
a) Data are generated from multiple sources.
b) Data are scattered throughout organizations.
c) Data are subject to data rot.
d) The amount of data is decreasing exponentially with time.
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
13) Data ________ refers primarily to problems with the media on which the data are stored.
a) clickstreaming
b) degradation
c) scattering
d) rot
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
14) You recently inherited an Alvin and The Chipmunks “A Chipmunk Christmas” record. Since you don’t have a record player, you need to find a way to convert the record into a CD. This is an example of data ________.
a) clickstreaming
b) degradation
c) scattering
d) rot
Difficulty: Medium
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Application
Standard 1: AACSB || Technology
15) _____________ requires that public companies evaluate and disclose the effectiveness of their internal financial controls.
a) FERPA
b) HIPAA
c) PATRIOT
d) SOX
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
16) ________ is an approach to managing information across an entire organization.
a) Big data
b) Data governance
c) Master data
d) Master data management
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
17) ________ is a process that spans all organizational business processes and applications.
a) Big data
b) Data governance
c) Master data
d) Master data management
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
18) ________ are a set of core data that span the enterprise information systems.
a) Data governance
b) Master data
c) Master data management
d) Transaction data
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
19) ________ are generated and captured by operational systems and describe the business’s activities.
a) Data governance
b) Master data
c) Master data management
d) Transaction data
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
20) From the mid-1950s until the early 1970s, organizations managed their data in a _________; this created ________.
a) database; a centralized location for information
b) database; information silos
c) file management environment; a centralized location for information
d) file management environment; information silos
Difficulty: Hard
Section Reference 1: 5.2
Learning Objective 5.1: Discuss the advantages and disadvantages of relational databases.
Bloomcode: Knowledge, Synthesis
Standard 1: AACSB || Technology
21) Database systems minimize ________.
a) independence
b) integrity
c) redundancy
d) security
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.1: Discuss the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
22) Database systems minimize ________.
a) inconsistency
b) independence
c) integrity
d) security
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.1: Discuss the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
23) Database systems maximize ________.
a) inconsistency
b) independence
c) isolation
d) redundancy
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.1: Discuss the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
24) Databases ________ redundancy; this means ________.
a) maximize; the same data are stored in multiple locations
b) maximize; various copies of the data do not agree
c) minimize; the same data are stored in multiple locations
d) minimize; various copies of the data do not agree
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.1: Discuss the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
25) Databases ________ inconsistency; this means ________.
a) maximize; the same data are stored in multiple locations
b) maximize; various copies of the data do not agree
c) minimize; the same data are stored in multiple locations
d) minimize; various copies of the data do not agree
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.1: Discuss the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
26) Databases minimize _________; this means ________.
a) independence; applications cannot access data associated with other applications
b) independence; applications and data are not linked to each other, so all applications are able to access the same data
c) isolation; applications cannot access data associated with other applications
d) isolation; applications and data are not linked to each other, so all applications are able to access the same data
Difficulty: Medium
Section Reference 1: 5.2
Learning Objective 5.1: Discuss the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
27) Databases maximize _________; this means ________.
a) independence; applications cannot access data associated with other applications
b) independence; applications and data are not linked to each other, so all applications are able to access the same data
c) isolation; applications cannot access data associated with other applications
d) isolation; applications and data are not linked to each other, so all applications are able to access the same data
Difficulty: Medium
Section Reference 1: 5.2
Learning Objective 5.1: Discuss the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
28) Which of the following is an accurate representation of the data hierarchy from smallest to largest?
a) bit, byte, field, record, file, database
b) bit, byte, field, file, record, database
c) byte, bit, field, record, file, database
d) byte, bit, field, file, record, database
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
29) A ________ represents the smallest unit of data a computer can process.
a) bit
b) byte
c) field
d) file
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
30) A ________ is a group of eight ________.
a) bit; bytes
b) byte; bits
c) field; files
d) file; fields
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
31) A ________ is a group of ________.
a) bit; 4 bytes
b) bit; 8 bytes
c) byte; 4 bits
d) byte; 8 bits
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
32) A ________ is a single character.
a) bit
b) byte
c) field
d) file
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
33) A ________ is a logical grouping of characters into a word, a small group of words, or an identification number.
a) bit
b) byte
c) field
d) file
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
34) A ________ is a group of related fields.
a) bit
b) byte
c) character
d) record
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
35) A ________ is a data file.
a) bit
b) byte
c) record
d) table
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
36) Microsoft ________ is a popular example of a relational database.
a) Access
b) Excel
c) PowerPoint
d) Word
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
37) The relational database model is based on the concept of ________-dimensional tables.
a) one
b) two
c) three
d) four
Difficulty: Medium
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
38) Each relational database table contains records (listed in _______) and attributes (listed in ______) .
a) columns; columns
b) columns; rows
c) rows; columns
d) rows; rows
Difficulty: Medium
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
39) A ________ generally describes an entity.
a) byte
b) field
c) file
d) record
Difficulty: Hard
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
40) A(n) ________ of an entity refers to each row in a relational table, which is a specific, unique representation of the entity.
a) attribute
b) field
c) instance
d) record
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
41) Each characteristic or quality of a particular entity is called a(n) ________.
a) attribute
b) field
c) instance
d) record
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
42) The category “student” is a(n) ________.
a) attribute
b) database
c) entity
d) instance
Difficulty: Medium
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Application
Standard 1: AACSB || Technology
43) All the information about you in your university’s database is a(n) ________.
a) attribute
b) database
c) entity
d) instance
Difficulty: Medium
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Application
Standard 1: AACSB || Technology
44) Your name in your university’s database is a(n) ________.
a) attribute
b) database
c) entity
d) instance
Difficulty: Medium
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Application
Standard 1: AACSB || Technology
45) The ________ key is an identifier field that uniquely identifies a record.
a) alien
b) foreign
c) primary
d) secondary
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
46) The ________ key has some identifying information but does not identify the record with complete accuracy.
a) alien
b) foreign
c) primary
d) secondary
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
47) The ________ creates links between two tables.
a) alien
b) foreign
c) primary
d) secondary
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
48) Considering the following tables, ________ is a primary key.
Pizza Table | Restaurant Table | Order Table | ||||||||
PID | Name | Cost ($) | RID | Location | Opened | OID | RID | PID | ||
123 | Cheese | 6 | SEA | Seattle | 1995 | 1570 | SEA | 123 | ||
234 | Pepperoni | 7 | NYC | New York | 2000 | 1571 | SEA | 567 | ||
567 | Mushroom | 8 | CHI | Chicago | 2000 | 1572 | NYC | 567 | ||
a) Order Table: PID
b) Restaurant Table: Location
c) Pizza Table: Name
d) Pizza Table: PID
Difficulty: Medium
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Application
Standard 1: AACSB || Technology
49) Considering the following tables, ________ is a foreign key.
Pizza Table | Restaurant Table | Order Table | ||||||||
PID | Name | Cost ($) | RID | Location | Opened | OID | RID | PID | ||
123 | Cheese | 6 | SEA | Seattle | 1995 | 1570 | SEA | 123 | ||
234 | Pepperoni | 7 | NYC | New York | 2000 | 1571 | SEA | 567 | ||
567 | Mushroom | 8 | CHI | Chicago | 2000 | 1572 | NYC | 567 | ||
a) Order Table: PID
b) Restaurant Table: Location
c) Pizza Table: Name
d) Pizza Table: PID
Difficulty: Medium
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Application
Standard 1: AACSB || Technology
50) Industry experts estimate that ________ percent of data in an organization is unstructured.
a) 10–20
b) 40–50
c) 60–70
d) 80–90
Difficulty: Hard
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
51) Industry experts estimate that 80-90 percent of data in an organization is ________.
a) part-structured
b) semi-structured
c) structured
d) unstructured
Difficulty: Medium
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
52) Which of the following is TRUE?
a) Big Data becomes less useful over time since data changes too frequently for a system to maintain.
b) Big Data is so large and complex that it must be managed by using a traditional DBMS.
c) Big Data predictions come from teaching computers to think like humans.
d) Big Data systems perform well because they contain huge amounts of data on which to base their predictions.
Difficulty: Medium
Section Reference 1: 5.3
Learning Objective 5.3: Define Big Data and explain its basic characteristics.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
53) Which of the following is NOT a characteristic of Big Data?
a) Variety
b) Velocity
c) Viscous
d) Volume
Difficulty: Easy
Section Reference 1: 5.3
Learning Objective 5.3: Define Big Data and explain its basic characteristics.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
54) Which of the following is NOT a problem associated with Big Data?
a) Big Data can be structured, unstructured, or semi-structured.
b) Big Data can come from untrusted sources.
c) Big Data changes.
d) Big Data lacks quality.
Difficulty: Hard
Section Reference 1: 5.3
Learning Objective 5.3: Define Big Data and explain its basic characteristics.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
55) Big Data predictions ____ from teaching computers to think like humans and from applying ____ to huge quantities of data to infer probabilities.
a) come; mathematics
b) come; psychology
c) do not come; mathematics
d) do not come; psychology
Difficulty: Easy
Section Reference 1: 5.3
Learning Objective 5.3: Define Big Data and explain its basic characteristics.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
56) ______ is a type of traditional enterprise data.
a) equipment logs
b) ERP data
c) IoT data
d) microblogging
Difficulty: Easy
Section Reference 1: 5.3
Learning Objective 5.3: Define Big Data and explain its basic characteristics.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
57) ______ is a type of machine-generated data.
a) customer feedback
b) equipment logs
c) ERP data
d) microblogging
Difficulty: Easy
Section Reference 1: 5.3
Learning Objective 5.3: Define Big Data and explain its basic characteristics.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
58) ______ is a type of social data.
a) equipment logs
b) ERP data
c) IoT data
d) microblogging
Difficulty: Easy
Section Reference 1: 5.3
Learning Objective 5.3: Define Big Data and explain its basic characteristics.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
59) Big Data ______ and is considered _____.
a) can be from untrusted sources; clean
b) can be from untrusted sources; dirty
c) comes only from trusted sources; clean
d) comes only from trusted sources; dirty
Difficulty: Easy
Section Reference 1: 5.3
Learning Objective 5.3: Define Big Data and explain its basic characteristics.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
60) A data ________ is a repository of historical data that are organized by subject to support decision makers in the organization.
a) mart
b) shop
c) store
d) warehouse
Difficulty: Easy
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
61) A data ________ is a low-cost, scaled-down version of a data ________ that is designed for the end-user needs in an SBU or an individual department.
a) mart; store
b) mart; warehouse
c) warehouse; mart
d) warehouse; store
Difficulty: Easy
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
62) Data marts can be implemented ________ compared to data warehouses.
a) less quickly
b) more quickly
c) at the same pace
d) It depends on the situation.
Difficulty: Easy
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
63) Data marts can be implemented ________ quickly than data warehouses and support ________ control.
a) less; central
b) less; local
c) more; central
d) more; local
Difficulty: Easy
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
64) Data marts and data warehouses are organized by business ____ and typically use ____.
a) dimension; OLAP
b) dimension; OLTP
c) process; OLAP
d) process; OLTP
Difficulty: Easy
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
65) Data marts and data warehouses typically use ________.
a) ERP
b) OLAP
c) OLTP
d) RFID
Difficulty: Easy
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
66) Data marts and data warehouses are ____ and _____.
a) data silos; nonvolatile
b) data silos; volatile
c) integrated; nonvolatile
d) integrated; volatile
Difficulty: Easy
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
67) Data marts and data warehouses are ____ and _____.
a) real-time; nonvolatile
b) real-time; volatile
c) time variant; nonvolatile
d) time variant; volatile
Difficulty: Easy
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
68) Data marts and data warehouses are ________; this means they ________ be updated by users.
a) non-volatile; can
b) non-volatile; cannot
c) volatile; can
d) volatile; cannot
Difficulty: Easy
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
69) Data marts and data warehouses are ____ and use _____.
a) data silos; OLAP
b) data silos; OLTP
c) integrated; OLAP
d) integrated; OLTP
Difficulty: Easy
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
70) Data marts and data warehouses are ____ and use _____.
a) nonvolatile; OLAP
b) nonvolatile; OLTP
c) volatile; OLAP
d) volatile; OLTP
Difficulty: Easy
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
71) ________ is an example of a source system for a data warehouse.
a) DSS
b) ERP
c) OLAP
d) Web browser
Difficulty: Medium
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
72) ________ is way of integrating data.
a) EIS
b) ERP
c) ETL
d) RFID
Difficulty: Medium
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
73) ________ is a user of data warehouse output.
a) Data mining
b) ERP
c) ETL
d) External web documentation
Difficulty: Medium
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
74) _________ is data about data.
a) A data dictionary
b) A data schema
c) Megadata
d) Metadata
Difficulty: Easy
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
75) A database ____ defines the structure of both the database and the data contained in the database.
a) dictionary
b) entity
c) schema
d) tracker
Difficulty: Easy
Section Reference 1: IT’s About Business 5.2
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
76) Which of the following is TRUE of enterprise data warehouses?
a) They are flexible.
b) They cannot meet all business needs.
c) They specialize in handling sensor data.
d) They manage a broad variety of data.
Difficulty: Easy
Section Reference 1: IT’s About Business 5.2
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
77) Knowledge management is a process that helps organizations manipulate important knowledge that comprises part of the organization’s memory, usually in a(n) ________ format.
a) part-structured
b) semi-structured
c) structured
d) unstructured
Difficulty: Easy
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
78) Intellectual capital is another term for ________.
a) data
b) information
c) knowledge
d) wisdom
Difficulty: Easy
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
79) ________ is an intellectual asset.
a) Data
b) Information
c) Knowledge
d) Wisdom
Difficulty: Easy
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
80) ________ deals with more objective, rational, and technical knowledge.
a) Explicit information
b) Explicit knowledge
c) Tacit information
d) Tacit knowledge
Difficulty: Easy
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
81) ________ is the cumulative store of subjective or experiential learning.
a) Explicit information
b) Explicit knowledge
c) Tacit information
d) Tacit knowledge
Difficulty: Easy
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
82) Suppose you are a salesperson. You take great pride in knowing each customers’ favorite places to eat and their favorite meals. This is an example of ________.
a) explicit information
b) explicit knowledge
c) tacit information
d) tacit knowledge
Difficulty: Medium
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Application
Standard 1: AACSB || Technology
83) Suppose you work for XYZ Corporation. You know you can contribute 6% of your salary to a 401K and the company will match that 100% after 6 years of service because it is in the employee handbook. This is an example of ________.
a) explicit information
b) explicit knowledge
c) tacit information
d) tacit knowledge
Difficulty: Medium
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Application
Standard 1: AACSB || Technology
84) Which of the following is the correct order of the KMS cycle?
a) capture, create, refine, store, manage, disseminate
b) capture, create, refine, store, disseminate, manage
c) create, capture, refine, store, manage, disseminate
d) create, capture, refine, store, disseminate, manage
Difficulty: Easy
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
85) Laurie heads up a team creating a new process for the shipping department of her company. She worked with external consultants and wrote a process diagram. The team is now asking the VP of shipping to review the process diagram and give opinions. Laurie’s team is at the ________ knowledge stage of the KMS cycle.
a) capture
b) disseminate
c) refine
d) create
Difficulty: Medium
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Application
Standard 1: AACSB || Technology
86) Laurie heads up a team creating a new process for the shipping department of her company. She worked with external consultants and wrote a process diagram. After getting upper management’s opinions the team posted the new diagram to a corporate portal site. They are now demonstrating the new process to all shipping department employees. Laurie’s team is at the ________ knowledge stage of the KMS cycle.
a) capture
b) disseminate
c) refine
d) create
Difficulty: Medium
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Application
Standard 1: AACSB || Technology
87) ________ is the most popular query language used for interacting with a database.
a) ETL
b) RFID
c) SQL
d) TPS
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
88) Microsoft Access uses ________ to conduct queries.
a) ETL
b) QBE
c) RFID
d) TPS
Difficulty: Medium
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
89) The ________ provide(s) information on each attribute and why the attribute is needed in the database, who uses it, and how it should be updated.
a) business rules
b) cardinality
c) data dictionary
d) modality
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
90) ________ refers to the maximum number of times an instance of one entity can be associated with an instance in the related entity.
a) Business rules
b) Cardinality
c) Data dictionary
d) Modality
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
91) Two vertical lines represent the ________ cardinality symbol.
a) mandatory many
b) mandatory single
c) optional many
d) optional single
Difficulty: Medium
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
92) A circle with a vertical line represents the ________ cardinality symbol.
a) mandatory many
b) mandatory single
c) optional many
d) optional single
Difficulty: Medium
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
93) A vertical line with a “chicken leg” to the entity represents the ________ cardinality symbol.
a) mandatory many
b) mandatory single
c) optional many
d) optional single
Difficulty: Medium
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
94) A circle with a “chicken leg” to the entity represents the ________ cardinality symbol.
a) mandatory many
b) mandatory single
c) optional many
d) optional single
Difficulty: Medium
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
95) A ________ relationship exists when an association is maintained within a single entity.
a) binary
b) solitary
c) ternary
d) unary
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
95) A ________ relationship exists when two entities are associated.
a) binary
b) solitary
c) ternary
d) unary
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
96) A ________ relationship exists when three entities are associated.
a) binary
b) ternary
c) tertiary
d) unary
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
97) Normalization is a method for analyzing and reducing a relational database to its most streamlined form to ensure ________ redundancy, ________ data integrity, and optimal processing performance.
a) maximum; maximum
b) maximum; minimum
c) minimum; maximum
d) minimum; minimum
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
98) Functional dependencies are similar to ________ keys.
a) foreign
b) primary
c) secondary
d) useful
Difficulty: Hard
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Synthesis
Standard 1: AACSB || Technology
99) The Democratic Party’s new data repository uses _____.
a) Amazon’s Data Warehouse
b) Google’s Big Query
c) Symantec’s DataDown
d) Vertica’s Tracker
Difficulty: Easy
Section Reference 1: Closing Case
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
100) A super ____ is a type of independent committee that raises unlimited sums of money from corporations, unions, and/or individuals but is not permitted to contribute to or coordinate directly with parties or candidates.
a) BAC
b) FAC
c) PAC
d) SAC
Difficulty: Easy
Section Reference 1: Closing Case
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
101) The Democratic Party’s Data Warehouse required ____ skills.
a) NoPLE
b) QBE
c) RFID
d) SQL
Difficulty: Easy
Section Reference 1: Closing Case
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
Question type: True/False
102) Personal data are a type of genetic data.
Difficulty: Easy
Section Reference 1: Opening Case
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
103) Genetic data are one type of personal data.
Difficulty: Easy
Section Reference 1: Opening Case
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
104) Family Tree DNA uses an opt-in policy.
Difficulty: Easy
Section Reference 1: Opening Case
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Comprehension
Standard 1: AACSB || Technology
105) Genetic data collectors can help solve cold cases.
Difficulty: Easy
Section Reference 1: Opening Case
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Comprehension
Standard 1: AACSB || Technology
106) Enigma applies machine learning to Big Data to get people to click on things.
Difficulty: Easy
Section Reference 1: IT’s About Business 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
107) Enigma’s mission is to fundamentally change how businesses function by collecting data from diverse sources and modeling how the world operates with machine learning algorithms.
Difficulty: Easy
Section Reference 1: IT’s About Business 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
108) Enigma focuses on selling its services to for-profit organizations.
Difficulty: Easy
Section Reference 1: IT’s About Business 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Comprehension
Standard 1: AACSB || Technology
109) The amount of data is decreasing over time.
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
110) The amount of data is increasing exponentially over time.
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
111) Most organizations store their data in a central repository so that it is easy to find.
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
112) Data are scattered throughout organizations meaning they are stored in numerous servers and locations and are collected by many individuals using various methods and devices.
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
113) Data gets more current over time because most things remain largely unchanged such as business locations.
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
114) Data gets less current over time because customers move, employees leave, and companies expand.
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
115) Data rot means data changes over time.
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
116) Data rot refers primarily to problems with the media on which the data are stored.
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
117) The process of acquiring, keeping, and managing data is becoming easier.
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
118) Sarbanes-Oxley requires that private companies evaluate and disclose the effectiveness of their internal financial controls.
Difficulty: Hard
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
119) Sarbanes-Oxley requires that public companies evaluate and disclose the effectiveness of their internal operational controls.
Difficulty: Hard
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
120) Sarbanes-Oxley holds CIOs personally responsible for financial disclosures since they manage the systems that hold financial information.
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
121) Sarbanes-Oxley holds CEOs and CFOs personally responsible for financial disclosures.
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
122) Data governance is an approach to managing information across organizations.
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
123) Data governance is an approach to managing information across an entire organization.
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
124) Data governance is an approach to managing information across a functional area.
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
125) Master data provides a “single version of the truth”.
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
126) Master data are generated and captured by operational systems that describe the business’s activities.
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
127) Transactional data are generated and captured by operational systems that describe the business’s activities.
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
128) Database systems minimize redundancy, independence, and inconsistency.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
129) Database systems minimize redundancy, isolation, and inconsistency.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
130) Database systems maximize security, isolation, and integrity.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
131) Database systems maximize security, independence, and integrity.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
132) Data isolation means applications cannot access data associated with other applications.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
133) Data isolation occurs in FAISs.
Difficulty: Hard
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge, Synthesis
Standard 1: AACSB || Technology
134) Applications and data are isolated from one another in a database system meaning they are not linked to each other.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
135) Applications and data are independent from one another in a database system meaning they are not linked to each other.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
136) A byte is the smallest unit of data a computer can process.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
137) A bit is the smallest unit of data a computer can process.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
138) A relational database is basically one big table; it is also called a flat file.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
139) A relational database generally is not one big table that contains all of the records and attributes because that would entail far too much data redundancy.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
140) An entity of an instance refers to each row in a relational table which is a specific, unique representation of the instance.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
141) An instance of an entity refers to each row in a relational table which is a specific, unique representation of the entity.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
142) Each characteristic or quality of a particular attribute is called an entity.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
143) Each characteristic or quality of a particular entity is called an attribute.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
144) A foreign key is a primary key in another file.
Difficulty: Hard
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Application
Standard 1: AACSB || Technology
145) A secondary key can be a foreign key.
Difficulty: Medium
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
146) Unstructured data can reside in a traditional relational database.
Difficulty: Medium
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
147) Structured data reside in a traditional relational database.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
148) Big Data is a collection of data so large and complex that it is difficult to manage using traditional database management systems.
Difficulty: Easy
Section Reference 1: 5.3
Learning Objective 5.3: Define Big Data and explain its basic characteristics.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
149) Big Data is about predictions that come from teaching computers to think like humans.
Difficulty: Easy
Section Reference 1: 5.3
Learning Objective 5.3: Define Big Data and explain its basic characteristics.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
150) Big Data is about predictions that do not come from teaching computers to think like humans.
Difficulty: Easy
Section Reference 1: 5.3
Learning Objective 5.3: Define Big Data and explain its basic characteristics.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
151) Big Data systems perform well because they contain huge amounts of data on which to base their predictions.
Difficulty: Easy
Section Reference 1: 5.3
Learning Objective 5.3: Define Big Data and explain its basic characteristics.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
152) Big Data is so large and complex that it must be managed using a traditional DBMS.
Difficulty: Medium
Section Reference 1: 5.3
Learning Objective 5.3: Define Big Data and explain its basic characteristics.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
153) The term “Big Data” refers simply to huge amounts of data.
Difficulty: Easy
Section Reference 1: 5.3
Learning Objective 5.3: Define Big Data and explain its basic characteristics.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
154) Big Data is focused on unstructured data.
Difficulty: Easy
Section Reference 1: 5.3
Learning Objective 5.3: Define Big Data and explain its basic characteristics.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
155) Big Data includes structured, unstructured, and semistructured data.
Difficulty: Easy
Section Reference 1: 5.3
Learning Objective 5.3: Define Big Data and explain its basic characteristics.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
156) Social data and data from sensors comprise Big Data.
Difficulty: Easy
Section Reference 1: 5.3
Learning Objective 5.3: Define Big Data and explain its basic characteristics.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
157) Autonomous cars generate Big Data.
Difficulty: Easy
Section Reference 1: 5.3
Learning Objective 5.3: Define Big Data and explain its basic characteristics.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
158) Big Data has three characteristics: volume, voracity, and variety.
Difficulty: Easy
Section Reference 1: 5.3
Learning Objective 5.3: Define Big Data and explain its basic characteristics.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
159) Big Data has three characteristics: volume, velocity, and variety.
Difficulty: Easy
Section Reference 1: 5.3
Learning Objective 5.3: Define Big Data and explain its basic characteristics.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
160) Big Data generally comes from trusted sources.
Difficulty: Easy
Section Reference 1: 5.3
Learning Objective 5.3: Define Big Data and explain its basic characteristics.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
161) Big Data is generally fairly clean meaning it can be trusted as accurate and complete since there is so much data available.
Difficulty: Easy
Section Reference 1: 5.3
Learning Objective 5.3: Define Big Data and explain its basic characteristics.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
162) Organizations can use Big Data to conduct experiments.
Difficulty: Easy
Section Reference 1: 5.3
Learning Objective 5.3: Define Big Data and explain its basic characteristics.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
163) Organizations can use Big Data to microsegment customers.
Difficulty: Easy
Section Reference 1: 5.3
Learning Objective 5.3: Define Big Data and explain its basic characteristics.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
164) Organizations can use Big Data to create new business models.
Difficulty: Easy
Section Reference 1: 5.3
Learning Objective 5.3: Define Big Data and explain its basic characteristics.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
165) A data mart is a low-cost, scaled down version of a data warehouse.
Difficulty: Easy
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
166) A data warehouse is a low-cost, scaled down version of a data mart.
Difficulty: Easy
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
167) Data marts and data warehouses are typically organized by business dimension or subject.
Difficulty: Easy
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
168) Data marts and data warehouses use OLTP.
Difficulty: Easy
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
169) Data marts and data warehouses use OLAP.
Difficulty: Easy
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
170) Data warehouses are information silos.
Difficulty: Easy
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
171) Data warehouses are integrated.
Difficulty: Easy
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
172) Data warehouses are FAISs.
Difficulty: Hard
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Synthesis
Standard 1: AACSB || Technology
173) Data warehouses are TPSs.
Difficulty: Easy
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
174) Data marts and data warehouses maintain historical data.
Difficulty: Easy
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
175) Data marts and data warehouses are time variant.
Difficulty: Easy
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
176) Data warehouses and data marts are updated by users.
Difficulty: Easy
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
177) Data warehouses and data marts are volatile.
Difficulty: Easy
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
178) Data warehouses and data marts are nonvolatile.
Difficulty: Easy
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
179) Data warehouses and data marts cannot be updated by knowledge workers.
Difficulty: Hard
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Synthesis
Standard 1: AACSB || Technology
180) Data warehouses and data marts are multidimensional.
Difficulty: Easy
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
181) Big Data are data about data.
Difficulty: Easy
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
182) Metadata are data about data.
Difficulty: Easy
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
183) Data warehouses and data marts get data from source systems like point-of-sale systems.
Difficulty: Easy
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
184) Information producers have a primary role of creating information for information consumers.
Difficulty: Easy
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
185) Enterprise data warehouses are relatively inflexible and can answer only a limited number of questions.
Difficulty: Easy
Section Reference 1: IT’s About Business 5.2
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
186) Enterprise data warehouses are flexible and can answer many questions.
Difficulty: Easy
Section Reference 1: IT’s About Business 5.2
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
187) Enterprise data warehouses do not handle sensor data well.
Difficulty: Easy
Section Reference 1: IT’s About Business 5.2
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
188) Enterprise data warehouses are well-suited to handle Big Data.
Difficulty: Easy
Section Reference 1: IT’s About Business 5.2
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
189) Enterprise data warehouses are too rigid to be effective with Big Data.
Difficulty: Easy
Section Reference 1: IT’s About Business 5.2
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
190) Knowledge is distinct from data and information.
Difficulty: Easy
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
191) Information is knowledge that is contextual, relevant, and useful.
Difficulty: Easy
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
192) Knowledge is information in action.
Difficulty: Medium
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
193) Intellectual capital is another term for information.
Difficulty: Easy
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
194) Intellectual assets are another term for data.
Difficulty: Easy
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
195) Intellectual capital is another term for knowledge.
Difficulty: Easy
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
196) Intellectual assets are another term for knowledge.
Difficulty: Easy
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
197) Explicit knowledge deals with more objective, rational, and technical knowledge.
Difficulty: Easy
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
198) Implicit knowledge consists of the policies, procedural guides, reports, products, strategies, goals, core competencies, and IT infrastructure of the enterprise.
Difficulty: Easy
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
199) Explicit knowledge consists of the policies, procedural guides, reports, products, strategies, goals, core competencies, and IT infrastructure of the enterprise.
Difficulty: Easy
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
200) Tacit knowledge is easily codified.
Difficulty: Easy
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
201) Tacit knowledge the cumulative store of objective, experiential learning in the organization.
Difficulty: Easy
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
202) Tacit knowledge the cumulative store of subjective, experiential learning in the organization.
Difficulty: Easy
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
203) Trade secrets, skills sets, and expertise are explicit knowledge.
Difficulty: Easy
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
204) Trade secrets, skills sets, and expertise are tacit knowledge.
Difficulty: Easy
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
205) Tacit knowledge is more unstructured than explicit knowledge.
Difficulty: Medium
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
206) Suppose a salesperson knows each customer’s favorite pet name; this is explicit knowledge.
Difficulty: Medium
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Application
Standard 1: AACSB || Technology
207) Suppose a salesperson knows each customer’s favorite pet name; this is tacit knowledge.
Difficulty: Medium
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Application
Standard 1: AACSB || Technology
208) KMS are useful for creating best practices in an organization.
Difficulty: Easy
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
209) Organizations may need to reward employees to get them to add their expertise to a KMS.
Difficulty: Easy
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
210) Once a KMS is set-up, it is updated automatically by Big Data the organization collects.
Difficulty: Easy
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
211) Learning about and adjusting to your organization’s culture increases your explicit knowledge.
Difficulty: Easy
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
212) The most popular query language for interacting with a database is NoSQL.
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
213) The most popular query language for interacting with a database is SQL.
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
214) The most popular query language for interacting with a database is QBL.
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
215) QBE is a GUI form of SQL.
Difficulty: Hard
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Synthesis
Standard 1: AACSB || Technology
216) Microsoft Access uses QBE.
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
217) The MIS department creates the business rules necessary to develop an ER diagram.
Difficulty: Medium
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
218) Business users create the business rules necessary to develop an ER diagram.
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
219) Data dictionaries provide information on each attribute and why the attribute is needed in the database.
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
220) A circle for cardinality represents a single relationship.
Difficulty: Medium
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
221) A “chicken leg” for cardinality represents a “many” relationship.
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
222) The join operation combines records from two or more tables in a database to obtain information in different tables.
Difficulty: Medium
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
223) Normalization ensures a properly structured relational database.
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
224) There are four normal forms in the normalization process.
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
225) There are three normal forms in the normalization process.
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
226) In the first normal form of the normalization process, there are repeating groups, data redundancy, and lack of integrity.
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
227) A flat file is in the second normal form of the normalization process.
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
228) A flat file is in the first normal form of the normalization process.
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
229) The second normal form of the normalization process has some smaller tables and does not allow partial functional dependences.
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
230) In the fourth normal form of the normalization process, non-key attributes are not allowed to define other non-key attributes.
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
231) In the third normal form of the normalization process, non-key attributes are not allowed to define other non-key attributes.
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
232) The third normal form of the normalization process is completely free of data redundancy.
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
233) The third normal form of the normalization process all foreign keys appear where needed to link related tables.
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
234) The first normal form of the normalization process is completely free of data redundancy.
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
235) The first normal form of the normalization process all foreign keys appear where needed to link related tables.
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
236) Blueprint helps campaigns and state parties to access vote data to better target their campaign efforts.
Difficulty: Easy
Section Reference 1: Closing Case
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
Question Type: Text Entry
237) A(n) ___________ is a collection of data held by one group that is note easily accessible by other groups.
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
238) ___ are those data that visitors and customers produce when they visit a website and click on hyperlinks.
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
239) ___ is an approach to managing information across an entire organization.
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
240) Data governance is an approach to managing information across _____________.
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
241) ___ is a process that spans all organizational business processes and applications.
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
242) ___ are a set of core data that span the enterprise’s information systems.
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
243) ___________________ are generated and captured by operational systems and describe the business’s activities.
Difficulty: Easy
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
244) A(n) ___ is a collection of logically related records.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
245) A data file is a collection of logically related ___.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 1: Discuss the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
236) Data ______ means applications cannot access data associated with other applications.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
237) Data ______ means applications and data are not linked to each other so that all applications are able to access the same data.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
238) A byte is a group of ___ bits.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
239) A(n) _______represents a single character.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
240) A logical grouping of characters into a word, a small group of words, or an identification number is called a(n) _____________.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
241) A(n) ________ is a group of logically related fields.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
242) A(n) ___ is a set of programs that provide users with tools to create and manage a database.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
243) The ________________________ model is based on the concept of two-dimensional tables.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
244) The relational database model is based on the concept of _____-dimensional tables.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
245) A(n) ______________ is a diagram that represents entities in the database and their relationships.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
246) A(n) _____________ is a person, place, thing, or event about which an organization maintains information.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
247) A(n) __________ of an entity relates to each row in a relational table which is a specific, unique representation of the entity.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
248) Each characteristics of quality of a particular entity is called a(n) _______.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
249) The ________________________ key uniquely identifies a record.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
250) The ________________________ key has some identifying information but not identify the record with complete accuracy.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
251) The ________________________ key uniquely identifies a row of another table.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
252) ________________ data is highly organized in fixed fields in a data repository such as a relational database.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
253) ________________ data are data that do not reside in a traditional relational database.
Difficulty: Easy
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
254) ______________ is a collection of data that is so large and complex that it is difficult to manage using traditional database management systems.
Difficulty: Easy
Section Reference 1: 5.3
Learning Objective 5.3: Define Big Data and explain its basic characteristics.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
255) The three distinct characteristics of Big Data are ___.
Difficulty: Medium
Section Reference 1: 5.3
Learning Objective 5.3: Define Big Data and explain its basic characteristics.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
256) _______________ data refers to inaccurate, incomplete, incorrect, duplicate, or erroneous data.
Difficulty: Medium
Section Reference 1: 5.3
Learning Objective 5.3: Define Big Data and explain its basic characteristics.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
257) A data ___ is a repository of historical data that are organized by subject to support decision makers in the organization.
Difficulty: Easy
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
258) A data ___ is a low-cost, scaled-down version of a data ___.
Answer 1: mart
Answer 2: warehouse
Difficulty: Medium
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
259) Data warehouses and data marts use online _____________ processing.
Difficulty: Easy
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
260) Data warehouses and data marts are ______ meaning that users cannot change or update the data.
Difficulty: Easy
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
261) _____________ are data about data in a repository.
Difficulty: Easy
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
262) ___ is a process that helps organizations manipulate important knowledge that comprises part of the organization’s memory, usually in an unstructured format.
Difficulty: Easy
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
263) ___ knowledge deals with more objective, rational, and technical knowledge.
Difficulty: Easy
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
264) ___ knowledge is generally imprecise and costly to transfer.
Difficulty: Medium
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
265) _________________________ refer to the use of modern IT to systematize, enhance, and expedite knowledge management both within one form and among multiple firms.
Difficulty: Easy
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
266) _____________ are the most effective and efficient ways of accomplishing business processes that are readily available to a wide range of employees.
Difficulty: Easy
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
267) ___ is the most popular query language used for interacting with a database.
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
268) ______________________ are precise descriptions of policies, procedures, or principles in any organization that stores and uses data to generate information.
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
269) _______________________ provide information on each attribute and why the attribute is needed in the database.
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
270) __________________ illustrate an association between entitites.
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
271) ________________ refers to the maximum number of times an instance of one entity can be associated with an instance in the related entity.
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
272) ___ is a method of analyzing and reducing a relational database to its most streamlined form to ensure minimum redundancy, maximum data integrity, and optimal processing performance.
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
273) __________________________ are a means of expressing that the value of one particular attribute is associated with a specific single value of another attribute.
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
274) In the _____________ normal form, non-key attributes are not allowed to define other non-key attributes.
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
275) The _________ operation combines records from two or more tables in a database to obtain information that is located in different tables.
Difficulty: Easy
Section Reference 1: Appendix
Learning Objective 5.6: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.
Bloomcode: Knowledge
Standard 1: AACSB || Technology
Question type: Essay
276) List and describe the eight issues that make managing data so difficult. Discuss how your university may struggle with each issue. Now evaluate how a business like Amazon may struggle with each issue.
Difficulty: Hard
Section Reference 1: 5.1
Learning Objective 5.1: Discuss ways that common challenges in managing data can be addressed using data governance.
Bloomcode: Evaluation
Standard 1 : AACSB || Communication
Standard 2 : AACSB || Analytic
Standard 3 : AACSB || Technology
Standard 4 : AACSB || Reflective Thinking
Solution: Amount of data increasing – more new students every year, more employees, need to keep all the data on students (transcripts) , etc.; hopefully new customers placing new orders
Data are scattered – lots of different systems (class management, payment, hospital, registration, etc.) ; Amazon has to deal with different suppliers – maybe third party inventory systems aren’t as up-to-date (so customers may get an “out of stock” message after they place an order when inventory was available at the time of the order)
Data are generated from multiple sources
o Internal – grades, paychecks, etc.; Amazon’s corporate databases or documents
o Personal – Facebook, memes, etc.; Amazon’s employees have opinions and customers can write reviews
o External – government reports (if public), university website, etc.; other websites referencing Amazon
Constant development of new sources of data and need to manage this new data and data changes over time – employees moving, students moving (in-state vs. out-of-state), etc.; customers moving, etc.
Data rot – storing data in less than ideal places (lots of paper for most universities); same for Amazon
Data security, quality, integrity – protecting social security numbers, grades; protecting customer credit card information
Federal regulation – FERPA, HIPAA; SOX
Too much unstructured data (Big Data) – social media, sensors (IoT and surveillance) causes problems for both of these
277) Draw a simple relational database (at least two tables with at least three columns and three rows). Label the data hierarchy (except the bit). Label the primary, secondary, and foreign keys.
Difficulty: Medium
Section Reference 1: 5.2
Learning Objective 5.2: Identify and assess the advantages and disadvantages of relational databases.
Bloomcode: Comprehension, Application
Standard 1 : AACSB || Communication
Standard 2 : AACSB || Technology
Standard 3 : AACSB || Reflective Thinking
Solution:
Student Table Professor Table Class Table
SID | Name | Expected Graduation Year | PID | Name | Tenure Year | ID | Name | PID | ||
123 | Smith | 2017 | ABC | Jones | 1995 | MGT101 | Intro to Management | ABC | ||
234 | Jones | 2018 | DEF | Brilliant | 2000 | BUS101 | Intro to Business | ABC | ||
567 | Barilla | 2018 | GHI | Genius | 2000 | MGT201 | Intermediate Management | GHI |
Byte = any single character (e.g., “1” from Student Table)
Field = any cell
Record = any row
File = any table
Database = all three tables
Primary = SID, PID, or ID (respectively in each table)
Secondary = any column except those listed under primary
Foreign = PID in the Class Table
278) List and describe the three characteristics of Big Data. Should your university address Big Data? Why or why not? Describe at least one business (not your university if you answered “yes” to the previous questions) that deals with Big Data. Explain why you chose that business.
Difficulty: Medium
Section Reference 1: 5.3
Learning Objective 5.3: Define Big Data and explain its basic characteristics.
Bloomcode: Analysis
Standard 1 : AACSB || Communication
Standard 2 : AACSB || Analytic
Standard 3 : AACSB || Technology
Solution: 1) Volume – lots of data
2) Velocity – data flowing into organization rapidly increasing
3) Variety – can get structured, unstructured, or semi-structured data (most is unstructured) and changes rapidly (except for the structured)
Most students will have to say yes because everyone has to deal with social media and what students or other people say on social media; students are also under constant surveillance by video cameras, sensors on their phones, etc.
A student could pick just about any business because social media and surveillance impacts everyone
279) List and describe the six basic characteristics of data warehouses and data marts and how these characteristics differ from transactional systems.
Difficulty: Medium
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Comprehension
Bloomcode: Synthesis
Bloomcode: Analysis
Standard 1 : AACSB || Communication
Standard 2 : AACSB || Technology
Solution: organized by business dimension or subject (customer, vendor, product, price level, and region) rather than by business process for a transactional system (order entry, inventory control, accounts receivable)
Use online analytical processing (OLAP) which involves the analysis of accumulated data by end users rather than online transaction processing (OLTP) for transactional systems
Integrated from multiple system to create a comprehensive view of the customer rather than data that comes from a single system for a single transaction in the transactional system
Time variant means the data is historical rather than real-time for transactional systems
Nonvolatile means users cannot change or update the data rather than transactional systems where the users can change or update data in case customers want more products, different products, or to return products
280) Consider the data warehouse framework. Describe a source system and the main problem associated with these systems. What options do organizations have for storing data; which one is most effective? What is metadata? Why is data quality so important? What are the two categories of users?
Difficulty: Easy
Section Reference 1: 5.4
Learning Objective 5.4: Explain the elements necessary to successfully implement and maintain data warehouses.
Bloomcode: Comprehension
Standard 1 : AACSB || Communication
Standard 2 : AACSB || Technology
Solution: Source system = POS, ERP, legacy, OLTP, external web documents (any place where collect data to feed into the data warehouse); main problem = data quality
Storing = one central data warehouse, independent data marts, or hub and spoke (central warehouse that pushes to data marts); data marts are NOT effective because they create information silos and have data quality problems
Metadata = data about data
Quality = users won’t trust the data and won’t use it
Users = information producers (create information) and information consumers (use information)
281) What are the benefits and drawbacks of KMSs? Suppose you are a salesperson; would you want to use a KMS? Why or why not?
Difficulty: Medium
Section Reference 1: 5.5
Learning Objective 5.5: Describe the benefits and challenges of implementing knowledge management systems in organizations.
Bloomcode: Comprehension, Synthesis
Standard 1 : AACSB || Communication
Standard 2 : AACSB || Analytic
Standard 3 : AACSB || Technology
Solution: Benefits = create most effective and efficient way of doing something, improves overall organizational performance, improved customer service, more efficient product development, improved employee morale and retention
Drawbacks = people have to be willing to share personal, tacit knowledge; must keep it up to date; must be willing to invest resources (time and money to put in the system and update it)
Salesperson = students should discuss the benefits and drawbacks of sharing tacit knowledge = may be hard to codify what you know (some things may simply be instinct; other things like how to shake hands with that person or if they prefer a bow to a certain height or a kiss on a particular cheek); other things someone may not want to share because they will be afraid to get replaced by another human or a computer