Question 1

In two-tier architecture,the database and application functions are separated.

Accepted Answer

A) True 
 B)False

Question 2

What is meant by the OLAP term - Drill-down?

Accepted Answer

Drill-down permits the disaggregation of

Question 3

This chapter stressed the importance of data normalization when constructing a relational database.Why then is it important to de-normalize data in a data warehouse?

Accepted Answer

Wherever possible,normalized tables pert

Question 4

Explain the risks associated with the creation of unnecessary roles and why it can happen.

Accepted Answer

Managers in ERP environments have signif

Question 5

How are OLTP and OLAP different? Give examples of their use.

Accepted Answer

On-line transaction processing (OLTP)inv

Question 6

Which statement is LEAST accurate?

Accepted Answer

A)  Implementing an ERP system has as much to do with changing the way an organization does business than it does with technology. 
B)  The big-bang approach to ERP implementation is generally riskier than the phased in approach. 
C)  To take full advantage of the ERP process, reengineering will need to occur. 
D)  A common reason for ERP failure is that the ERP does not support one or more important business processes of the organization 
A)  Implementing an ERP system has as much to do with changing the way an organization does business than it does with technology. 
B)  The big-bang approach to ERP implementation is generally riskier than the phased in approach. 
C)  To take full advantage of the ERP process, reengineering will need to occur. 
D)  A common reason for ERP failure is that the ERP does not support one or more important business processes of the organization

Question 7

Which of the following statements is not true?

Accepted Answer

A)  In a typical two-tier client server system, the server handles both application and database duties. 
B)  Client computers are responsible for presenting data to the user and passing user input back to the server. 
C)  In three-tier client server architecture, one tier is for user presentations, one is for database and applications, and the third is for Internet access. 
D)  The database and application functions are separate in the three-tier model. 
A)  In a typical two-tier client server system, the server handles both application and database duties. 
B)  Client computers are responsible for presenting data to the user and passing user input back to the server. 
C)  In three-tier client server architecture, one tier is for user presentations, one is for database and applications, and the third is for Internet access. 
D)  The database and application functions are separate in the three-tier model.

Question 8

Which of the following statements is least likely to be true about a data warehouse?

Accepted Answer

A)  It is constructed for quick searching and ad hoc queries. 
B)  It was an original part of all ERP systems. 
C)  It contains data that are normally extracted periodically from the operating databases. 
D)  It may be deployed by organizations that have not implemented an ERP. 
A)  It is constructed for quick searching and ad hoc queries. 
B)  It was an original part of all ERP systems. 
C)  It contains data that are normally extracted periodically from the operating databases. 
D)  It may be deployed by organizations that have not implemented an ERP.

Question 9

Extracting data for a data warehouse

Accepted Answer

A)  cannot be done from flat files. 
B)  should only involve active files. 
C)  requires that the files be out of service. 
D)  follows the cleansing of data. 
A)  cannot be done from flat files. 
B)  should only involve active files. 
C)  requires that the files be out of service. 
D)  follows the cleansing of data.

Question 10

Which of the following is NOT as a risk associated with ERP implementation.?

Accepted Answer

A)  A drop in firm performance after implementation because the firm looks and works differently than it did while using a legacy system. 
B)  Implementing companies have found that staff members, employed by ERP consulting firms, do not have sufficient experience in implementing new systems. 
C)  Implementing firms fail to select systems that properly support their business activities. 
D)  The selected system does not adequately meet the adopting firm's economic growth. 
E)  ERP's are too large, complex, and generic for them to be well integrated into most company cultures. 
A)  A drop in firm performance after implementation because the firm looks and works differently than it did while using a legacy system. 
B)  Implementing companies have found that staff members, employed by ERP consulting firms, do not have sufficient experience in implementing new systems. 
C)  Implementing firms fail to select systems that properly support their business activities. 
D)  The selected system does not adequately meet the adopting firm's economic growth. 
E)  ERP's are too large, complex, and generic for them to be well integrated into most company cultures.

Question 11

Data in a data warehouse are in a stable state.Explain how this can hamper data mining analysis? What can an organization do to alleviate this problem?

Accepted Answer

Typically transaction data are loaded in

Question 12

An access control list specifies the user-ID,the resources available to the user,and the level of permission granted.

Accepted Answer

A) True 
 B)False

In two-tier architecture,the database and application functions are separated.

What is meant by the OLAP term - Drill-down?

This chapter stressed the importance of data normalization when constructing a relational database.Why then is it important to de-normalize data in a data warehouse?

Explain the risks associated with the creation of unnecessary roles and why it can happen.

How are OLTP and OLAP different? Give examples of their use.

Which statement is LEAST accurate?

Which of the following statements is not true?

Which of the following statements is least likely to be true about a data warehouse?

Extracting data for a data warehouse

Which of the following is NOT as a risk associated with ERP implementation.?

Data in a data warehouse are in a stable state.Explain how this can hamper data mining analysis? What can an organization do to alleviate this problem?

An access control list specifies the user-ID,the resources available to the user,and the level of permission granted.

Auditing and Internal Control

Auditing IT Governance Controls

Security Part I: Auditing Operating Systems and Networks

IT Security Part II: Auditing Database Systems

Systems Development and Program Change Activities

Overview of Transaction Processing and Financial Reporting Systems

Computer-Assisted Audit Tools and Techniques

Data Structures and CAATTs for Data Extraction

Auditing the Revenue Cycle

Auditing the Expenditure Cycle

Business Ethics, Fraud, and Fraud Detection

Filters

Exam 11: Enterprise Resource Planning Systems

In two-tier architecture,the database and application functions are separated.

What is meant by the OLAP term - Drill-down?

This chapter stressed the importance of data normalization when constructing a relational database.Why then is it important to de-normalize data in a data warehouse?

Explain the risks associated with the creation of unnecessary roles and why it can happen.

How are OLTP and OLAP different? Give examples of their use.

Which statement is LEAST accurate?

Which of the following statements is not true?

Which of the following statements is least likely to be true about a data warehouse?

Extracting data for a data warehouse

Which of the following is NOT as a risk associated with ERP implementation.?

Data in a data warehouse are in a stable state.Explain how this can hamper data mining analysis? What can an organization do to alleviate this problem?

An access control list specifies the user-ID,the resources available to the user,and the level of permission granted.

Auditing and Internal Control

Auditing IT Governance Controls

Security Part I: Auditing Operating Systems and Networks

IT Security Part II: Auditing Database Systems

Systems Development and Program Change Activities

Overview of Transaction Processing and Financial Reporting Systems

Computer-Assisted Audit Tools and Techniques

Data Structures and CAATTs for Data Extraction

Auditing the Revenue Cycle

Auditing the Expenditure Cycle

Business Ethics, Fraud, and Fraud Detection

Filters