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

Multiple Choice

Review LaterAdd Note

Review Later

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

A) hierarchical model
B) network model
C) relational model
D) object-based model

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

Which of the following statements is true of a database?

A) It allows more than one program to use the same data.
B) It comprises data that cannot be linked.
C) It consists of a segregated set of files.
D) It is a crucial tool for managing overseas subsidiaries.

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

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

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

Data warehouses are sometimes called hypercubes because they _____.

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.

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

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

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

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.

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

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?

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

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

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

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.

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

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.

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

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