FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: Database Systems, Data Warehouses, and Data Marts

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

True/False

Review LaterAdd Note

Review Later

Data in a database is used for analytical purposes, whereas data in a data warehouse is used for capturing and managing transactions.

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

In the context of the input component of a data warehouse, _____ collect, integrate, and process data that can be used by all functional areas in an organization.

A) online analytical processing systems
B) online transaction management systems
C) enterprise resource planning systems
D) data mining analysis systems

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

The variety dimension of big data refers to the combination of _____.

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

Data warehouses are sometimes called hypercubes because they _____.

Which of the following components of a data model describes methods and calculations that can be performed on data, such as updating and querying data?

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

A database engine converts logical requests from users into their physical equivalents by interacting with other components of the database management system (DBMS).

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

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

Which of the following approaches to set up a distributed database management system (DDBMS) combines the fragmentation approach and the replication approach?

In a relational database model, a(n) _____ searches data in a table and retrieves records based on certain criteria.

In contrast to the query languages used to interact with a relational database, interaction with an object-oriented database takes places via methods, which are called by sending a message to an object.

When using query by example (QBE) in the data manipulation component of a database management system (DBMS) , the _____ is used when all the conditions in the QBE form must be met.

In a(n) __________, records in files are organized and processed in numerical order.

The use of the OR operator in a query form, when using query by example (QBE), means that only one of the conditions must be met.

Labor and population statistics are examples of sources for internal data that are accessed by a database.

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

The _____ component of a database management system (DBMS) is used to add, delete, modify, and retrieve records from a database.

Which of the following statements is true of a database?