Question 1

Labor and population statistics are sources of internal data that are accessed by a database.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

The _____ of a data model defines the boundaries of a database,such as maximum and minimum values allowed for a field.

Accepted Answer

A)  data structure 
B)  operations 
C)  integrity rules 
D)  file structure 
A)  data structure 
B)  operations 
C)  integrity rules 
D)  file structure

Question 4

A database administrator is responsible for developing recovery procedures in case data is lost or corrupted.

Accepted Answer

A) True 
 B)False

Question 5

In a relational model,when a primary key for one table appears in another table,it is called a _____ key.

Accepted Answer

A)  secondary 
B)  foreign 
C)  surrogate 
D)  domain 
A)  secondary 
B)  foreign 
C)  surrogate 
D)  domain

Question 6

The advantage of _____ is that both sequential and random access can be used,depending on the situation and the user's needs.

Accepted Answer

indexed se

Question 7

Data in a database is used for analytical purposes,whereas data in a data warehouse is used for capturing and managing transactions.

Accepted Answer

A) True 
 B)False

Question 8

In a(n) _____ file structure,records can be accessed in any order,regardless of their physical location in storage media.

Accepted Answer

The answer of In a(n) _____ file structure,records can be...

Question 9

Explain the transformation processes used in data warehouses.

Accepted Answer

The tasks of transformation processing i

Question 10

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

Accepted Answer

A)  physical structure 
B)  logical structure 
C)  primary key 
D)  foreign key 
A)  physical structure 
B)  logical structure 
C)  primary key 
D)  foreign key

Question 11

Which of the following is a source of external data?

Accepted Answer

A)  Tax records 
B)  Sales records 
C)  Transaction records 
D)  Personnel records 
A)  Tax records 
B)  Sales records 
C)  Transaction records 
D)  Personnel records

Question 12

In contrast to the query languages used to interact with a relational database,interaction with an object-oriented database takes places via methods.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following statements is true of data marts and data warehouses?

Accepted Answer

A)  Consolidating information from different departments is easier in data marts than in data warehouses. 
B)  Data marts have more extended scope than data warehouses. 
C)  Access to data is often slower in data marts than in data warehouses. 
D)  Despite being smaller, data marts can usually perform the same type of analysis as data warehouses. 
A)  Consolidating information from different departments is easier in data marts than in data warehouses. 
B)  Data marts have more extended scope than data warehouses. 
C)  Access to data is often slower in data marts than in data warehouses. 
D)  Despite being smaller, data marts can usually perform the same type of analysis as data warehouses.

Question 14

In well-designed data-driven Web sites,changes are made to the HTML code every time a Web site's data content changes.

Accepted Answer

A) True 
 B)False

Question 15

What is a data-driven Web site?

Accepted Answer

A data-driven Web site acts as

Question 16

Which of the following data sources provides the input a data warehouse needs to perform analyses and generate reports?

Accepted Answer

A)  Online analytical processing 
B)  Online transaction processing 
C)  Enterprise resource planning systems 
D)  Data mining analysis 
A)  Online analytical processing 
B)  Online transaction processing 
C)  Enterprise resource planning systems 
D)  Data mining analysis

Question 17

For each database,there can be more than one physical view of data.

Accepted Answer

A) True 
 B)False

Question 18

Describe the tasks performed in the first normal form (1NF) stage of normalization.

Accepted Answer

The following three tasks are performed

Question 19

In large organizations,database design and management is handled by the _____.

Accepted Answer

database a

Question 20

The _____ component of a database management system (DBMS) is used for tasks such as backup and recovery,security,and change management.

Accepted Answer

A)  data manipulation 
B)  application generation 
C)  data definition 
D)  data administration 
A)  data manipulation 
B)  application generation 
C)  data definition 
D)  data administration

Labor and population statistics are sources of internal data that are accessed by a database.

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

The _____ of a data model defines the boundaries of a database,such as maximum and minimum values allowed for a field.

A database administrator is responsible for developing recovery procedures in case data is lost or corrupted.

In a relational model,when a primary key for one table appears in another table,it is called a _____ key.

The advantage of _____ is that both sequential and random access can be used,depending on the situation and the user's needs.

Data in a database is used for analytical purposes,whereas data in a data warehouse is used for capturing and managing transactions.

In a(n) _____ file structure,records can be accessed in any order,regardless of their physical location in storage media.

Explain the transformation processes used in data warehouses.

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

Which of the following is a source of external data?

In contrast to the query languages used to interact with a relational database,interaction with an object-oriented database takes places via methods.

Which of the following statements is true of data marts and data warehouses?

In well-designed data-driven Web sites,changes are made to the HTML code every time a Web site's data content changes.

What is a data-driven Web site?

Which of the following data sources provides the input a data warehouse needs to perform analyses and generate reports?

For each database,there can be more than one physical view of data.

Describe the tasks performed in the first normal form (1NF) stage of normalization.

In large organizations,database design and management is handled by the _____.

The _____ component of a database management system (DBMS) is used for tasks such as backup and recovery,security,and change management.

Information Systems: an Overview

Computers: the Machines Behind Computing

Personal,legal,ethical,and Organizational Issues of Information Systems

Protecting Information Resources

Data Communication: Delivering Information Anywhere and Anytime

The Internet,intranets,and Extranets

E-Commerce

Global Information Systems

Building Successful Information Systems

Enterprise Systems

Management Support Systems

Intelligent Information Systems

Emerging Trends,technologies,and Applications

Filters

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

Labor and population statistics are sources of internal data that are accessed by a database.

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

The _____ of a data model defines the boundaries of a database,such as maximum and minimum values allowed for a field.

A database administrator is responsible for developing recovery procedures in case data is lost or corrupted.

In a relational model,when a primary key for one table appears in another table,it is called a _____ key.

The advantage of _____ is that both sequential and random access can be used,depending on the situation and the user's needs.

Data in a database is used for analytical purposes,whereas data in a data warehouse is used for capturing and managing transactions.

In a(n) _____ file structure,records can be accessed in any order,regardless of their physical location in storage media.

Explain the transformation processes used in data warehouses.

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

Which of the following is a source of external data?

In contrast to the query languages used to interact with a relational database,interaction with an object-oriented database takes places via methods.

Which of the following statements is true of data marts and data warehouses?

In well-designed data-driven Web sites,changes are made to the HTML code every time a Web site's data content changes.

What is a data-driven Web site?

Which of the following data sources provides the input a data warehouse needs to perform analyses and generate reports?

For each database,there can be more than one physical view of data.

Describe the tasks performed in the first normal form (1NF) stage of normalization.

In large organizations,database design and management is handled by the _____.

The _____ component of a database management system (DBMS) is used for tasks such as backup and recovery,security,and change management.

Information Systems: an Overview

Computers: the Machines Behind Computing

Personal,legal,ethical,and Organizational Issues of Information Systems

Protecting Information Resources

Data Communication: Delivering Information Anywhere and Anytime

The Internet,intranets,and Extranets

E-Commerce

Global Information Systems

Building Successful Information Systems

Enterprise Systems

Management Support Systems

Intelligent Information Systems

Emerging Trends,technologies,and Applications

Filters