Question 1

From a logical point of view,a _______________ is the smallest data element that can be observed and manipulated.

Accepted Answer

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

Question 2

The duplication process basically identifies one database as a _______________ and then duplicates that database at a prescribed time so that each distributed location has the same data.

Accepted Answer

master

Question 3

Astronomers use computers to calculate the size,speed,and trajectory of objects in space to determine if they pose a threat to the earth.

Accepted Answer

A) True 
 B)False  True

Question 4

A _______________ is an integrated collection of logically related data elements.

Accepted Answer

A) database 
B) record 
C) data warehouse 
D) file 
A) database 
B) record 
C) data warehouse 
D) file

Question 5

A _______________ is an overall logical view of the relationships among the data elements in a database.

Accepted Answer

The answer of A _______________ is an overall logical view...

Question 6

The data dictionary,or repository,contains _______________,which is _______________.

Accepted Answer

A) the database model; the model of the business processes 
B) metadata; data about the data 
C) data structures; access methods for the data 
D) encapsulated data; the combined data and programs that work on the data 
A) the database model; the model of the business processes 
B) metadata; data about the data 
C) data structures; access methods for the data 
D) encapsulated data; the combined data and programs that work on the data

Question 7

The object-oriented database model supports _______________.That is,new objects can be automatically created by replicating some or all of the characteristics of one or more parent objects.

Accepted Answer

A) inheritance 
B) morphing 
C) duplication 
D) cloning 
A) inheritance 
B) morphing 
C) duplication 
D) cloning

Question 8

Database _______________ involves using transaction processing systems and other tools to add,delete,update,and correct the data in a database.

Accepted Answer

The answer of Database _______________ involves using transaction processing systems...

Question 9

The database maintenance process is accomplished via:

Accepted Answer

A) Hierarchical database systems that provide flexibility and network databases 
B) Transaction processing systems and other end user applications,with the support of the DBMS 
C) Graphical query languages correctly phrasing SQL 
D) File processing systems with the support of 4GLs 
A) Hierarchical database systems that provide flexibility and network databases 
B) Transaction processing systems and other end user applications,with the support of the DBMS 
C) Graphical query languages correctly phrasing SQL 
D) File processing systems with the support of 4GLs

Question 10

Google recently made its desktop and paid-search products available to external developers.

Accepted Answer

A) True 
 B)False

Question 11

According to one database pioneer,the future development of databases and data warehouses will depend on _______________.

Accepted Answer

A) rows 
B) columns 
C) transaction 
D) All of the choices are correct. 
A) rows 
B) columns 
C) transaction 
D) All of the choices are correct.

Question 12

The major limitation of the relational model is _______________.

Accepted Answer

A) it is so complex that most database programmers cannot understand it 
B) it makes too many errors when processing business transactions 
C) it takes up too much space on storage devices 
D) it cannot process large amounts of transactions as quickly and efficiently as the hierarchical and network models 
A) it is so complex that most database programmers cannot understand it 
B) it makes too many errors when processing business transactions 
C) it takes up too much space on storage devices 
D) it cannot process large amounts of transactions as quickly and efficiently as the hierarchical and network models

Question 13

Operational databases store the detailed data needed to support the business processes and operations of a company.They are also called _______________.

Accepted Answer

A) subject area databases 
B) transaction databases 
C) production databases 
D) All of the choices are correct. 
A) subject area databases 
B) transaction databases 
C) production databases 
D) All of the choices are correct.

Question 14

Using a relational database,a user can temporarily combine two or more tables so that he/she can see relevant data in a form that looks like it is in one big table.This is the _______________ operation.

Accepted Answer

A) join 
B) link 
C) merge 
D) select 
A) join 
B) link 
C) merge 
D) select

Question 15

In the relational database model,all data elements within the database are viewed as being stored in the form of simple,two-dimensional tables,sometimes referred to as _______________.

Accepted Answer

The answer of In the relational database model,all data elements...

Question 16

In mainframe and server computer systems,the database management system controls the _______________ of the databases of computer-using organizations.

Accepted Answer

A) maintenance 
B) development 
C) use 
D) All of the choices are correct. 
A) maintenance 
B) development 
C) use 
D) All of the choices are correct.

Question 17

The data stored in a database are _______________ the application programs using them.

Accepted Answer

