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 51

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 52

Multiple Choice

Review LaterAdd Note

Review Later

The ____ approach to setting up a distributed DBMS addresses how tables are divided among multiple locations.

A) normalization
B) encapsulation
C) fragmentation
D) replication

E) C) and D)
F) All of the above

Correct Answer

verified

Show Answer

Question 53

Multiple Choice

Review LaterAdd Note

Which of the following is true of a database?

A(n)____________________ is usually a smaller version of a data warehouse,used by a single department or function.

List the responsibilities of a database administrator (DBA).

The indexed sequential access method (ISAM)is slow and becomes increasingly useful as the number of records becomes larger.

A ____ operation searches data in a table and retrieves records based on certain criteria.

A ____ operation pares down a table by eliminating columns according to certain criteria.

The sequential access file structure method is effective when a large number of records are processed less frequently,perhaps on a quarterly or yearly basis.

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

Which of the following is a source of internal data?

What are the advantages of a data mart over a data warehouse?

A database ____ is responsible for data storage,manipulation,and retrieval.

With the ____________________ distributed DBMS approach,each site stores a copy of the data in the organization's database.

____ is information in its original form.

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

____ improves database efficiency by eliminating redundant data and ensuring that only related data is stored in a table.

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

The data ____ component is used to create and maintain the data dictionary.

One advantage a database has over a flat file system is that more information can be generated from the same data.