FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: Database Systems and Big Data

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

True/False

Review LaterAdd Note

Review Later

Organizations can collect many types of data from a wide variety of sources, but typically they only collect structured data that fits neatly into traditional relational database management systems.

A) True
B) False

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

Starting from monthly sales data, if you wish to get weekly sales data, use the ___ feature.

A) roll up
B) drill down
C) slice and dice
D) extract data

E) C) and D)
F) A) and D)

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

Suppose a manager wishes to analyze historical trends in sales. He would use the online transaction processing (OLTP) system.

Today, most organizations use the traditional approach to data management, where multiple information systems share a pool of related data.

The _____ model has become the most popular database model.

An enterprise data model is created only for documentation, but is otherwise inconsequential.

A database administrator (DBA) is an important nontechnical position responsible for defining and implementing consistent principles for a variety of data issues, including setting data standards and data definitions that apply across all the databases in an organization.

A(n) _____ is a field or set of fields that uniquely identify a record.

A(n) ______ is an individual responsible for defining and implementing consistent principles for a variety of data issues.

In the context of the relational database model, projecting involves eliminating columns in a table.

A database management system (DBMS) serves as an interface between an application program and a database.

Kyle works for National Sporting Goods, where he manages critical data elements, such as identifying and acquiring new data sources, creating consistent reference data, and analyzing data for quality. Kyle is a _______.

mySQL is a popular ____________.

Some of the key factors in database design are content, access, structure, archiving, and security.

For the ____ operation, it is required that the the two tables have a common attribute.

A collection of data fields that are all related to one object, activity, or individual is called a file.

_____ is the process of detecting and then correcting or deleting incomplete, incorrect, inaccurate, irrelevant records that reside in a database.

Suppose you wish to find what tables are in a database, what fields they have, and how they are related you would review the _____.

_____ is the term used to describe enormous and complex data collections that traditional data management software, hardware, and analysis processes are incapable of handling.

In the context of the relational database model, selecting involves combining two or more tables.