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

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.

Describe the fragmentation approach to setting up a distributed database management system.

Data redundancy is eliminated or minimized in a flat file system.

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

Describe how data stored in a relational model is retrieved from tables.

A(n) _____ operation pares down a table by eliminating columns according to certain criteria.

The _____ view of a database involves how information appears to users and how it can be organized and retrieved.

An e-commerce site that needs frequent updates would benefit from the use of a static Web site.

Data in a data warehouse can be differentiated from data in a database in that the former _____.

List the responsibilities of a database administrator (DBA).

Describe how files are accessed in a random access file structure.

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

Which of the following factors has made big data analytics accessible to nearly all types of organizations?

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

In a data warehouse,_____ means collecting data from a variety of sources and converting it into a format that can be used in transformation processing.

The _____ view of a database involves how data is stored on and retrieved from storage media.

Which of the following is a source of internal data?

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

_____ analysis is used to discover patterns and relationships.

What are the areas in the retail industry that can benefit from big data?