A) an integral part of 
B) dependent on 
C) related to 
D) independent of 
A) an integral part of 
B) dependent on 
C) related to 
D) independent of

Question 18

The _______________ stage of database development translates the conceptual models into the data model of a DBMS.

Accepted Answer

A) data planning 
B) requirements specification 
C) conceptual design 
D) logical design 
A) data planning 
B) requirements specification 
C) conceptual design 
D) logical design

Question 19

A major benefit of multidimensional databases is that they are a compact and easy-to-understand way to visualize and manipulate data elements that have many interrelationships.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following is a legitimate use for data mining?

Accepted Answer

A) Performing "market-basket analysis" to identify new product bundles 
B) Profiling customers 
C) Finding the root cause of a quality or manufacturing problem 
D) All of the choices are correct. 
A) Performing "market-basket analysis" to identify new product bundles 
B) Profiling customers 
C) Finding the root cause of a quality or manufacturing problem 
D) All of the choices are correct.

From a logical point of view,a _______________ is the smallest data element that can be observed and manipulated.

The duplication process basically identifies one database as a _______________ and then duplicates that database at a prescribed time so that each distributed location has the same data.

Astronomers use computers to calculate the size,speed,and trajectory of objects in space to determine if they pose a threat to the earth.

A _______________ is an integrated collection of logically related data elements.

A _______________ is an overall logical view of the relationships among the data elements in a database.

The data dictionary,or repository,contains _,which is _.

The object-oriented database model supports _______________.That is,new objects can be automatically created by replicating some or all of the characteristics of one or more parent objects.

Database _______________ involves using transaction processing systems and other tools to add,delete,update,and correct the data in a database.

The database maintenance process is accomplished via:

Google recently made its desktop and paid-search products available to external developers.

According to one database pioneer,the future development of databases and data warehouses will depend on _______________.

The major limitation of the relational model is _______________.

Operational databases store the detailed data needed to support the business processes and operations of a company.They are also called _______________.

Using a relational database,a user can temporarily combine two or more tables so that he/she can see relevant data in a form that looks like it is in one big table.This is the _______________ operation.

In the relational database model,all data elements within the database are viewed as being stored in the form of simple,two-dimensional tables,sometimes referred to as _______________.

In mainframe and server computer systems,the database management system controls the _______________ of the databases of computer-using organizations.

The data stored in a database are _______________ the application programs using them.

The _______________ stage of database development translates the conceptual models into the data model of a DBMS.

A major benefit of multidimensional databases is that they are a compact and easy-to-understand way to visualize and manipulate data elements that have many interrelationships.

Which of the following is a legitimate use for data mining?

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

From a logical point of view,a _______________ is the smallest data element that can be observed and manipulated.

The duplication process basically identifies one database as a _______________ and then duplicates that database at a prescribed time so that each distributed location has the same data.

Astronomers use computers to calculate the size,speed,and trajectory of objects in space to determine if they pose a threat to the earth.

A _______________ is an integrated collection of logically related data elements.

A _______________ is an overall logical view of the relationships among the data elements in a database.

The data dictionary,or repository,contains _______________,which is _______________.

The object-oriented database model supports _______________.That is,new objects can be automatically created by replicating some or all of the characteristics of one or more parent objects.

Database _______________ involves using transaction processing systems and other tools to add,delete,update,and correct the data in a database.

The database maintenance process is accomplished via:

Google recently made its desktop and paid-search products available to external developers.

According to one database pioneer,the future development of databases and data warehouses will depend on _______________.

The major limitation of the relational model is _______________.

Operational databases store the detailed data needed to support the business processes and operations of a company.They are also called _______________.

Using a relational database,a user can temporarily combine two or more tables so that he/she can see relevant data in a form that looks like it is in one big table.This is the _______________ operation.

In the relational database model,all data elements within the database are viewed as being stored in the form of simple,two-dimensional tables,sometimes referred to as _______________.

In mainframe and server computer systems,the database management system controls the _______________ of the databases of computer-using organizations.

The data stored in a database are _______________ the application programs using them.

The _______________ stage of database development translates the conceptual models into the data model of a DBMS.

A major benefit of multidimensional databases is that they are a compact and easy-to-understand way to visualize and manipulate data elements that have many interrelationships.

Which of the following is a legitimate use for data mining?

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

The data dictionary,or repository,contains _,which is _.