Question 1

A database administrator (DBA)is responsible for _____.

Accepted Answer

A) developing recovery procedures in case data is lost or corrupted 
B) keeping an organization's computer network up to date 
C) writing computer programs that allow a system to perform a specific task 
D) designing and implementing an organization's information systems 
A) developing recovery procedures in case data is lost or corrupted 
B) keeping an organization's computer network up to date 
C) writing computer programs that allow a system to perform a specific task 
D) designing and implementing an organization's information systems

Question 2

In object-oriented databases,grouping objects along with their attributes and methods into a class is called _____.

Accepted Answer

A) allocation 
B) fragmentation 
C) encapsulation 
D) optimization 
A) allocation 
B) fragmentation 
C) encapsulation 
D) optimization

Question 3

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

Accepted Answer

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

Question 4

The _____ stores data types for fields,default values for fields,and validation rules for data in each field.

Accepted Answer

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

Question 5

Describe the fragmentation approach to setting up a distributed database management system (DDBMS).

Accepted Answer

Answers will vary.The fragmentation appr

Question 6

Discuss some examples of sources for external data.

Accepted Answer

Answers will vary.The following are exam

Question 7

In the context of data models,relationships among records in a hierarchical model are called _____.

Accepted Answer

A) nodes 
B) branches 
C) roots 
D) segments 
A) nodes 
B) branches 
C) roots 
D) segments

Question 8

List and describe the features of data in a data warehouse in contrast to data in a database.

Accepted Answer

Answers will vary.Data in a data warehou

Question 9

Discuss the advantages of data marts over data warehouses.

Accepted Answer

Answers will vary.Data marts have the fo

Question 10

Which component of a database management system (DBMS)is responsible for data storage,manipulation,and retrieval?

Accepted Answer

A) database storage 
B) data mine 
C) data mart 
D) database engine 
A) database storage 
B) data mine 
C) data mart 
D) database engine

Question 11

A data _____ is usually a smaller version of a data warehouse,used by a single department or function.

Accepted Answer

A) domain 
B) mine 
C) dictionary 
D) mart 
A) domain 
B) mine 
C) dictionary 
D) mart

Question 12

Consolidating information from different departments or functional areas is easier in data marts than in data warehouses.

Accepted Answer

A) True 
 B)False

Question 13

_____ is a component of a data model that defines the boundaries of a database,such as maximum and minimum values allowed for a field,constraints,and access methods.

Accepted Answer

A) Data structure 
B) Schema diagrams 
C) Integrity rules 
D) File procedure 
A) Data structure 
B) Schema diagrams 
C) Integrity rules 
D) File procedure

Question 14

Business analytics uses _____ to gain insight into data and provide decision makers with information they can act on.

Accepted Answer

A) predictive modeling 
B) dashboards 
C) query reports 
D) application generators 
A) predictive modeling 
B) dashboards 
C) query reports 
D) application generators

Question 15

In the context of the data manipulation component of a database management system (DBMS),briefly explain structured query language (SQL).

Accepted Answer

Answers will vary.The data manipulation

Question 16

Which statement is true of distributed databases?

Accepted Answer

A) They store data on one central server in an organization. 
B) They are limited by the data's physical location. 
C) In distributed databases,local storage of data increases response time. 
D) In distributed databases,local storage of data increases communication costs. 
A) They store data on one central server in an organization. 
B) They are limited by the data's physical location. 
C) In distributed databases,local storage of data increases response time. 
D) In distributed databases,local storage of data increases communication costs.

Question 17

Discuss the advantages of a database over a flat file system.

Accepted Answer

Answers will vary.A database has the fol

Question 18

The _____ view of a database involves how information appears to users and how it can be organized and retrieved.

Accepted Answer

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

Question 19

Business intelligence (BI)uses scorecards and dashboards to support decision-making activities,whereas business analytics (BA)uses data mining tools and predictive modeling.

Accepted Answer

A) True 
 B)False

Question 20

In the context of the types of data in a database,which is a source of internal data?

Accepted Answer

A) Tax records 
B) Sales records 
C) Distribution networks 
D) Economic indicators 
A) Tax records 
B) Sales records 
C) Distribution networks 
D) Economic indicators

A database administrator (DBA)is responsible for _____.

In object-oriented databases,grouping objects along with their attributes and methods into a class is called _____.

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

The _____ stores data types for fields,default values for fields,and validation rules for data in each field.

Describe the fragmentation approach to setting up a distributed database management system (DDBMS).

Discuss some examples of sources for external data.

In the context of data models,relationships among records in a hierarchical model are called _____.

List and describe the features of data in a data warehouse in contrast to data in a database.

Discuss the advantages of data marts over data warehouses.

Which component of a database management system (DBMS)is responsible for data storage,manipulation,and retrieval?

A data _____ is usually a smaller version of a data warehouse,used by a single department or function.

Consolidating information from different departments or functional areas is easier in data marts than in data warehouses.

_____ is a component of a data model that defines the boundaries of a database,such as maximum and minimum values allowed for a field,constraints,and access methods.

Business analytics uses _____ to gain insight into data and provide decision makers with information they can act on.

In the context of the data manipulation component of a database management system (DBMS),briefly explain structured query language (SQL).

Which statement is true of distributed databases?

Discuss the advantages of a database over a flat file system.

The _____ view of a database involves how information appears to users and how it can be organized and retrieved.

Business intelligence (BI)uses scorecards and dashboards to support decision-making activities,whereas business analytics (BA)uses data mining tools and predictive modeling.

In the context of the types of data in a database,which is a source of internal data?

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

A database administrator (DBA)is responsible for _____.

In object-oriented databases,grouping objects along with their attributes and methods into a class is called _____.

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

The _____ stores data types for fields,default values for fields,and validation rules for data in each field.

Describe the fragmentation approach to setting up a distributed database management system (DDBMS).

Discuss some examples of sources for external data.

In the context of data models,relationships among records in a hierarchical model are called _____.

List and describe the features of data in a data warehouse in contrast to data in a database.

Discuss the advantages of data marts over data warehouses.

Which component of a database management system (DBMS)is responsible for data storage,manipulation,and retrieval?

A data _____ is usually a smaller version of a data warehouse,used by a single department or function.

Consolidating information from different departments or functional areas is easier in data marts than in data warehouses.

_____ is a component of a data model that defines the boundaries of a database,such as maximum and minimum values allowed for a field,constraints,and access methods.

Business analytics uses _____ to gain insight into data and provide decision makers with information they can act on.

In the context of the data manipulation component of a database management system (DBMS),briefly explain structured query language (SQL).

Which statement is true of distributed databases?

Discuss the advantages of a database over a flat file system.

The _____ view of a database involves how information appears to users and how it can be organized and retrieved.

Business intelligence (BI)uses scorecards and dashboards to support decision-making activities,whereas business analytics (BA)uses data mining tools and predictive modeling.

In the context of the types of data in a database,which is a source of internal data?

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