FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: Data and Business Intelligence

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Essay

Review LaterAdd Note

Review Later

Describe how records are accessed in a random access file structure.

Correct Answer

verified

Answers will vary. In a random access fi...

View Answer

Show Answer

Question 42

Essay

Review LaterAdd Note

Review Later

Briefly discuss the advantages and disadvantages of database marketing.

Correct Answer

verified

Answers will vary. Database marketing of...

View Answer

Show Answer

Question 43

True/False

Review LaterAdd Note

Disks are sequential access devices, whereas tapes are random access devices.

Although a database can consist of only a single file, it is usually a group of files.

In the context of data warehouses, briefly explain extraction, transformation, and loading (ETL).

A _____ acts as an interface to a database, retrieving data for users and allowing users to enter data in the database.

_____ analysis  is used to discover patterns and relationships.

Describe the features and benefits of an object-oriented database.

In object-oriented databases, grouping objects along with their attributes and methods into a class is called _____ .

There are, to date, many legal requirements for protecting privacy while using big data analytics.

A select operation pares down a table in a relational database by eliminating columns according to certain criteria.

Briefly explain a relational model.

The data _____ component of a database management system (DBMS) is used for tasks such as backup and recovery, security, and change management.

_____ , used in object-oriented databases, refers to new objects being created faster and more easily by entering new data in attributes.

In the context of how information is viewed in a database, the _____ involves how data is stored on and retrieved from storage media.

Data warehouses are sometimes called hypercubes because they _____.

In the context of segmentation of customers in database marketing, _____ is a variable that includes gender, age, income, and marital status.

In the context of database marketing, when a buyer is segmented on the basis of variable psychographics, it explains _____.

To begin designing a relational database, you must define the _____ by defining each table and the fields in it.

In contrast to data in a database, data in a data warehouse is described as subject oriented, which means that it _____.