Deck 5: Data and Knowledge Management

Question 1

Jana is a mobile startup designed to ________.

A)charge users less money to use mobile data than they have to pay their telecommunication company
B)give app developers free access to other apps
C)offer free smartphones to people who make less than 20 cents an hour in China
D)reward users with data in exchange for collecting their personal information when sampling apps

Answer 1

D

Question 2

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

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

Answer 2

D

Question 3

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.

Answer 3

D

Question 4

Database systems minimize ________.

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

Question 5

Database systems maximize ________.

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

Question 6

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

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

Question 7

Jana maintains it ________ a zero-rating system because ________.

A)is; users can use their free data any way they like
B)is; users don't understand the internet and how open it can be
C)is not; users can use their free data any way they like
D)is not; users don't understand the internet and how open it can be

Question 8

Database systems minimize ________.

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

Question 9

Under __________'s rules,marijuana growers must put a ________ on each plant so it can be recorded and monitored by the state's enforcement system.

A)California; barcode
B)California; microchip
C)Colorado; barcode
D)Colorado; microchip

Question 10

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

Question 11

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 12

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 13

________ 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 14

Colorado uses ________ to track marijuana.

A)ERP
B)QR codes
C)RFID
D)TPS

Question 15

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 16

________ 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 17

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 18

The rapid increase in the number of new smartphones in developing countries ________ been accompanied by a corresponding increase in mobile marketing because ________.

A)has; companies see the benefits of advertising this way
B)has; wireless data are fairly inexpensive
C)has not; companies do not see the benefits of advertising this way
D)has not; wireless data are still too expensive

Question 19

________ 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 20

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 21

A ________ generally describes an entity.

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

Question 22

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

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

Question 23

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

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

Question 24

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

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

Question 25

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 26

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

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

Question 27

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

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

Question 28

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 29

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

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

Question 30

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 31

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 32

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

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

Question 33

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 34

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 35

Microsoft ________ is a popular example of a relational database.

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

Question 36

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 37

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

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

Question 38

A ________ is a group of eight ________.

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

Question 39

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

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

Question 40

The ________ creates links between two tables.

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

Question 41

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

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

Question 42

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 43

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 44

________ are/is an example of open data from the Ebola fight in Africa.

A)Census data
B)Social media
C)Text messages
D)Voice calls

Question 45

A data ________ stores vast amounts of data in their original format until they are required,rather than forcing the integration of large volumes of data before analysis.

A)lake
B)ocean
C)river
D)stream

Question 46

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 47

Data marts and data warehouses typically use ________.

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

Question 48

________ is an intellectual asset.

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

Question 49

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

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

Question 50

Africa collaborated with ________ to stop the Ebola virus outbreak in 2013 and 2014.

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

Question 51

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

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

Question 52

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 53

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 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.

Question 55

________ is the cumulative store of subjective or experiential learning.

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

Question 56

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 57

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 58

Intellectual capital is another term for ________.

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

Question 59

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 60

TrueCar adopted ________ because it had to handle ________.

A)a traditional DBMS; only structured car data
B)a traditional DBMS; structured and unstructured data
C)Hadoop; only structured car data
D)Hadoop; structured and unstructured data

Question 61

A ________ relationship exists when two entities are associated.

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

Question 62

________ makes it difficult for oncology data to be shared across oncology practices.

A)FERPA
B)HIPAA
C)RFID
D)SOX

Question 63

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

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

Question 64

Performance Bicycle used a(n)________ system to increase its sales.

A)ETL
B)KMS
C)OLTP
D)SQL

Question 65

Two vertical lines represent the ________ cardinality symbol.

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

Question 66

Performance Bicycle uses employee knowledge to help customers find products and relevant multimedia content about them.This is an example of ________ knowledge in the KMS cycle.

A)disseminating
B)managing
C)refining
D)storing

Question 67

A ________ relationship exists when three entities are associated.

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

Question 68

________ 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 69

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

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

Question 70

California was the first state to legalize the recreational use of marijuana and has an extensive IT solution for managing the production and distribution of the plant.

Question 71

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 72

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 73

Microsoft Access uses ________ to conduct queries.

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

Question 74

Functional dependencies are similar to ________ keys.

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

Question 75

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 76

More than ________ percent of US medical records remain in hard-copy format.

A)25
B)50
C)75
D)95

Question 77

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 78

Most oncology data is ________ and ________.

A)structured; codified
B)structured; uncodified
C)unstructured; codified
D)unstructured; uncodified

Question 79

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

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

Question 80

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