Exam 6: Foundations of Business Intelligence: Databases and Information Management

Identify and describe three basic operations used to extract useful sets of data from a relational database.

DBMS for midrange computers include all of the following EXCEPT

List and describe three main capabilities or tools of a DBMS.

In data mining, the technique of ________ uses a series of existing values to predict what other values will be.

Every record in a file should contain at least one key field.

A data dictionary is a language associated with a database management system that end users and programmers use to manipulate data in the database.

A field identified in a record as holding the unique identifier for that record is called the

The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called

The logical view

Duplicate data in multiple data files is called data ________.

An automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security is the

Oracle Database Lite is a(n)

You are creating a database to store temperature and wind data from national airport locations. Which of the following fields is the most likely candidate to use as the basis for a primary key in the Airport table?

Program-data dependence refers to the coupling of data stored in files and software programs that use this data such that changes in programs require changes to the data.

Data administration is a special organizational function that manages the policies and procedures through which data can be managed as an organizational resource.

The type of database management approach that can handle multimedia is the

In a Web-based database, middleware is used to transfer information from the organization's internal database back to the Web server for delivery in the form of a Web page to the user.

The select operation

Which of the following non-digital data storage items is most similar to a database?

A(n) ________ view shows data as it is actually organized and structured on the data storage media.