Exam 6: Databases and Information Management

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

Up until about five years ago,most data collected by organizations consisted of transaction data that could easily fit into rows and columns of relational database management systems.

(True/False)
4.8/5
(32)

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

(Multiple Choice)
4.7/5
(38)

A data mart is a database that stores current and historical data of potential interest to decision makers throughout the company.

(True/False)
4.9/5
(44)

High-speed ________ use both relational and non-relational tools to analyze large datasets.

(Short Answer)
4.8/5
(23)

List at least three conditions that contribute to data redundancy and inconsistency.

(Essay)
4.9/5
(46)

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

(Multiple Choice)
4.7/5
(31)

You work for a national car rental agency and want to determine what characteristics are shared among your most loyal customers.To do this,you will want to use data mining software that is capable of

(Multiple Choice)
4.8/5
(40)

All of the following are technologies used to analyze and manage big data except

(Multiple Choice)
4.8/5
(44)

OLAP enables users to obtain online answers to ad-hoc questions in a fairly rapid amount of time,except when the data are stored in very large databases.

(True/False)
4.7/5
(32)

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?

(Multiple Choice)
4.9/5
(42)

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

(Essay)
4.8/5
(38)

The most popular type of DBMS today for PCs as well as for larger computers and mainframes is the rational DBMS.

(True/False)
4.8/5
(38)

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

(Short Answer)
4.8/5
(37)

OLAP is a tool for enabling

(Multiple Choice)
4.7/5
(37)

In a relational database,a record is referred to in technical terms as a(n)

(Multiple Choice)
4.9/5
(27)

Information is _______________ when it is useful and appropriate for the types of work and decisions that require it.

(Short Answer)
4.7/5
(44)

Databases record information about general categories of information referred to as ________.

(Short Answer)
4.8/5
(42)

A ________________________ is a database that stores current and historical data of potential interest to decision makers throughout the company.

(Multiple Choice)
4.7/5
(41)

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

(Essay)
4.7/5
(35)

A data warehouse may be updated by a legacy system.

(True/False)
4.8/5
(36)
Showing 61 - 80 of 115
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)