Question 1

_______________ databases enable an end user to receive information easily in response to ad hoc requests.

Accepted Answer

A) Network 
B) Object-oriented 
C) Relational 
D) Multidimensional 
A) Network 
B) Object-oriented 
C) Relational 
D) Multidimensional

Question 2

The physical design stage of database development:

Accepted Answer

A) Develops a model of business processes 
B) Translates conceptual models into the data models 
C) Determines the data storage structures and access methods 
D) Defines the information needs of end users in a business process 
A) Develops a model of business processes 
B) Translates conceptual models into the data models 
C) Determines the data storage structures and access methods 
D) Defines the information needs of end users in a business process

Question 3

Which of the following is true of data marts?

Accepted Answer

A) They hold data from many different data warehouses. 
B) They are a subset of a data warehouse. 
C) They focus on many generalized aspects of a company. 
D) None of the choices are correct. 
A) They hold data from many different data warehouses. 
B) They are a subset of a data warehouse. 
C) They focus on many generalized aspects of a company. 
D) None of the choices are correct.

Question 4

Amazon lets others use and tinker with their platform,then pays the user for their research.

Accepted Answer

A) True 
 B)False

Question 5

Having data in independent files makes it easier to provide end users with information for ad hoc requests.

Accepted Answer

A) True 
 B)False

Question 6

A DBMS query language is designed to:

Accepted Answer

A) Support information systems professionals in the development of complex application software 
B) Support end users who wish to obtain ad hoc reports 
C) Provide efficient batch mode processing of the database 
D) Specify the content,relationships,and structure of a database 
A) Support information systems professionals in the development of complex application software 
B) Support end users who wish to obtain ad hoc reports 
C) Provide efficient batch mode processing of the database 
D) Specify the content,relationships,and structure of a database

Question 7

Sellers who use eBay's API become at least 50% more productive than those who use the Web site itself.

Accepted Answer

A) True 
 B)False

Question 8

A petabyte equals about one thousand times the printed content of the Library of Congress.

Accepted Answer

A) True 
 B)False

Question 9

An active data dictionary will prevent a data entry program from using a nonstandard definition of a customer record.

Accepted Answer

A) True 
 B)False

Question 10

Database management involves the use of database management software to control how databases are _______________.

Accepted Answer

A) created 
B) interrogated 
C) maintained 
D) All of the choices are correct. 
A) created 
B) interrogated 
C) maintained 
D) All of the choices are correct.

Question 11

Large organizations usually place control of enterprise-wide database development in the hands of database administrators (DBAs)and other database specialists.

Accepted Answer

A) True 
 B)False

Question 12

SQL is an acronym for _______________.It is an international standard query language found in many DBMS packages.

Accepted Answer

Structured

Question 13

To solve the problems encountered with the file processing approach,the _______________ management approach was conceived.It is the foundation of modern methods of managing organizational data.

Accepted Answer

The answer of To solve the problems encountered with the...

Question 14

Distributed databases require fewer resources when it comes to computing power and bandwidth.

Accepted Answer

A) True 
 B)False

Question 15

A data model serves as a logical framework on which to base the physical design of a database.

Accepted Answer

A) True 
 B)False

Question 16

All of the relationships between the data elements in a relationally organized database need to be specified when the database is created.

Accepted Answer

A) True 
 B)False

Question 17

_______________ relationship diagrams are used to model the relationships among the many entities involved in business processes.

Accepted Answer

The answer of _______________ relationship diagrams are used to model...

Question 18

In a relational database,a row represents _______________ and a column represents _______________.

Accepted Answer

A) a record; a field 
B) a table; a relation 
C) a data element; a picture element 
D) an attribute; an entity 
A) a record; a field 
B) a table; a relation 
C) a data element; a picture element 
D) an attribute; an entity

Question 19

A data field represents a(n)_______________ of some entity.

Accepted Answer

A) character 
B) bit 
C) attribute 
D) byte 
A) character 
B) bit 
C) attribute 
D) byte

Question 20

Which of the following statements concerning the replication and duplication process for updating distributed databases is correct?

Accepted Answer

