Question 1

Data is

Accepted Answer

A) The interpretation of facts that have been processed. 
B) The set of facts collected from transactions. 
C) The set of facts pertaining to accounts payable. 
D) The set of facts pertaining to accounts receivable. 
A) The interpretation of facts that have been processed. 
B) The set of facts collected from transactions. 
C) The set of facts pertaining to accounts payable. 
D) The set of facts pertaining to accounts receivable.

Question 2

If a company stores data in separate files in its different departmental locations and is able to update all files simultaneously, it would not have problems with

Accepted Answer

A) Attributes. 
B) Data redundancy. 
C) Industrial espionage. 
D) Concurrency. 
A) Attributes. 
B) Data redundancy. 
C) Industrial espionage. 
D) Concurrency.

Question 3

Direct access:

Accepted Answer

A) Means no passwords are required to access data items in a database. 
B) Is the same as sequential access. 
C) Is the same as random access. 
D) Is the process used by magnetic tape storage medium. 
A) Means no passwords are required to access data items in a database. 
B) Is the same as sequential access. 
C) Is the same as random access. 
D) Is the process used by magnetic tape storage medium.

Question 4

Data mining:

Accepted Answer

A) Searches for random patterns. 
B) Searches for patterns in the operational database. 
C) Results will not generally predict customer preferences. 
D) Analyzes past patterns to predict future events. 
A) Searches for random patterns. 
B) Searches for patterns in the operational database. 
C) Results will not generally predict customer preferences. 
D) Analyzes past patterns to predict future events.

Question 5

Potential variations in conditions that are used to understand interactions between different parts of the business is referred to as:

Accepted Answer

A) Exception reports. 
B) Pivoting. 
C) What-if simulations. 
D) Time series analysis. 
A) Exception reports. 
B) Pivoting. 
C) What-if simulations. 
D) Time series analysis.

Question 6

Real-time processing:

Accepted Answer

A) Would not be used for payment to vendor type transactions since they are not time sensitive. 
B) Occurs when similar transactions are grouped into a batch and processed as a group. 
C) Would be utilized for processes such as payroll due to their time-sensitive nature. 
D) Occurs when the transaction is processed immediately. 
A) Would not be used for payment to vendor type transactions since they are not time sensitive. 
B) Occurs when similar transactions are grouped into a batch and processed as a group. 
C) Would be utilized for processes such as payroll due to their time-sensitive nature. 
D) Occurs when the transaction is processed immediately.

Question 7

OLAP tools include all of the following EXCEPT:

Accepted Answer

A) Drill down. 
B) Drill up. 
C) Pivoting. 
D) Time series analysis. 
A) Drill down. 
B) Drill up. 
C) Pivoting. 
D) Time series analysis.

Question 8

Advantages of distributed databases include all EXCEPT:

Accepted Answer

A) Easier incremental growth. 
B) Multiple site access for processing. 
C) Decreased user involvement. 
D) Increased user control. 
A) Easier incremental growth. 
B) Multiple site access for processing. 
C) Decreased user involvement. 
D) Increased user control.

Question 9

Describe the difference between a data warehouse and an operational data base.Also explain how data is added or changed within these two types of databases.

Accepted Answer

A data warehouse is an integrated collec

Question 10

(Magnetic) Disk storage is:

Accepted Answer

A) The same as magnetic tape storage. 
B) Sequential access. 
C) Random access. 
D) Not direct access. 
A) The same as magnetic tape storage. 
B) Sequential access. 
C) Random access. 
D) Not direct access.

Question 11

The additive characteristic means:

Accepted Answer

A) The linked tables are synergetic within themselves - linked they are more powerful than alone. 
B) The values in the preceding fields must total into a following field. 
C) That if the preceding rules are met, the rule can be met. 
D) That if the preceding rules are not met, the rule must be met. 
A) The linked tables are synergetic within themselves - linked they are more powerful than alone. 
B) The values in the preceding fields must total into a following field. 
C) That if the preceding rules are met, the rule can be met. 
D) That if the preceding rules are not met, the rule must be met.

Question 12

A field is a (n):

Accepted Answer

A) Entire set of records within a file. 
B) Row within a record. 
C) Set of characters. 
D) Set of files within a database. 
A) Entire set of records within a file. 
B) Row within a record. 
C) Set of characters. 
D) Set of files within a database.

Question 13

Which of the following is false with regard to proper data analysis of data warehouse files:

Accepted Answer

A) Improves short-term planning. 
B) Improves long-term planning. 
C) Enhances the ability to meet customer needs. 
D) Increase performance. 
A) Improves short-term planning. 
B) Improves long-term planning. 
C) Enhances the ability to meet customer needs. 
D) Increase performance.

Question 14

Volume refers to:

Accepted Answer

