Question 1

Describe how records are accessed in a random access file structure.

Accepted Answer

Answers will vary.In a random access fil

Question 2

A _____is software for creating, storing, maintaining, and accessing database files. ​

Accepted Answer

A)  database management system 
B)  data hierarchical system 
C)  database modelling tool 
D)  data warehousing tool 
A)  database management system 
B)  data hierarchical system 
C)  database modelling tool 
D)  data warehousing tool

Question 3

In a relational database, every record must be uniquely identified by a _____. ​

Accepted Answer

A)  primary key 
B)  super key 
C)  remote key 
D)  candidate key 
A)  primary key 
B)  super key 
C)  remote key 
D)  candidate key

Question 4

In a relational database model, the columns are called _____.

Accepted Answer

A)  attributes 
B)  tuples 
C)  branches 
D)  roots 
A)  attributes 
B)  tuples 
C)  branches 
D)  roots

Question 5

_____ can be described as using an organization's database of customers and potential customers in order to promote products or services that an organization offers.

Accepted Answer

A)  Database mining 
B)  Database marketing 
C)  Data encapsulation 
D)  Data normalization 
A)  Database mining 
B)  Database marketing 
C)  Data encapsulation 
D)  Data normalization

Question 6

Discuss the advantages of data marts over data warehouses.

Accepted Answer

Answers will vary.Data marts have the fo

Question 7

The first step in database design is defining a _____, which determines how data is created, represented, organized, and maintained.

Accepted Answer

A)  data warehouse 
B)  data mart 
C)  data dictionary 
D)  data model 
A)  data warehouse 
B)  data mart 
C)  data dictionary 
D)  data model

Question 8

Which of the following types of databases is not limited by the data's physical location?

Accepted Answer

A)  A distributed database 
B)  A relational database 
C)  A multi-structured database 
D)  A semi-structured database 
A)  A distributed database 
B)  A relational database 
C)  A multi-structured database 
D)  A semi-structured database

Question 9

Unlike data in databases, data in data warehouses is:

Accepted Answer

A)  function oriented. 
B)  raw transaction data. 
C)  collected from a single source. 
D)  used for analytical purposes. 
A)  function oriented. 
B)  raw transaction data. 
C)  collected from a single source. 
D)  used for analytical purposes.

Question 10

In comparison with a flat file system, _____ in a database.

Accepted Answer

A)  storage space is reduced 
B)  programs and data are interdependent 
C)  complex requests cannot be handled easily 
D)  data redundancy is introduced 
A)  storage space is reduced 
B)  programs and data are interdependent 
C)  complex requests cannot be handled easily 
D)  data redundancy is introduced

Question 11

In contrast to the query languages used to interact with a relational database, interaction with an object-oriented database takes places via methods, which are called by sending a message to an object.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following statements is true of database marketing?

Accepted Answer

A)  It works by using univariate analysis to transform marketing from a proactive to a reactive process. 
B)  It works by utilizing information that can be found outside the organizational database. 
C)  It makes an organization responsive to the needs of its customers. 
D)  It allows an organization to resist changes in the marketplace. 
A)  It works by using univariate analysis to transform marketing from a proactive to a reactive process. 
B)  It works by utilizing information that can be found outside the organizational database. 
C)  It makes an organization responsive to the needs of its customers. 
D)  It allows an organization to resist changes in the marketplace.

Question 13

_____ improves database efficiency by eliminating redundant data and ensuring that only related data is stored in a table.

Accepted Answer

A)  Triangulation 
B)  Fragmentation 
C)  Normalization 
D)  Encapsulation 
A)  Triangulation 
B)  Fragmentation 
C)  Normalization 
D)  Encapsulation

Question 14

In a relational database model, a(n) _____ pares down a table by eliminating columns according to certain criteria.

Accepted Answer

A)  project operation 
B)  join operation 
C)  find operation 
D)  insert operation 
A)  project operation 
B)  join operation 
C)  find operation 
D)  insert operation

Question 15

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

Accepted Answer

A)  sequential access file structure 
B)  random access file structure 
C)  indexed access file structure 
D)  direct access file structure 
A)  sequential access file structure 
B)  random access file structure 
C)  indexed access file structure 
D)  direct access file structure

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

