Ch. 5
Data marts and data warehouses typically use ________. A. OLTP B. OLAP C. ERP D. RFID
B. OLAP
A ________ is a group of eight ________. A. field; files B. bit; bytes C. byte; bits D. file; fields
C. byte; bits
Databases ________ inconsistency; this means ________. A. maximize; various copies of the data do not agree B. maximize; the same data are stored in multiple locations C. minimize; various copies of the data do not agree D. minimize; the same data are stored in multiple locations
C. minimize; various copies of the data do not agree
Data marts can be implemented ________ compared to data warehouses. A. less quickly B. It depends on the situation. C. more quickly D. at the same pace
C. more quickly
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
C. optional many
________ is the cumulative store of subjective or experiential learning. A. Explicit information B. Tacit information C. Explicit knowledge D. Tacit knowledge
D. Tacit knowledge
________ refers to the maximum number of times an instance of one entity can be associated with an instance in the related entity. A. Cardinality B. Modality C. Business rules D. Data dictionary
A. Cardinality
Africa collaborated with ________ to stop the Ebola virus outbreak in 2013 and 2014. A. IBM B. Amazon C. Google D. Microsoft
A. IBM
Jana is a mobile startup designed to ________. A. reward users with data in exchange for collecting their personal information when sampling apps B. give app developers free access to other apps C. charge users less money to use mobile data than they have to pay their telecommunication company D. offer free smartphones to people who make less than 20 cents an hour in China
A. reward users with data in exchange for collecting their personal information when sampling apps
Industry experts estimate that 80-90 percent of data in an organization is ________. A. unstructured B. structured C. part-structured D. semi-structured
A. unstructured
Which of the following is NOT a problem associated with Big Data? A. Big Data changes. B. Big Data can be structured, unstructured, or semi-structured. C. Big Data can come from untrusted sources. D. Big Data lacks quality.
B. Big Data can be structured, unstructured, or semi-structured.
________ is the most popular query language used for interacting with a database. A. TPS B. SQL C. RFID D. ETL
B. SQL
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. tacit knowledge B. explicit knowledge C. tacit information D. explicit information
B. explicit knowledge
All the information about you in your university's database is a(n) ________. A. entity B. instance C. database D. attribute
B. instance
Database systems minimize ________. A. integrity B. redundancy C. security D. independence
B. redundancy
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. semi-structured B. structured C. unstructured D. part-structured
C. unstructured
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. minimum; minimum C. maximum; minimum D. minimum; maximum
D. minimum; maximum
A ________ generally describes an entity. A. byte B. file C. field D. record
D. record
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. scattering B. clickstreaming C. degradation D. rot
D. rot