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

For each database, there:

In the context of how information is viewed in a database, the _____ involves how data is stored on and retrieved from storage media.

In a relational database model, a(n) _____ pares down a table by eliminating columns according to certain criteria.

To begin designing a relational database, you must define the _____ by defining each table and the fields in it.

Which of the following file structures is similar to a book index that lists page numbers where certain topics can be found?

_____ can be described as using an organization's database of customers and potential customers in order to promote products or services that an organization offers.

In a relational database, every record must be uniquely identified by a__________.

__________is used to discover patterns and relationships.

With the indexed sequential access method (ISAM), records cannot be accessed randomly.

Which of the following is a key factor that has contributed to the growth and popularity of big data?

The__________of a database involves how information appears to users and how it can be organized and retrieved.

In the context of segmentation of customers in database marketing,__________is a variable that includes gender, age, income, and marital status.

A database administrator (DBA) is responsible for _____.

Static Web sites are useful for e-commerce sites that need frequent updates.

Business intelligence (BI) uses scorecards and dashboards to support decision-making activities, whereas business analytics (BA) uses data mining tools and predictive modeling.

Which of the following components of a database management system (DBMS) is responsible for data storage, manipulation, and retrieval?

The _____ method for accessing files is effective when a large number of records are processed less frequently, perhaps on a quarterly or yearly basis.

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

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

__________tools are capable of "drilling up," proceeding from the smallest unit of data to higher levels.