Question 1

Microsoft SQL Server is a(n)

Accepted Answer

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

Question 2

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. 
A) hierarchical DBMS. 
B) relational DBMS. 
C) network DBMS. 
D) object-oriented DBMS.

Question 3

A group of related fields,such as a student's name,the course taken,date,and grade,comprises a file.

Accepted Answer

A) True 
 B)False

Question 4

An alternative to using application server software for interfacing between a Web server and back-end databases is

Accepted Answer

A) CGI. 
B) HTML. 
C) Java. 
D) SQL. 
A) CGI. 
B) HTML. 
C) Java. 
D) SQL.

Question 5

The tool that enables users to view the same data in different ways using multiple dimensions is

Accepted Answer

A) predictive analysis. 
B) SQL. 
C) OLAP. 
D) data mining. 
A) predictive analysis. 
B) SQL. 
C) OLAP. 
D) data mining.

Question 6

In terms of data relationships,associations refers to

Accepted Answer

A) events linked over time. 
B) patterns that describe a group to which an item belongs. 
C) occurrences linked to a single event. 
D) undiscovered groupings. 
A) events linked over time. 
B) patterns that describe a group to which an item belongs. 
C) occurrences linked to a single event. 
D) undiscovered groupings.

Question 7

A DBMS reduces data redundancy and inconsistency by

Accepted Answer

A) enforcing referential integrity. 
B) uncoupling program and data. 
C) utilizing a data dictionary. 
D) minimizing isolated files with repeated data. 
A) enforcing referential integrity. 
B) uncoupling program and data. 
C) utilizing a data dictionary. 
D) minimizing isolated files with repeated data.

Question 8

Every table in a relational database has one field designated as it key field.

Accepted Answer

A) True 
 B)False

Question 9

A characteristic or quality describing an entity is called a(n)

Accepted Answer

A) field. 
B) tuple. 
C) key field. 
D) attribute. 
A) field. 
B) tuple. 
C) key field. 
D) attribute.

Question 10

A ________ is a field in a record that uniquely identifies instances of that record so that it can be retrieved,updated,or sorted.

Accepted Answer

The answer of A ________ is a field in a...

Question 11

In ________,events are linked over time.We might find,for example,that if a house is purchased,a new refrigerator will be purchased within two weeks 65 percent of the time,and an oven will be bought within one month of the home purchase 45 percent of the time.

Accepted Answer

A) sequences 
B) clustering 
C) classification 
D) associations 
A) sequences 
B) clustering 
C) classification 
D) associations

Question 12

Which common database challenge is illustrated by the text's discussion of receiving multiple pieces of the same direct mail advertising?

Accepted Answer

A) data normalization 
B) data accuracy 
C) data redundancy 
D) data inconsistency 
A) data normalization 
B) data accuracy 
C) data redundancy 
D) data inconsistency

Question 13

The project 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) organizes elements into segments. 
D) identifies the table from which the columns will be selected. 
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) organizes elements into segments. 
D) identifies the table from which the columns will be selected.

Question 14

A group of records of the same type is called a ________.

Accepted Answer

A) bit 
B) field 
C) record 
D) file 
A) bit 
B) field 
C) record 
D) file

Question 15

OLAP is a tool for enabling

Accepted Answer

A) users to obtain online answers to ad hoc questions in a rapid amount of time. 
B) users to view both logical and physical views of data. 
C) programmers to quickly diagram data relationships. 
D) programmers to normalize data. 
A) users to obtain online answers to ad hoc questions in a rapid amount of time. 
B) users to view both logical and physical views of data. 
C) programmers to quickly diagram data relationships. 
D) programmers to normalize data.

Question 16

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. 
A) normalization. 
B) data scrubbing. 
C) data cleansing. 
D) data defining.

Question 17

Gord Smith works for a large pizza chain.Every week he gets reports on the sales in each store across Canada.He sees a problem in one of the stores in Ontario.He wants and ad hoc report for sales at that store after 9 p.m.on weekdays.He is told that no such report can be created by the traditional file system.This is an example of ________.

Accepted Answer