A) How quickly data is generated or changed. 
B) How many data types and sources are available. 
C) The size and capacity of the data. 
D) The sound sensitivity of the data network. 
A) How quickly data is generated or changed. 
B) How many data types and sources are available. 
C) The size and capacity of the data. 
D) The sound sensitivity of the data network.

Question 15

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 16

A set of small databases where data are collected, processed, and stored on multiple computers within a network is a:

Accepted Answer

A) Centralized database. 
B) Distributed database. 
C) Flat file database. 
D) High-impact process. 
A) Centralized database. 
B) Distributed database. 
C) Flat file database. 
D) High-impact process.

Question 17

When a company buys data storage from a cloud provider, the arrangement is referred to as:

Accepted Answer

A) Online analytical processing 
B) Cloud services assessment 
C) Distributed data storage 
D) Database as a service 
A) Online analytical processing 
B) Cloud services assessment 
C) Distributed data storage 
D) Database as a service

Question 18

A character is to a field as

Accepted Answer

A) Water is to a pool. 
B) A pool is to a swimmer. 
C) A pool is to water. 
D) A glass is to water. 
A) Water is to a pool. 
B) A pool is to a swimmer. 
C) A pool is to water. 
D) A glass is to water.

Question 19

Structured query language (SQL):

Accepted Answer

A) Isolates data within tables. 
B) Takes advantage of the primary record key to link tables. 
C) Is a complex language used to extract data from a limited number of tables. 
D) Does not allow conditions to be put on the query. 
A) Isolates data within tables. 
B) Takes advantage of the primary record key to link tables. 
C) Is a complex language used to extract data from a limited number of tables. 
D) Does not allow conditions to be put on the query.

Question 20

Information is the:

Accepted Answer

A) Interpretation of data that have been processed. 
B) Set of facts collected from transactions. 
C) Set of facts pertaining to accounts payable. 
D) Set of facts pertaining to accounts receivable. 
A) Interpretation of data that have been processed. 
B) Set of facts collected from transactions. 
C) Set of facts pertaining to accounts payable. 
D) Set of facts pertaining to accounts receivable.

Data is

If a company stores data in separate files in its different departmental locations and is able to update all files simultaneously, it would not have problems with

Direct access:

Data mining:

Potential variations in conditions that are used to understand interactions between different parts of the business is referred to as:

Real-time processing:

OLAP tools include all of the following EXCEPT:

Advantages of distributed databases include all EXCEPT:

Describe the difference between a data warehouse and an operational data base.Also explain how data is added or changed within these two types of databases.

(Magnetic) Disk storage is:

The additive characteristic means:

A field is a (n):

Which of the following is false with regard to proper data analysis of data warehouse files:

Volume refers to:

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

A set of small databases where data are collected, processed, and stored on multiple computers within a network is a:

When a company buys data storage from a cloud provider, the arrangement is referred to as:

A character is to a field as

Structured query language (SQL):

Information is the:

Introduction to AIS

Foundational Concepts of the AIS

Fraud, Ethics, and Internal Control

Internal Controls and Risks in IT Systems

IT Governance

Enterprise Resource Planning ERP Systems

Auditing Information Technology-Based Processes

Revenue and Cash Collection Processes and Controls

Expenditures Processes and Controlspurchases

Expenditures Processes and Controlspayroll and Fixed Assets

Conversion Processes and Controls

Administrative Processes and Controls

E-Commerce and E-Business

Filters

Exam 13: Data and Databases

Data is

If a company stores data in separate files in its different departmental locations and is able to update all files simultaneously, it would not have problems with

Direct access:

Data mining:

Potential variations in conditions that are used to understand interactions between different parts of the business is referred to as:

Real-time processing:

OLAP tools include all of the following EXCEPT:

Advantages of distributed databases include all EXCEPT:

Describe the difference between a data warehouse and an operational data base.Also explain how data is added or changed within these two types of databases.

(Magnetic) Disk storage is:

The additive characteristic means:

A field is a (n):

Which of the following is false with regard to proper data analysis of data warehouse files:

Volume refers to:

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

A set of small databases where data are collected, processed, and stored on multiple computers within a network is a:

When a company buys data storage from a cloud provider, the arrangement is referred to as:

A character is to a field as

Structured query language (SQL):

Information is the:

Introduction to AIS

Foundational Concepts of the AIS

Fraud, Ethics, and Internal Control

Internal Controls and Risks in IT Systems

IT Governance

Enterprise Resource Planning ERP Systems

Auditing Information Technology-Based Processes

Revenue and Cash Collection Processes and Controls

Expenditures Processes and Controlspurchases

Expenditures Processes and Controlspayroll and Fixed Assets

Conversion Processes and Controls

Administrative Processes and Controls

E-Commerce and E-Business

Filters