A database engine converts logical requests from users into their physical equivalents by interacting with other components of the database management system (DBMS).

Accepted Answer

A) True 
 B)False

Question 18

Static Web sites are useful for e-commerce sites that need frequent updates.

Accepted Answer

A) True 
 B)False

Question 19

In the context of the data administration component of a database management system (DBMS), the acronym CRUD stands for _____.

Accepted Answer

A)  create, read, update, and delete 
B)  copy, revise, undo, and define 
C)  create, repeat, undo, and develop 
D)  copy, read, update, and define 
A)  create, read, update, and delete 
B)  copy, revise, undo, and define 
C)  create, repeat, undo, and develop 
D)  copy, read, update, and define

Question 20

_____tools are capable of "drilling up," proceeding from the smallest unit of data to higher levels. ​

Accepted Answer

A)  Online analytical processing 
B)  Online transaction processing 
C)  Extraction, transformation, and loading 
D)  Business analytics 
A)  Online analytical processing 
B)  Online transaction processing 
C)  Extraction, transformation, and loading 
D)  Business analytics

Describe how records are accessed in a random access file structure.

A _____is software for creating, storing, maintaining, and accessing database files.

In a relational database, every record must be uniquely identified by a _____.

In a relational database model, the columns are called _____.

_____ can be described as using an organization's database of customers and potential customers in order to promote products or services that an organization offers.

Discuss the advantages of data marts over data warehouses.

The first step in database design is defining a _____, which determines how data is created, represented, organized, and maintained.

Which of the following types of databases is not limited by the data's physical location?

Unlike data in databases, data in data warehouses is:

In comparison with a flat file system, _____ in a database.

In contrast to the query languages used to interact with a relational database, interaction with an object-oriented database takes places via methods, which are called by sending a message to an object.

Which of the following statements is true of database marketing?

_____ improves database efficiency by eliminating redundant data and ensuring that only related data is stored in a table.

In a relational database model, a(n) _____ pares down a table by eliminating columns according to certain criteria.

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

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

A database engine converts logical requests from users into their physical equivalents by interacting with other components of the database management system (DBMS).

Static Web sites are useful for e-commerce sites that need frequent updates.

In the context of the data administration component of a database management system (DBMS), the acronym CRUD stands for _____.

_____tools are capable of "drilling up," proceeding from the smallest unit of data to higher levels.

Information Systems: An Overview

Computers: The Machines Behind Computing

Personal, Legal, Ethical and Organizational Issues of Information Systems

Protecting Information Resources

Data Communication

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

Describe how records are accessed in a random access file structure.

A _____is software for creating, storing, maintaining, and accessing database files. ​

In a relational database, every record must be uniquely identified by a _____. ​

In a relational database model, the columns are called _____.

_____ can be described as using an organization's database of customers and potential customers in order to promote products or services that an organization offers.

Discuss the advantages of data marts over data warehouses.

The first step in database design is defining a _____, which determines how data is created, represented, organized, and maintained.

Which of the following types of databases is not limited by the data's physical location?

Unlike data in databases, data in data warehouses is:

In comparison with a flat file system, _____ in a database.

In contrast to the query languages used to interact with a relational database, interaction with an object-oriented database takes places via methods, which are called by sending a message to an object.

Which of the following statements is true of database marketing?

_____ improves database efficiency by eliminating redundant data and ensuring that only related data is stored in a table.

In a relational database model, a(n) _____ pares down a table by eliminating columns according to certain criteria.

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

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

A database engine converts logical requests from users into their physical equivalents by interacting with other components of the database management system (DBMS).

Static Web sites are useful for e-commerce sites that need frequent updates.

In the context of the data administration component of a database management system (DBMS), the acronym CRUD stands for _____.

_____tools are capable of "drilling up," proceeding from the smallest unit of data to higher levels. ​

Information Systems: An Overview

Computers: The Machines Behind Computing

Personal, Legal, Ethical and Organizational Issues of Information Systems

Protecting Information Resources

Data Communication

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

A _____is software for creating, storing, maintaining, and accessing database files.

In a relational database, every record must be uniquely identified by a _____.

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

_____tools are capable of "drilling up," proceeding from the smallest unit of data to higher levels.