Question 1

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

Accepted Answer

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

Question 2

Explain the function of the data definition component of a database management system.

Accepted Answer

Answers will vary.The data definition co

Question 3

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 4

In the context of database marketing,when a buyer is segmented on the basis of variable psychographics,it explains _____.

Accepted Answer

A) why the buyer buys a product or service 
B) who the buyer is 
C) how the buyer buys a product or service 
D) where the buyer is 
A) why the buyer buys a product or service 
B) who the buyer is 
C) how the buyer buys a product or service 
D) where the buyer is

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

A _____ acts as an interface to a database,retrieving data for users and allowing users to enter data in the database.

Accepted Answer

A) data-driven Web site 
B) flat Web page 
C) stationary Web page 
D) static Web site 
A) data-driven Web site 
B) flat Web page 
C) stationary Web page 
D) static Web site

Question 7

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

Accepted Answer

Answers will vary.In a random access fil

Question 8

The _____ method for accessing files is effective when a large number of records are processed less frequently,perhaps on a quarterly or yearly basis.

Accepted Answer

A) sequential access file structure 
B) random access file structure 
C) indexed sequential access 
D) physical view access 
A) sequential access file structure 
B) random access file structure 
C) indexed sequential access 
D) physical view access

Question 9

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 10

In a relational database model,a _____ is a field in a relational table that matches the primary key column of another table.

Accepted Answer

A) secondary key 
B) foreign key 
C) serial key 
D) domain key 
A) secondary key 
B) foreign key 
C) serial key 
D) domain key

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) developer 
B) evaluator 
C) synchronizer 
D) administrator 
A) developer 
B) evaluator 
C) synchronizer 
D) administrator

Question 13

In the context of how information is viewed in a database,the _____ involves how data is stored on and retrieved from storage media.

Accepted Answer

A) physical view 
B) logical view 
C) rational view 
D) analytical view 
A) physical view 
B) logical view 
C) rational view 
D) analytical view

Question 14

The variety dimension of big data refers to the combination of _____.

Accepted Answer

A) data warehouses and data marts 
B) object-oriented data models and relational data models 
C) structured data and unstructured data 
D) data definition and data manipulation 
A) data warehouses and data marts 
B) object-oriented data models and relational data models 
C) structured data and unstructured data 
D) data definition and data manipulation

Question 15

What is one advantage of a database over a flat file system?

Accepted Answer

A) Hardware and software start-up costs are low when using a database. 
B) A database is simple and easy to design. 
C) Programs and data are interdependent in a database. 
D) A database uses more sophisticated security measures. 
A) Hardware and software start-up costs are low when using a database. 
B) A database is simple and easy to design. 
C) Programs and data are interdependent in a database. 
D) A database uses more sophisticated security measures.

Question 16

Database marketing works by using multivariate analysis,data segmentation,and automated tools to transform marketing from a proactive to a reactive process.

Accepted Answer

A) True 
 B)False

Question 17

_____ 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 18

_____ analysis is used to discover patterns and relationships.

Accepted Answer

A) Data mart 
B) Data-mining 
C) Data pattern 
D) Data-toggling 
A) Data mart 
B) Data-mining 
C) Data pattern 
D) Data-toggling

Question 19

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 20

Which statement is true of a database?

Accepted Answer

A) It allows more than one program to use the same data. 
B) It comprises data that cannot be linked. 
C) It consists of a segregated set of files. 
D) It is a crucial tool for managing overseas subsidiaries. 
A) It allows more than one program to use the same data. 
B) It comprises data that cannot be linked. 
C) It consists of a segregated set of files. 
D) It is a crucial tool for managing overseas subsidiaries.

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

Explain the function of the data definition component of a database management system.

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

In the context of database marketing,when a buyer is segmented on the basis of variable psychographics,it explains _____.

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

A _____ acts as an interface to a database,retrieving data for users and allowing users to enter data in the database.

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

The _____ method for accessing files is effective when a large number of records are processed less frequently,perhaps on a quarterly or yearly basis.

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.

In a relational database model,a _____ is a field in a relational table that matches the primary key column of another table.

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

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

In the context of how information is viewed in a database,the _____ involves how data is stored on and retrieved from storage media.

The variety dimension of big data refers to the combination of _____.

What is one advantage of a database over a flat file system?

Database marketing works by using multivariate analysis,data segmentation,and automated tools to transform marketing from a proactive to a reactive process.

_____ 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.

_____ analysis is used to discover patterns and relationships.

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

Which statement is true of a database?

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

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

Explain the function of the data definition component of a database management system.

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

In the context of database marketing,when a buyer is segmented on the basis of variable psychographics,it explains _____.

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

A _____ acts as an interface to a database,retrieving data for users and allowing users to enter data in the database.

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

The _____ method for accessing files is effective when a large number of records are processed less frequently,perhaps on a quarterly or yearly basis.

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.

In a relational database model,a _____ is a field in a relational table that matches the primary key column of another table.

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

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

In the context of how information is viewed in a database,the _____ involves how data is stored on and retrieved from storage media.

The variety dimension of big data refers to the combination of _____.

What is one advantage of a database over a flat file system?

Database marketing works by using multivariate analysis,data segmentation,and automated tools to transform marketing from a proactive to a reactive process.

_____ 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.

_____ analysis is used to discover patterns and relationships.

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

Which statement is true of a database?

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