Question 1

Which of the following is NOT one of the three rules of data normalization?

Accepted Answer

A) Eliminate repeating groups 
B) Eliminate redundant data 
C) Eliminate blank fields 
D) Eliminate columns not dependent on the primary keys 
A) Eliminate repeating groups 
B) Eliminate redundant data 
C) Eliminate blank fields 
D) Eliminate columns not dependent on the primary keys

Question 2

Select the true statement from the following.

Accepted Answer

A) A character is a single letter only. 
B) A character is a single number only. 
C) A character is a single symbol only. 
D) A character is a single letter, number, or symbol. 
A) A character is a single letter only. 
B) A character is a single number only. 
C) A character is a single symbol only. 
D) A character is a single letter, number, or symbol.

Question 3

To database user, the question of how or where data is stored continues to be less important.

Accepted Answer

A) True 
 B)False

Question 4

Data warehouse files are non-volatile, and not frequently updated while operational databases are updated with each transaction that affects them.

Accepted Answer

A) True 
 B)False

Question 5

The purpose of the data warehouse does NOT include:

Accepted Answer

A) Giving managers rich sources of current trends and data. 
B) Storing current fiscal data and activity records. 
C) Providing sales with current customer information. 
D) Giving managers rich sources of historical trends and data. 
A) Giving managers rich sources of current trends and data. 
B) Storing current fiscal data and activity records. 
C) Providing sales with current customer information. 
D) Giving managers rich sources of historical trends and data.

Question 6

Data are the set of facts collected from transactions.

Accepted Answer

A) True 
 B)False

Question 7

Select the correct statement from the following.

Accepted Answer

A) Data redundancy and concurrency are features of well-designed database management systems. 
B) Data redundancy, not concurrency, is a feature of a well-designed database management system. 
C) Concurrency not, data redundancy, is a feature of a well-designed database management system. 
D) Data redundancy and concurrency are not features of well-designed database management systems. 
A) Data redundancy and concurrency are features of well-designed database management systems. 
B) Data redundancy, not concurrency, is a feature of a well-designed database management system. 
C) Concurrency not, data redundancy, is a feature of a well-designed database management system. 
D) Data redundancy and concurrency are not features of well-designed database management systems.

Question 8

Which of the following is not an advantage of using real-time data processing?

Accepted Answer

A) Quick response time to support timely record keeping and customer satisfaction 
B) Efficiency for use with large volumes of data 
C) Provides for random access of data 
D) Improved accuracy due to the immediate recording of transactions 
A) Quick response time to support timely record keeping and customer satisfaction 
B) Efficiency for use with large volumes of data 
C) Provides for random access of data 
D) Improved accuracy due to the immediate recording of transactions

Question 9

Information is the set of facts collected from transactions.

Accepted Answer

A) True 
 B)False

Question 10

Select the true statement from those provided below.

Accepted Answer

A) The data warehouse has five to ten years of data while the operational database has current year data. 
B) The data warehouse has current year data while the operational database has five to ten years of data. 
C) The data warehouse archives both current and long-term, five to ten years of data, within its storage. 
D) The data warehouse contains only general ledger type information while the operational database has detail. 
A) The data warehouse has five to ten years of data while the operational database has current year data. 
B) The data warehouse has current year data while the operational database has five to ten years of data. 
C) The data warehouse archives both current and long-term, five to ten years of data, within its storage. 
D) The data warehouse contains only general ledger type information while the operational database has detail.

Question 11

Data redundancy occurs when the same customer has more than one database record.

Accepted Answer

A) True 
 B)False

Question 12

Since distributed databases are under the control of many individual sites rather than a single, centralized site, configuration, conformity, and security are less of an issue.

Accepted Answer

A) True 
 B)False

Question 13

The data warehouse:

Accepted Answer

A) Contains five to ten years of historical data in detail for planning and analysis. 
B) Contains the current fiscal year in detail for planning, analysis, and reporting. 
C) Contains the historical information needed for planning and analysis. 
D) Is not utilized for planning and analysis, this information is extracted from the operational database. 
A) Contains five to ten years of historical data in detail for planning and analysis. 
B) Contains the current fiscal year in detail for planning, analysis, and reporting. 
C) Contains the historical information needed for planning and analysis. 
D) Is not utilized for planning and analysis, this information is extracted from the operational database.

Question 14

Real-time processing occurs when similar transactions are grouped into a batch and that batch is processed as a group.

Accepted Answer

A) True 
 B)False

Question 15

High-impact processes HIPs):

Accepted Answer

A) Determine the structure of the data in the data warehouse. 
B) Address the short-term goals of the organization. 
C) Must compromise user requirements for organizational needs. 
D) Determine the structure of the data in the operational database. 
A) Determine the structure of the data in the data warehouse. 
B) Address the short-term goals of the organization. 
C) Must compromise user requirements for organizational needs. 
D) Determine the structure of the data in the operational database.

