CIS110 - Chapter 5 Data and Knowledge Management Quiz

Microsoft ________ is a popular example of a relational database.

Access

________ is an intellectual asset.

Knowledge

Google's Cloud Spanner is a globally distributed ________ database that ________.

NewSQL; synchronizes time

NewSQL is a class of modern relational database management system that attempts to provide the same scalable performance of ________ systems for ________.

NoSQL; OLTP

Considering the following tables, ________ is a primary key.

Student Table ID Primary Key: one field in a database that is uniquely identifies that record so it can be retrieved, updated, and sorted. (like student ID numbers, or Social Security numbers, etc.)

T/F - Knowledge is information in action.

True

Which of the following is TRUE? a) Big Data systems perform well because they contain huge amounts of data on which to base their predictions. 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 becomes less useful over time since data changes too frequently for a system to maintain.

a) Big Data systems perform well because they contain huge amounts of data on which to base their predictions.

Each bicycle in the 2018 Tour de France produced a total of more than 3 ________ data points during the course of the race.

billion

A ________ is a group of eight ________.

byte; bits

Which of the following is the correct order of the KMS cycle?

create, capture, refine, store, manage, disseminate

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

d) big data can be structured, unstructured, or semi-structured

T/F - Unstructured data can reside in a traditional relational database.

false

T/F - While late-model cars often utilize any number of technologies to make the driving experience more enjoyable and safer for drivers, there has yet to be a car that is completely autonomous.

false

t/f - A circle for cardinality represents a single relationship.

false

t/f - Data marts and data warehouses use OLTP.

false

Database systems maximize ________.

independence

A(n) ________ of an entity refers to each row in a relational table, which is a specific, unique representation of the entity.

instance

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.

mart; warehouse

A circle with a "chicken leg" to the entity represents the ________ cardinality symbol.

optional many

Data from a ________ was used to arrest and prosecute Ross Compton.

pacemaker

Database systems minimize ________.

redundancy, inconsistency

Each relational database table contains records (listed in ________) and attributes (listed in ________).

rows; columns

T/F - As we incorporate more and more technology into myriad aspects of daily life, so too are we presented with a whole new set of legal questions that must be answered.

true

T/F - Before Spanner, one of the major problems that Google encountered with respect to consistency among databases was that of keeping time without constant, intense communication.

true

T/F - Knowledge is distinct from data and information.

true

T/F - Organizations can use Big Data to microsegment customers.

true

T/F - Tacit knowledge is more unstructured than explicit knowledge.

true

t/f - Data warehouses and data marts are multidimensional.

true