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

Which of the following is a source of internal data?

Which of the following is true of a database?

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

____ is information in its original form.

List the responsibilities of a database administrator (DBA).