Question 1

Sequential access means:

Accepted Answer

A) All data items in the group must be read but the groups do not need to read in order. 
B) Any data item can be directly accessed without reading in sequence 
C) All data items must be read in the order in which they were placed into the system 
D) All data items must be read in alphabetical/numerical order, but not necessarily the order in which they were placed into the system 
A) All data items in the group must be read but the groups do not need to read in order. 
B) Any data item can be directly accessed without reading in sequence 
C) All data items must be read in the order in which they were placed into the system 
D) All data items must be read in alphabetical/numerical order, but not necessarily the order in which they were placed into the system

Question 2

Data does not need to be stored in most cases.

Accepted Answer

A) True 
 B)False

Question 3

Data redundancy occurs:

Accepted Answer

A) When shared databases are utilized. 
B) When inventory has the same data in its files as sales has in its files. 
C) When customer addresses are needed by both shipping and billing. 
D) In all properly designed database management systems. 
A) When shared databases are utilized. 
B) When inventory has the same data in its files as sales has in its files. 
C) When customer addresses are needed by both shipping and billing. 
D) In all properly designed database management systems.

Question 4

________ is the aggregation or collection of similar data.It is the opposite of drill down in that it takes detailed data and summarizes it into larger groups.

Accepted Answer

A) Pivoting 
B) Consolidation 
C) What-if simulations 
D) Drill up 
A) Pivoting 
B) Consolidation 
C) What-if simulations 
D) Drill up

Question 5

The fastest growing area of IT is:

Accepted Answer

A) Cloud-based database services 
B) Online analytical processing 
C) Distributed data storage 
D) Distributed database processing 
A) Cloud-based database services 
B) Online analytical processing 
C) Distributed data storage 
D) Distributed database processing

Question 6

A record pointer identifies a specific record in a flat database.

Accepted Answer

A) True 
 B)False

Question 7

The advantages of cloud-based computing includes all of the following, EXCEPT:

Accepted Answer

A) Scalability - as the company grows, it can easily purchase additional capacity. 
B) Expanded access - once the data are store in the cloud, it can be accessed by multiple devices form different locations. 
C) Increased infrastructure - the company has more need for servers and data storage. 
D) Cost savings - because of the advantages related to cloud-based computing, there are usually significant cost savings recognized. 
A) Scalability - as the company grows, it can easily purchase additional capacity. 
B) Expanded access - once the data are store in the cloud, it can be accessed by multiple devices form different locations. 
C) Increased infrastructure - the company has more need for servers and data storage. 
D) Cost savings - because of the advantages related to cloud-based computing, there are usually significant cost savings recognized.

Question 8

It is the ethical responsibility of employees:

Accepted Answer

A) To review customer records not associated with their division for errors. 
B) Disclose customer data to related parties 
C) To collect only necessary data from customers 
D) To sell customer data to competitors. 
A) To review customer records not associated with their division for errors. 
B) Disclose customer data to related parties 
C) To collect only necessary data from customers 
D) To sell customer data to competitors.

Question 9

The prevention of industrial espionage is aided by all EXCEPT:

Accepted Answer

A) Password protection 
B) Smart cards. 
C) Federal and state laws. 
D) Encryption of data. 
A) Password protection 
B) Smart cards. 
C) Federal and state laws. 
D) Encryption of data.

Question 10

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.

Question 11

IT general controls assist in preventing unauthorized access while providing adequate backup, and are the responsibility of the user.

Accepted Answer

A) True 
 B)False

Question 12

HIPs, or high-impact processes, are the critically important processes that must be executed correctly if the organization is to survive and thrive.

Accepted Answer

A) True 
 B)False

Question 13

A record is the entire set of fields for a specific entity.

Accepted Answer

A) True 
 B)False

Question 14

Real-time processing occurs when transactions are processed as soon as they are entered.

Accepted Answer

A) True 
 B)False

Question 15

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 16

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 17

Database security includes all EXCEPT:

Accepted Answer

A) Password protection. 
B) Encryption 
C) LAN structure. 
D) Firewalls. 
A) Password protection. 
B) Encryption 
C) LAN structure. 
D) Firewalls.

Question 18

A "Where" condition within a structured query of a relational database:

Accepted Answer

A) Must be limited to a location such as "Warehouse #1." 
B) May establish a requirement where the results are equal to a specific value. 
C) May establish a requirement where the results are not equal to a specific value. 
D) Both B and C are correct. 
A) Must be limited to a location such as "Warehouse #1." 
B) May establish a requirement where the results are equal to a specific value. 
C) May establish a requirement where the results are not equal to a specific value. 
D) Both B and C are correct.

Question 19

Automatic integrated backup means:

Accepted Answer

A) That each site must accomplish its own backup. 
B) One site may backup sites it does not normally support. 
C) If data is lost at one site it may be available from another site. 
D) All of the above are correct. 
A) That each site must accomplish its own backup. 
B) One site may backup sites it does not normally support. 
C) If data is lost at one site it may be available from another site. 
D) All of the above are correct.

Question 20

Which of the following statements is not true with regard to a relational database?

Accepted Answer

A) It is flexible and useful for unplanned, ad hoc queries. 
B) It stores data in tables. 
C) It stores data in a tree formation. 
D) It is maintained on direct access devices. 
A) It is flexible and useful for unplanned, ad hoc queries. 
B) It stores data in tables. 
C) It stores data in a tree formation. 
D) It is maintained on direct access devices.

Sequential access means:

Data does not need to be stored in most cases.

Data redundancy occurs:

________ is the aggregation or collection of similar data.It is the opposite of drill down in that it takes detailed data and summarizes it into larger groups.

The fastest growing area of IT is:

A record pointer identifies a specific record in a flat database.

The advantages of cloud-based computing includes all of the following, EXCEPT:

It is the ethical responsibility of employees:

The prevention of industrial espionage is aided by all EXCEPT:

Information is the:

IT general controls assist in preventing unauthorized access while providing adequate backup, and are the responsibility of the user.

HIPs, or high-impact processes, are the critically important processes that must be executed correctly if the organization is to survive and thrive.

A record is the entire set of fields for a specific entity.

Real-time processing occurs when transactions are processed as soon as they are entered.

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

Data is

Database security includes all EXCEPT:

A "Where" condition within a structured query of a relational database:

Automatic integrated backup means:

Which of the following statements is not true with regard to a relational database?

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

Sequential access means:

Data does not need to be stored in most cases.

Data redundancy occurs:

________ is the aggregation or collection of similar data.It is the opposite of drill down in that it takes detailed data and summarizes it into larger groups.

The fastest growing area of IT is:

A record pointer identifies a specific record in a flat database.

The advantages of cloud-based computing includes all of the following, EXCEPT:

It is the ethical responsibility of employees:

The prevention of industrial espionage is aided by all EXCEPT:

Information is the:

IT general controls assist in preventing unauthorized access while providing adequate backup, and are the responsibility of the user.

HIPs, or high-impact processes, are the critically important processes that must be executed correctly if the organization is to survive and thrive.

A record is the entire set of fields for a specific entity.

Real-time processing occurs when transactions are processed as soon as they are entered.

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

Data is

Database security includes all EXCEPT:

A "Where" condition within a structured query of a relational database:

Automatic integrated backup means:

Which of the following statements is not true with regard to a relational database?

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