Question 1

Select the false statement from those provided.

Accepted Answer

A) Batch processing attains a greater efficiency than real-time processing for large amounts of data items. 
B) Batch processing has a faster response time than real-time processing due to the grouping of like data items. 
C) Batch processing should be utilized for payroll type processes as it groups these similar data items. 
D) Real-time data processing has more complex audit trails for data items than batch processing. 
A) Batch processing attains a greater efficiency than real-time processing for large amounts of data items. 
B) Batch processing has a faster response time than real-time processing due to the grouping of like data items. 
C) Batch processing should be utilized for payroll type processes as it groups these similar data items. 
D) Real-time data processing has more complex audit trails for data items than batch processing.

Question 2

SQL stands for Sequential Query Language.

Accepted Answer

A) True 
 B)False

Question 3

A file is a:

Accepted Answer

A) Set of characters. 
B) Column within a record. 
C) Row within a record. 
D) Collection of related records. 
A) Set of characters. 
B) Column within a record. 
C) Row within a record. 
D) Collection of related records.

Question 4

Scalability is one of the advantages of cloud-based databases.What this means is that as the company grows, they can easily purchase new capacity from the cloud provider.

Accepted Answer

A) True 
 B)False

Question 5

Data processing and storage:

Accepted Answer

A) Must be kept centralized for control and security. 
B) Must be distributed for control and security. 
C) Can be distributed to meet organizational requirements. 
D) Must be kept centralized for efficient operations. 
A) Must be kept centralized for control and security. 
B) Must be distributed for control and security. 
C) Can be distributed to meet organizational requirements. 
D) Must be kept centralized for efficient operations.

Question 6

High-impact processes HIPs) are:

Accepted Answer

A) Critical to the short-term objectives of the organization. 
B) Only associated with events such as sales and collections. 
C) Identified and established by single-functional teams. 
D) Critical to the long-term objectives of the organization. 
A) Critical to the short-term objectives of the organization. 
B) Only associated with events such as sales and collections. 
C) Identified and established by single-functional teams. 
D) Critical to the long-term objectives of the organization.

Question 7

Data within the data warehouse is:

Accepted Answer

A) Volatile - its release is restricted and potentially hazardous to the organization. 
B) Volatile - it may be deleted by specific users. 
C) Nonvolatile - it does not change rapidly. 
D) Nonvolatile - is protected against deletion. 
A) Volatile - its release is restricted and potentially hazardous to the organization. 
B) Volatile - it may be deleted by specific users. 
C) Nonvolatile - it does not change rapidly. 
D) Nonvolatile - is protected against deletion.

Question 8

A character is a single letter, number, or symbol.

Accepted Answer

A) True 
 B)False

Question 9

Within are relational database a record may have more than one primary key.

Accepted Answer

A) True 
 B)False

Question 10

Select the false statement from the following.

Accepted Answer

A) A character is a single letter, number, or symbol. 
B) A field is a set of characters. 
C) A field can be thought of as a column of data. 
D) A file is the entire set of fields 
A) A character is a single letter, number, or symbol. 
B) A field is a set of characters. 
C) A field can be thought of as a column of data. 
D) A file is the entire set of fields

Question 11

Database management systems are categorized by the data structures they support.In which type of database management system is the data arranged in a series of tables?

Accepted Answer

A) Network 
B) Hierarchical 
C) Relational 
D) Sequential 
A) Network 
B) Hierarchical 
C) Relational 
D) Sequential

Question 12

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 13

Automatic integrated backup

Accepted Answer

A) May create problems because a single site's data may be at multiple locations. 
B) May create problems because backups at multiple sites may have hardware differences. 
C) At remote sites may not all be the same configuration as the central configuration. 
D) All of the above are correct. 
A) May create problems because a single site's data may be at multiple locations. 
B) May create problems because backups at multiple sites may have hardware differences. 
C) At remote sites may not all be the same configuration as the central configuration. 
D) All of the above are correct.

Question 14

Which of the following best describes the relationship between data and information?

Accepted Answer

A) Data are interpreted information. 
B) Information is interpreted data. 
C) Data are more useful than information in decision making. 
D) Data and information are not related. 
A) Data are interpreted information. 
B) Information is interpreted data. 
C) Data are more useful than information in decision making. 
D) Data and information are not related.

Question 15

Standardizing data:

Accepted Answer

A) Configures all of the data from one department into a single database for analysis. 
B) Configures all of the data from numerous departments into a single data configuration. 
C) Is not required within relational databases. 
D) Requires sales to keep its own files and references apart from marketing example). 
A) Configures all of the data from one department into a single database for analysis. 
B) Configures all of the data from numerous departments into a single data configuration. 
C) Is not required within relational databases. 
D) Requires sales to keep its own files and references apart from marketing example).

Question 16

Data normalization allows repeating groups such as the same vendor name in multiple locations of the primary key field of the same table.

Accepted Answer

A) True 
 B)False

Question 17

A cloud provider generally provides only the data storage space.

Accepted Answer

A) True 
 B)False

Question 18

A record is:

Accepted Answer

A) An entire set of fields for a specific entity. 
B) A series of characters. 
C) A collection of files. 
D) Another name for a database. 
A) An entire set of fields for a specific entity. 
B) A series of characters. 
C) A collection of files. 
D) Another name for a database.

Question 19

Ethical issues related to data utilization are not a consideration for data collection.

Accepted Answer

A) True 
 B)False

Question 20

Proper IT controls will NOT:

Accepted Answer

A) Prevent a hacker from penetrating the firewall. 
B) Prevent an unauthorized user from using the computer systems. 
C) Restrict employee access to any information. 
D) Prevent an employee from sharing his password. 
A) Prevent a hacker from penetrating the firewall. 
B) Prevent an unauthorized user from using the computer systems. 
C) Restrict employee access to any information. 
D) Prevent an employee from sharing his password.

Select the false statement from those provided.

SQL stands for Sequential Query Language.

A file is a:

Scalability is one of the advantages of cloud-based databases.What this means is that as the company grows, they can easily purchase new capacity from the cloud provider.

Data processing and storage:

High-impact processes HIPs) are:

Data within the data warehouse is:

A character is a single letter, number, or symbol.

Within are relational database a record may have more than one primary key.

Select the false statement from the following.

Database management systems are categorized by the data structures they support.In which type of database management system is the data arranged in a series of tables?

Real-time processing:

Automatic integrated backup

Which of the following best describes the relationship between data and information?

Standardizing data:

Data normalization allows repeating groups such as the same vendor name in multiple locations of the primary key field of the same table.

A cloud provider generally provides only the data storage space.

A record is:

Ethical issues related to data utilization are not a consideration for data collection.

Proper IT controls will NOT:

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

Select the false statement from those provided.

SQL stands for Sequential Query Language.

A file is a:

Scalability is one of the advantages of cloud-based databases.What this means is that as the company grows, they can easily purchase new capacity from the cloud provider.

Data processing and storage:

High-impact processes HIPs) are:

Data within the data warehouse is:

A character is a single letter, number, or symbol.

Within are relational database a record may have more than one primary key.

Select the false statement from the following.

Database management systems are categorized by the data structures they support.In which type of database management system is the data arranged in a series of tables?

Real-time processing:

Automatic integrated backup

Which of the following best describes the relationship between data and information?

Standardizing data:

Data normalization allows repeating groups such as the same vendor name in multiple locations of the primary key field of the same table.

A cloud provider generally provides only the data storage space.

A record is:

Ethical issues related to data utilization are not a consideration for data collection.

Proper IT controls will NOT:

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