Question 1

In today's IT environment:

Accepted Answer

A) Processing speed is compromised for query capability with relational databases. 
B) Query capability is compromised for processing speed with relational databases. 
C) Neither querying nor processing speed need be compromised with relational databases. 
D) Both querying and processing speed are compromised with relational databases. 
A) Processing speed is compromised for query capability with relational databases. 
B) Query capability is compromised for processing speed with relational databases. 
C) Neither querying nor processing speed need be compromised with relational databases. 
D) Both querying and processing speed are compromised with relational databases.

Question 2

A character is a customer, client, or vendor.

Accepted Answer

A) True 
 B)False

Question 3

Batch processing occurs when similar transactions are grouped together, and that group is processed as a batch.

Accepted Answer

A) True 
 B)False

Question 4

Tools commonly used in data mining are OLAP, ROLAP, and MOLAP.

Accepted Answer

A) True 
 B)False

Question 5

Batch processing:

Accepted Answer

A) Occurs when dissimilar transactions are grouped and processed as a group. 
B) Occurs when similar transactions are grouped together and processed as a group. 
C) Occurs when the transaction is processed as soon as it is entered. 
D) Would not be used for payment to vendor type transactions since they are time sensitive. 
A) Occurs when dissimilar transactions are grouped and processed as a group. 
B) Occurs when similar transactions are grouped together and processed as a group. 
C) Occurs when the transaction is processed as soon as it is entered. 
D) Would not be used for payment to vendor type transactions since they are time sensitive.

Question 6

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 7

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 8

A field is a set of characters that fill a space reserved for a particular kind of data.

Accepted Answer

A) True 
 B)False

Question 9

Because of today's computing power and Internet accessibility, there has been a substantial increase in the use of centralized databases and centralized processing.

Accepted Answer

A) True 
 B)False

Question 10

The requirements to frequently or infrequently access data are not relevant to the way that the data is stored due to computer access speed.

Accepted Answer

A) True 
 B)False

Question 11

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 12

Concurrency means that all of the multiple instances of the same data are exactly alike.

Accepted Answer

A) True 
 B)False

Question 13

The organization should institute procedures to insure that all customer data collected retains accuracy, is complete, is current, is relevant, and is reliable".

Accepted Answer

A) True 
 B)False

Question 14

The loss of transaction processing efficiency:

Accepted Answer

A) Is substantial but a necessary trade-off with relational databases. 
B) Is minimized because of the increased computing power available. 
C) Is a primary reason why relational databases are not utilized. 
D) Both B and C are correct. 
A) Is substantial but a necessary trade-off with relational databases. 
B) Is minimized because of the increased computing power available. 
C) Is a primary reason why relational databases are not utilized. 
D) Both B and C are correct.

Question 15

Which of the following correctly orders the hierarchy of data from smallest to largest?

Accepted Answer

A) Field, character, record, file, database 
B) Character, record, field, file, database 
C) File, character, database, field, record 
D) Character, field, record, file, database 
A) Field, character, record, file, database 
B) Character, record, field, file, database 
C) File, character, database, field, record 
D) Character, field, record, file, database

Question 16

When data and processing are distributed across several computers, as occurs in a system of distributed processing, the failure of one site will be harmful and bring down the entire system.

Accepted Answer

A) True 
 B)False

Question 17

The various types of online analytical processing OLAP) does NOT include:

Accepted Answer

A) MOLAP - Multidimensional online analytical processing. 
B) NOLAP - Notational online analytical processing. 
C) ROLAP - Relational online analytical processing. 
D) All of the above, A, B, and C are types of OLAP systems. 
A) MOLAP - Multidimensional online analytical processing. 
B) NOLAP - Notational online analytical processing. 
C) ROLAP - Relational online analytical processing. 
D) All of the above, A, B, and C are types of OLAP systems.

Question 18

Select the true statement from the following:

Accepted Answer

A) Clients are usually workstations that contain data files. 
B) Servers are usually less capable computing power since their function is routing requirements to resources. 
C) Servers may contain shared files and resources. 
D) Servers usually do not control assets such as printers and Internet portals. 
A) Clients are usually workstations that contain data files. 
B) Servers are usually less capable computing power since their function is routing requirements to resources. 
C) Servers may contain shared files and resources. 
D) Servers usually do not control assets such as printers and Internet portals.

Question 19

Magnetic tape is a storage medium that allows only a sequential access type of storage.

Accepted Answer

A) True 
 B)False

Question 20

Select the true statement from the following.

Accepted Answer

A) High-impact processes HIPs) are identified by single-functional teams. 
B) High-impact processes HIPs) and user's needs determine the data in the data warehouse. 
C) High-impact processes HIPs) address both short-term and long-term objectives. 
D) High-impact processes HIPs) determine the long-term strategy of the organization. 
A) High-impact processes HIPs) are identified by single-functional teams. 
B) High-impact processes HIPs) and user's needs determine the data in the data warehouse. 
C) High-impact processes HIPs) address both short-term and long-term objectives. 
D) High-impact processes HIPs) determine the long-term strategy of the organization.

In today's IT environment:

A character is a customer, client, or vendor.

Batch processing occurs when similar transactions are grouped together, and that group is processed as a batch.

Tools commonly used in data mining are OLAP, ROLAP, and MOLAP.

Batch processing:

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

The additive characteristic means:

A field is a set of characters that fill a space reserved for a particular kind of data.

Because of today's computing power and Internet accessibility, there has been a substantial increase in the use of centralized databases and centralized processing.

The requirements to frequently or infrequently access data are not relevant to the way that the data is stored due to computer access speed.

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

Concurrency means that all of the multiple instances of the same data are exactly alike.

The organization should institute procedures to insure that all customer data collected retains accuracy, is complete, is current, is relevant, and is reliable".

The loss of transaction processing efficiency:

Which of the following correctly orders the hierarchy of data from smallest to largest?

When data and processing are distributed across several computers, as occurs in a system of distributed processing, the failure of one site will be harmful and bring down the entire system.

The various types of online analytical processing OLAP) does NOT include:

Select the true statement from the following:

Magnetic tape is a storage medium that allows only a sequential access type of storage.

Select the true statement from the following.

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

In today's IT environment:

A character is a customer, client, or vendor.

Batch processing occurs when similar transactions are grouped together, and that group is processed as a batch.

Tools commonly used in data mining are OLAP, ROLAP, and MOLAP.

Batch processing:

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

The additive characteristic means:

A field is a set of characters that fill a space reserved for a particular kind of data.

Because of today's computing power and Internet accessibility, there has been a substantial increase in the use of centralized databases and centralized processing.

The requirements to frequently or infrequently access data are not relevant to the way that the data is stored due to computer access speed.

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

Concurrency means that all of the multiple instances of the same data are exactly alike.

The organization should institute procedures to insure that all customer data collected retains accuracy, is complete, is current, is relevant, and is reliable".

The loss of transaction processing efficiency:

Which of the following correctly orders the hierarchy of data from smallest to largest?

When data and processing are distributed across several computers, as occurs in a system of distributed processing, the failure of one site will be harmful and bring down the entire system.

The various types of online analytical processing OLAP) does NOT include:

Select the true statement from the following:

Magnetic tape is a storage medium that allows only a sequential access type of storage.

Select the true statement from the following.

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