Deck 5: Data and Knowledge Management

Question 1

Database systems minimize ________.

A) independence
B) integrity
C) redundancy
D) security

Answer 1

C

Question 2

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

Answer 2

C

Question 3

IHS Automotive estimates that the average connected car will produce up to 30 _____ of data each day.

A) KB
B) GB
C) TB
D) MB

Answer 3

C

Question 4

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.

Question 5

________ is an approach to managing information across an entire organization.

A) Big data
B) Data governance
C) Master data
D) Master data management

Question 6

Data ________ refers primarily to problems with the media on which the data are stored.

A) clickstreaming
B) degradation
C) scattering
D) rot

Question 7

Database systems minimize ________.

A) inconsistency
B) independence
C) integrity
D) security

Question 8

Database systems maximize ________.

A) inconsistency
B) independence
C) isolation
D) redundancy

Question 9

________ is a process that spans all organizational business processes and applications.

A) Big data
B) Data governance
C) Master data
D) Master data management

Question 10

We leave valuable trails of data behind when we use tracking and recording devices called data ________.

A) debris
B) exhaust
C) markers
D) roads

Question 11

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

Question 12

Data from a(n) _____ was used to arrest and prosecute Ross Compton.

A) criminal database
B) license plate reader
C) pacemaker
D) video camera

Question 13

A connected vehicle is equipped with Internet access and usually with a wireless ________.

A) LAN
B) MAN
C) PAN
D) WAN

Question 14

Which of the following companies is NOT developing cars and self-driving technology/services?

A) Amazon
B) Apple
C) Google
D) IBM

Question 15

________ 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

Question 16

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

Question 17

________ 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

Question 18

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

Question 19

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

Question 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

Question 21

All the information about you in your university's database is a(n) ________.

A) attribute
B) database
C) entity
D) instance

Question 22

A ________ is a group of eight ________.

A) bit; bytes
B) byte; bits
C) field; files
D) file; fields

Question 23

Microsoft ________ is a popular example of a relational database.

A) Access
B) Excel
C) PowerPoint
D) Word

Question 24

Each relational database table contains records (listed in _______) and attributes (listed in ______) .

A) columns; columns
B) columns; rows
C) rows; columns
D) rows; rows

Question 25

Industry experts estimate that ________ percent of data in an organization is unstructured.

A) 10-20
B) 40-50
C) 60-70
D) 80-90

Question 26

The ________ key has some identifying information but does not identify the record with complete accuracy.

A) alien
B) foreign
C) primary
D) secondary

Question 27

Each characteristic or quality of a particular entity is called a(n) ________.

A) attribute
B) field
C) instance
D) record

Question 28

Considering the following tables, ________ is a foreign key.

A) Class Table: PID
B) Professor Table: Name
C) Student Table: Expected Graduation Year
D) Student Table: ID

Question 29

Your name in your university's database is a(n) ________.

A) attribute
B) database
C) entity
D) instance

Question 30

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

Question 31

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.

Question 32

A ________ represents the smallest unit of data a computer can process.

A) bit
B) byte
C) field
D) file

Question 33

The ________ key is an identifier field that uniquely identifies a record.

A) alien
B) foreign
C) primary
D) secondary

Question 34

Considering the following tables, ________ is a primary key.

A) Class Table: PID
B) Professor Table: Name
C) Student Table: Expected Graduation Year
D) Student Table: ID

Question 35

The ________ creates links between two tables.

A) alien
B) foreign
C) primary
D) secondary

Question 36

The relational database model is based on the concept of ________-dimensional tables.

A) one
B) two
C) three
D) four

Question 37

Industry experts estimate that 80-90 percent of data in an organization is ________.

A) part-structured
B) semi-structured
C) structured
D) unstructured

Question 38

The category "student" is a(n) ________.

A) attribute
B) database
C) entity
D) instance

Question 39

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

Question 40

A ________ generally describes an entity.

A) byte
B) field
C) file
D) record

Question 41

________ deals with more objective, rational, and technical knowledge.

A) Explicit information
B) Explicit knowledge
C) Tacit information
D) Tacit knowledge

Question 42

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

Question 43

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.

Question 44

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

Question 45

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.

Question 46

________ is the cumulative store of subjective or experiential learning.

A) Explicit information
B) Explicit knowledge
C) Tacit information
D) Tacit knowledge

Question 47

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

Question 48

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

Question 49

NewSQL is a class of modern relational database management system that attempts to provide the same scalable performance of ___ systems for ___.

A) NoSQL; OLAP
B) NoSQL; OLTP
C) SQL; OLAP
D) SQL; OLTP

Question 50

Intellectual capital is another term for ________.

A) data
B) information
C) knowledge
D) wisdom

Question 51

Google's Cloud Spanner is a globally distributed ___ database that ____.

A) NewSQL; synchronizes time
B) NewSQL; tracks users
C) SQL; synchronizes time
D) SQL; tracks users

Question 52

A data _______ is a central repository that stores all of an organization's data, regardless of their source or format.

A) exhaust
B) lake
C) pond
D) trail

Question 53

Data marts can be implemented ________ quickly than data warehouses and support ________ control.

A) less; central
B) less; local
C) more; central
D) more; local

Question 54

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

Question 55

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

Question 56

________ is an example of a source system for a data warehouse.

A) DSS
B) ERP
C) OLAP
D) Web browser

Question 57

_______ have been the primary mechanism in many organizations for performing analytics, reporting, and operations. However, they are too rigid to be effective with Big Data.

A) CRMs
B) EDWs
C) ETLs
D) SCMs

Question 58

Data marts and data warehouses typically use ________.

A) ERP
B) OLAP
C) OLTP
D) RFID

Question 59

________ is an intellectual asset.

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

Question 60

Which of the following is NOT a characteristic of Big Data?

A) Variety
B) Velocity
C) Viscous
D) Volume

Question 61

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

Question 62

The 2018 Tour de France bicycles transmitted data over a ___ network.

A) data
B) mesh
C) personal area
D) satellite

Question 63

________ is the most popular query language used for interacting with a database.

A) ETL
B) RFID
C) SQL
D) TPS

Question 64

A circle with a vertical line represents the ________ cardinality symbol.

A) mandatory many
B) mandatory single
C) optional many
D) optional single

Question 65

Which of the following technologies was NOT deployed in the 2018 Tour de France bicycles?

A) Augmented reality
B) GPS
C) RFID
D) Rechargeable battery

Question 66

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

Question 67

Two vertical lines represent the ________ cardinality symbol.

A) mandatory many
B) mandatory single
C) optional many
D) optional single

Question 68

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

Question 69

A ________ relationship exists when three entities are associated.

A) binary
B) ternary
C) tertiary
D) unary

Question 70

A ________ relationship exists when an association is maintained within a single entity.

A) binary
B) solitary
C) ternary
D) unary

Question 71

Microsoft Access uses ________ to conduct queries.

A) ETL
B) QBE
C) RFID
D) TPS

Question 72

A ________ relationship exists when two entities are associated.

A) binary
B) solitary
C) ternary
D) unary

Question 73

Each bicycle in the 2018 Tour de France produced a total of more than 3 ____ data points during the course of the race.

A) thousand
B) million
C) billion
D) trillion

Question 74

________ 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

Question 75

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

Question 76

Law enforcement agencies can use devices in the Internet of Things category to arrest and prosecute criminals.

Question 77

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

Question 78

Functional dependencies are similar to ________ keys.

A) foreign
B) primary
C) secondary
D) useful

Question 79

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

Question 80

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