A) program-data dependence 
B) lack of flexibility 
C) poor security 
D) lack of data sharing and availability 
A) program-data dependence 
B) lack of flexibility 
C) poor security 
D) lack of data sharing and availability

Question 18

OLAP is a key tool of BI.

Accepted Answer

A) True 
 B)False

Question 19

A DBMS reduces data redundancy and inconsistency by maximizing isolated files in which the same data are repeated.

Accepted Answer

A) True 
 B)False

Question 20

How organizations store,organize,and manage their data has a tremendous impact on organizational effectiveness.

Accepted Answer

A) True 
 B)False

Microsoft SQL Server is a(n)

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

A group of related fields,such as a student's name,the course taken,date,and grade,comprises a file.

An alternative to using application server software for interfacing between a Web server and back-end databases is

The tool that enables users to view the same data in different ways using multiple dimensions is

In terms of data relationships,associations refers to

A DBMS reduces data redundancy and inconsistency by

Every table in a relational database has one field designated as it key field.

A characteristic or quality describing an entity is called a(n)

A ________ is a field in a record that uniquely identifies instances of that record so that it can be retrieved,updated,or sorted.

In ________,events are linked over time.We might find,for example,that if a house is purchased,a new refrigerator will be purchased within two weeks 65 percent of the time,and an oven will be bought within one month of the home purchase 45 percent of the time.

Which common database challenge is illustrated by the text's discussion of receiving multiple pieces of the same direct mail advertising?

The project operation

A group of records of the same type is called a ________.

OLAP is a tool for enabling

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

OLAP is a key tool of BI.

A DBMS reduces data redundancy and inconsistency by maximizing isolated files in which the same data are repeated.

How organizations store,organize,and manage their data has a tremendous impact on organizational effectiveness.

Information Systems in Global Business Today

How Businesses Use Information Systems

Information Systems, organizations, and Strategy

Social, ethical, and Legal Issues in Information Systems

It Infrastructure and Emerging Technologies

Telecommunications, the Internet, and Wireless Technology

Securing Information Systems

Enterprise Applications to Manage Supply Chains and Respond to Customers

E-Commerce: Digital Markets and Digital Goods

Managing Knowledge

Enhancing Decision Making

Developing Information Systems

Project Management, business Value, and Managing Change

Managing Global Systems

Filters

Exam 6: Databases and Information Management

Microsoft SQL Server is a(n)

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

A group of related fields,such as a student's name,the course taken,date,and grade,comprises a file.

An alternative to using application server software for interfacing between a Web server and back-end databases is

The tool that enables users to view the same data in different ways using multiple dimensions is

In terms of data relationships,associations refers to

A DBMS reduces data redundancy and inconsistency by

Every table in a relational database has one field designated as it key field.

A characteristic or quality describing an entity is called a(n)

A ________ is a field in a record that uniquely identifies instances of that record so that it can be retrieved,updated,or sorted.

In ________,events are linked over time.We might find,for example,that if a house is purchased,a new refrigerator will be purchased within two weeks 65 percent of the time,and an oven will be bought within one month of the home purchase 45 percent of the time.

Which common database challenge is illustrated by the text's discussion of receiving multiple pieces of the same direct mail advertising?

The project operation

A group of records of the same type is called a ________.

OLAP is a tool for enabling

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

OLAP is a key tool of BI.

A DBMS reduces data redundancy and inconsistency by maximizing isolated files in which the same data are repeated.

How organizations store,organize,and manage their data has a tremendous impact on organizational effectiveness.

Information Systems in Global Business Today

How Businesses Use Information Systems

Information Systems, organizations, and Strategy

Social, ethical, and Legal Issues in Information Systems

It Infrastructure and Emerging Technologies

Telecommunications, the Internet, and Wireless Technology

Securing Information Systems

Enterprise Applications to Manage Supply Chains and Respond to Customers

E-Commerce: Digital Markets and Digital Goods

Managing Knowledge

Enhancing Decision Making

Developing Information Systems

Project Management, business Value, and Managing Change

Managing Global Systems

Filters