Question 1

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

Accepted Answer

The answer of Identify and describe three basic operations used...

Question 2

DBMS for midrange computers include all of the following EXCEPT

Accepted Answer

A)  DB2. 
B)  Oracle. 
C)  Microsoft SQL Server. 
D)  Microsoft Access.

Question 3

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

Accepted Answer

The answer of List and describe three main capabilities or...

Question 4

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

Accepted Answer

The answer of In data mining, the technique of ________...

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A)  primary key. 
B)  key field. 
C)  primary field. 
D)  unique ID.

Question 8

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

Accepted Answer

A)  normalization. 
B)  data scrubbing. 
C)  data cleansing. 
D)  data defining.

Question 9

The logical view

Accepted Answer

A)  shows how data are organized and structured on the storage media. 
B)  presents an entry screen to the user. 
C)  allows the creation of supplementary reports. 
D)  presents data as they would be perceived by end users.

Question 10

Duplicate data in multiple data files is called data ________.

Accepted Answer

A)  redundancy 
B)  repetition 
C)  independence 
D)  partitions

Question 11

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

Accepted Answer

A)  data dictionary. 
B)  data definition diagram. 
C)  entity-relationship diagram. 
D)  relationship dictionary.

Question 12

Oracle Database Lite is a(n)

Accepted Answer

A)  DBMS for small handheld computing devices. 
B)  Internet DBMS. 
C)  mainframe relational DBMS. 
D)  DBMS for midrange computers.

Question 13

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?

Accepted Answer

A)  address 
B)  city 
C)  airport code 
D)  state

Question 14

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.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A)  hierarchical DBMS. 
B)  relational DBMS. 
C)  network DBMS. 
D)  object-oriented DBMS.

Question 17

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.

Accepted Answer

A) True 
 B)False

Question 18

The select operation

Accepted Answer

A)  combines relational tables to provide the user with more information than is otherwise available. 
B)  creates a subset consisting of columns in a table. 
C)  identifies the table from which the columns will be selected. 
D)  creates a subset consisting of all records in the file that meet stated criteria.

Question 19

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

Accepted Answer

A)  library card catalog 
B)  cash register receipt 
C)  doctor's office invoice 
D)  list of sales totals on a spreadsheet

Question 20

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

Accepted Answer

The answer of A(n) ________ view shows data as it...

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.