A) The two terms are interchangeable because the processes work the same way 
B) Duplication is the more complicated process because it has to identify one database as a master and prevent changes being made to any database other than the master 
C) Replication is the more complicated process because it must find changes in each distributed database and make appropriate changes to make each database identical 
D) None of the choices is correct. 
A) The two terms are interchangeable because the processes work the same way 
B) Duplication is the more complicated process because it has to identify one database as a master and prevent changes being made to any database other than the master 
C) Replication is the more complicated process because it must find changes in each distributed database and make appropriate changes to make each database identical 
D) None of the choices is correct.

_______________ databases enable an end user to receive information easily in response to ad hoc requests.

The physical design stage of database development:

Which of the following is true of data marts?

Amazon lets others use and tinker with their platform,then pays the user for their research.

Having data in independent files makes it easier to provide end users with information for ad hoc requests.

A DBMS query language is designed to:

Sellers who use eBay's API become at least 50% more productive than those who use the Web site itself.

A petabyte equals about one thousand times the printed content of the Library of Congress.

An active data dictionary will prevent a data entry program from using a nonstandard definition of a customer record.

Database management involves the use of database management software to control how databases are _______________.

Large organizations usually place control of enterprise-wide database development in the hands of database administrators (DBAs)and other database specialists.

SQL is an acronym for _______________.It is an international standard query language found in many DBMS packages.

To solve the problems encountered with the file processing approach,the _______________ management approach was conceived.It is the foundation of modern methods of managing organizational data.

Distributed databases require fewer resources when it comes to computing power and bandwidth.

A data model serves as a logical framework on which to base the physical design of a database.

All of the relationships between the data elements in a relationally organized database need to be specified when the database is created.

_______________ relationship diagrams are used to model the relationships among the many entities involved in business processes.

In a relational database,a row represents _ and a column represents _.

A data field represents a(n)_______________ of some entity.

Which of the following statements concerning the replication and duplication process for updating distributed databases is correct?

Information Systems in Business

Strategic Decision Making

E-Business

Ethics and Information Security

Telecommunications and Networks

Networks, Telecommunications, and Mobile Technol

Operations Management and Supply Chain Management

Customer Relationship Management and Business Intelligence

Enterprise Resource Planning and Collaboration Systems

Systems Development and Project Management

Innovation, Entrepreneurship, and 21st Century Global Business

Filters

Exam 5: It Architectures

_______________ databases enable an end user to receive information easily in response to ad hoc requests.

The physical design stage of database development:

Which of the following is true of data marts?

Amazon lets others use and tinker with their platform,then pays the user for their research.

Having data in independent files makes it easier to provide end users with information for ad hoc requests.

A DBMS query language is designed to:

Sellers who use eBay's API become at least 50% more productive than those who use the Web site itself.

A petabyte equals about one thousand times the printed content of the Library of Congress.

An active data dictionary will prevent a data entry program from using a nonstandard definition of a customer record.

Database management involves the use of database management software to control how databases are _______________.

Large organizations usually place control of enterprise-wide database development in the hands of database administrators (DBAs)and other database specialists.

SQL is an acronym for _______________.It is an international standard query language found in many DBMS packages.

To solve the problems encountered with the file processing approach,the _______________ management approach was conceived.It is the foundation of modern methods of managing organizational data.

Distributed databases require fewer resources when it comes to computing power and bandwidth.

A data model serves as a logical framework on which to base the physical design of a database.

All of the relationships between the data elements in a relationally organized database need to be specified when the database is created.

_______________ relationship diagrams are used to model the relationships among the many entities involved in business processes.

In a relational database,a row represents _______________ and a column represents _______________.

A data field represents a(n)_______________ of some entity.

Which of the following statements concerning the replication and duplication process for updating distributed databases is correct?

Information Systems in Business

Strategic Decision Making

E-Business

Ethics and Information Security

Telecommunications and Networks

Networks, Telecommunications, and Mobile Technol

Operations Management and Supply Chain Management

Customer Relationship Management and Business Intelligence

Enterprise Resource Planning and Collaboration Systems

Systems Development and Project Management

Innovation, Entrepreneurship, and 21st Century Global Business

Filters

In a relational database,a row represents _ and a column represents _.