Chapter 5

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

Big Data lacks quality.

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

Cardinality

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

IBM

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

OLAP

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

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

Student Table: ID

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

Tacit knowledge

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

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

explicit knowledge

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

instance

Databases ________ inconsistency; this means ________. 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 maximize; various copies of the data do not agree

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

minimum; maximum

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

more quickly

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

optional single

A ________ generally describes an entity. record file byte field

record

Database systems minimize ________. integrity independence security redundancy

redundancy

Jana is a mobile startup designed to ________. 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 give app developers free access to other apps

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

rot

Industry experts estimate that 80-90 percent of data in an organization is ________. part-structured semi-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. semi-structured unstructured structured part-structured

unstructured