Exam 3: Database Systems, Data Warehouses and Data Marts

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

In the context of segmentation of customers in database marketing, _____is used to discover patterns and relationships.is a variable that includes gender, age, income, and marital status. ​

(Multiple Choice)
4.8/5
(39)

Which of the following components of a database management system (DBMS) is used to design elements of an application using a database, such as data entry screens, interactive menus, and interfaces with other programming languages?

(Multiple Choice)
4.8/5
(30)

List and describe the features of data in a data warehouse in contrast to data in a database.

(Essay)
4.7/5
(37)

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

(Multiple Choice)
4.9/5
(31)

In a relational database model, a _____ is a field in a relational table that matches the primary key column of another table.

(Multiple Choice)
4.7/5
(28)

Which of the following statements is true of big data?

(Multiple Choice)
4.8/5
(25)

The _____of a database involves how information appears to users and how it can be organized and retrieved. ​

(Multiple Choice)
4.9/5
(34)

Discuss some examples of sources for external data.

(Essay)
4.9/5
(41)

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

(Multiple Choice)
4.8/5
(43)

A _____ is a collection of data from a variety of sources used to support decision-making applications and generate business intelligence.

(Multiple Choice)
4.9/5
(32)

In data warehouses, _____ is information about data-its content, quality, condition, origin, and other characteristics.

(Multiple Choice)
4.8/5
(43)

_____is used to discover patterns and relationships. ​

(Multiple Choice)
4.8/5
(45)

Briefly explain a relational model.

(Essay)
4.8/5
(41)

The _____ component of a database management system (DBMS) is used to create and maintain the data dictionary.

(Multiple Choice)
4.8/5
(32)

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

(Multiple Choice)
4.9/5
(37)

A _____ is usually a smaller version of a data warehouse, used by a single department or function.

(Multiple Choice)
4.9/5
(34)

Which of the following components of a database management system (DBMS) is responsible for data storage, manipulation, and retrieval?

(Multiple Choice)
4.8/5
(29)

In the context of the types of data in a database, which of the following is a source of internal data?

(Multiple Choice)
4.9/5
(37)

Describe the tasks performed in the first normal form (1NF) stage of normalization to improve database efficiency.

(Essay)
4.7/5
(36)

In a(n) _____, nodes with the same parents are called twins or siblings.

(Multiple Choice)
4.7/5
(38)
Showing 61 - 80 of 105
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)