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.

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

IBM

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

OLAP

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

SQL

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

Tacit knowledge

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

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

explicit knowledge

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

instance

Databases ________ inconsistency; this means ________. maximize; various copies of the data do not agree maximize; the same data are stored in multiple locations minimize; various copies of the data do not agree 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; minimum minimum; minimum maximum; maximum minimum; maximum

minimum; maximum

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

more quickly

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

optional many

A ________ generally describes an entity. byte record file field

record

Database systems minimize ________. security integrity redundancy independence

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 charge users less money to use mobile data than they have to pay their telecommunication company offer free smartphones to people who make less than 20 cents an hour in China

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 structured unstructured

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. unstructured semi-structured part-structured structured

unstructured

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

Cardinality

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 Class Table: PID Student Table: Expected Graduation Year Student Table: ID

Student Table: ID