CH 5

Which of the following is NOT a problem associated with Big Data? Big Data lacks quality. Big Data can come from untrusted sources. Big Data can be structured, unstructured, or semi-structured. Big Data changes.

Big Data can be structured, unstructured, or semi-structured.

________ refers to the maximum number of times an instance of one entity can be associated with an instance in the related entity. Modality Business rules Data dictionary Cardinality

Cardinality

Africa collaborated with ________ to stop the Ebola virus outbreak in 2013 and 2014. Microsoft IBM Amazon Google

IBM

Data marts and data warehouses typically use ________. ERP OLAP OLTP RFID

OLAP

________ is the most popular query language used for interacting with a database. RFID ETL TPS SQL

SQL

Considering the following tables, ________ is a primary key. Student Table SID Name Expected Graduation 123 Smith 2017 234 Jones 2018 567 Barilla 2018 Professor Table PID Name Tenure Year ABC Jones 1995 DEF Brilliant 2000 GHI Genius 2000 Class Table ID Name PID MGT101 Intro to Management ABC BUS101 Intro to Business ABC MGT201 Intermediate Management GHI Professor Table: Name Student Table: ID Student Table: Expected Graduation Year Class Table: PID

Student Table: ID

________ is the cumulative store of subjective or experiential learning. Tacit information Explicit information Explicit knowledge Tacit knowledge

Tacit knowledge

A ________ is a group of eight ________. file; fields bit; bytes field; files byte; bits

byte; bits

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 ________. tacit information explicit information explicit knowledge tacit knowledge

explicit knowledge

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

instance

Databases ________ inconsistency; this means ________. maximize; various copies of the data do not agree minimize; various copies of the data do not agree maximize; the same data are stored in multiple locations minimize; the same data are stored in multiple locations

minimize; various copies of the data do not agree

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. maximum; maximum minimum; minimum minimum; maximum maximum; minimum

minimum; maximum

Data marts can be implemented ________ compared to data warehouses. It depends on the situation. at the same pace less quickly more quickly

more quickly

A circle with a "chicken leg" to the entity represents the ________ cardinality symbol. optional many optional single mandatory single mandatory many

optional many

A ________ generally describes an entity. field record file byte

record

Database systems minimize ________. independence integrity security redundancy

redundancy

Jana is a mobile startup designed to ________. give app developers free access to other apps reward users with data in exchange for collecting their personal information when sampling apps offer free smartphones to people who make less than 20 cents an hour in China charge users less money to use mobile data than they have to pay their telecommunication company

reward users with data in exchange for collecting their personal information when sampling apps

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 ________. clickstreaming degradation rot scattering

rot

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

unstructured

Knowledge management is a process that helps organizations manipulate important knowledge that comprises part of the organization's memory, usually in a(n) ________ format. semi-structured part-structured unstructured structured

unstructured