Question 16

Which of the following terms is most closely related to data redundancy?

Accepted Answer

A) Relational database 
B) Concurrency 
C) Batch processing 
D) One-to-many relationships 
A) Relational database 
B) Concurrency 
C) Batch processing 
D) One-to-many relationships

Question 17

Select the false statement from those provided.

Accepted Answer

A) Real-time processing is more complex because of the interactive nature of data processing. 
B) Real-time processing must use sequential storage concepts. 
C) The audit trail is as complex within both real-time and batch processing systems. 
D) Control totals are difficult within real-time processing due to the lack of data item groupings. 
A) Real-time processing is more complex because of the interactive nature of data processing. 
B) Real-time processing must use sequential storage concepts. 
C) The audit trail is as complex within both real-time and batch processing systems. 
D) Control totals are difficult within real-time processing due to the lack of data item groupings.

Question 18

Data collected would be all but the:

Accepted Answer

A) Name of the customer. 
B) Selling company's name. 
C) Address of the customer. 
D) Credit card number of the customer. 
A) Name of the customer. 
B) Selling company's name. 
C) Address of the customer. 
D) Credit card number of the customer.

Question 19

A relational database stores data in two-dimensional tables that are joined in many ways to represent many different kinds of relationships in the data.

Accepted Answer

A) True 
 B)False

Question 20

Batch processing occurs when transactions are processed as soon as they are entered.

Accepted Answer

A) True 
 B)False

Which of the following is NOT one of the three rules of data normalization?

Select the true statement from the following.

To database user, the question of how or where data is stored continues to be less important.

Data warehouse files are non-volatile, and not frequently updated while operational databases are updated with each transaction that affects them.

The purpose of the data warehouse does NOT include:

Data are the set of facts collected from transactions.

Select the correct statement from the following.

Which of the following is not an advantage of using real-time data processing?

Information is the set of facts collected from transactions.

Select the true statement from those provided below.

Data redundancy occurs when the same customer has more than one database record.

Since distributed databases are under the control of many individual sites rather than a single, centralized site, configuration, conformity, and security are less of an issue.

The data warehouse:

Real-time processing occurs when similar transactions are grouped into a batch and that batch is processed as a group.

High-impact processes HIPs):

Which of the following terms is most closely related to data redundancy?

Select the false statement from those provided.

Data collected would be all but the:

A relational database stores data in two-dimensional tables that are joined in many ways to represent many different kinds of relationships in the data.

Batch processing occurs when transactions are processed as soon as they are entered.

Introduction to AIS

Foundational Concepts of the AIS

Fraud, Ethics, and Internal Control

Internal Controls and Risks in IT Systems

IT Governance

Erp Systems

Auditing Information Technology Bases Processes

Revenue and Cash Collection Processes

Expenditures Processes and Controls - Purchases

Expenditures Processes and Controls Payroll and Fixed Assets

Conversion Processes and Controls

Administrative Processes and Controls

Ecommerce and Ebusiness

Filters

Exam 13: Data and Databases

Which of the following is NOT one of the three rules of data normalization?

Select the true statement from the following.

To database user, the question of how or where data is stored continues to be less important.

Data warehouse files are non-volatile, and not frequently updated while operational databases are updated with each transaction that affects them.

The purpose of the data warehouse does NOT include:

Data are the set of facts collected from transactions.

Select the correct statement from the following.

Which of the following is not an advantage of using real-time data processing?

Information is the set of facts collected from transactions.

Select the true statement from those provided below.

Data redundancy occurs when the same customer has more than one database record.

Since distributed databases are under the control of many individual sites rather than a single, centralized site, configuration, conformity, and security are less of an issue.

The data warehouse:

Real-time processing occurs when similar transactions are grouped into a batch and that batch is processed as a group.

High-impact processes HIPs):

Which of the following terms is most closely related to data redundancy?

Select the false statement from those provided.

Data collected would be all but the:

A relational database stores data in two-dimensional tables that are joined in many ways to represent many different kinds of relationships in the data.

Batch processing occurs when transactions are processed as soon as they are entered.

Introduction to AIS

Foundational Concepts of the AIS

Fraud, Ethics, and Internal Control

Internal Controls and Risks in IT Systems

IT Governance

Erp Systems

Auditing Information Technology Bases Processes

Revenue and Cash Collection Processes

Expenditures Processes and Controls - Purchases

Expenditures Processes and Controls Payroll and Fixed Assets

Conversion Processes and Controls

Administrative Processes and Controls

Ecommerce and Ebusiness

Filters