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

Cleansed or scrubbed data:

Accepted Answer

A) Has had all viruses removed. 
B) Has had all fields standardized. 
C) Has had errors and problems fixed. 
D) Is data that has been stored in the data warehouse. 
A) Has had all viruses removed. 
B) Has had all fields standardized. 
C) Has had errors and problems fixed. 
D) Is data that has been stored in the data warehouse.

Question 3

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 4

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 5

Data normalization:

Accepted Answer

A) Requires repeated groups to be deleted from the same row. 
B) Requires repeated groups to be deleted from the same column. 
C) Allows repeated groups if contained within the column. 
D) Allows repeated rows of information within two or more tables. 
A) Requires repeated groups to be deleted from the same row. 
B) Requires repeated groups to be deleted from the same column. 
C) Allows repeated groups if contained within the column. 
D) Allows repeated rows of information within two or more tables.

Question 6

Each table in a database must meet all of the following conditions EXCEPT:

Accepted Answer

A) Each row must be uniquely named 
B) Items in a column must all be of the same type of data 
C) Each cell at the intersection of a row and column must contain only one data item 
D) Each row must be unique in at least one attribute 
A) Each row must be uniquely named 
B) Items in a column must all be of the same type of data 
C) Each cell at the intersection of a row and column must contain only one data item 
D) Each row must be unique in at least one attribute

Question 7

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 8

Flat file records are:

Accepted Answer

A) Kept in random order. 
B) Kept is sequential order. 
C) Linked to other records by a common attribute. 
D) Interactive and real-time processed. 
A) Kept in random order. 
B) Kept is sequential order. 
C) Linked to other records by a common attribute. 
D) Interactive and real-time processed.

Question 9

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 10

Describe a data warehouse and the purpose.

Accepted Answer

Management often needs data from several

Question 11

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 12

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 13

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 14

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 15

A record pointer is a:

Accepted Answer

A) Column value that relates to all other values in the row. 
B) Column value that points to the next address with the linked attribute. 
C) Row value that points to the next address with the linked attribute. 
D) Link that is only required in one-to-many relationships. 
A) Column value that relates to all other values in the row. 
B) Column value that points to the next address with the linked attribute. 
C) Row value that points to the next address with the linked attribute. 
D) Link that is only required in one-to-many relationships.

Question 16

Uploading data is putting:

Accepted Answer

A) Scrubbed files into the operational database. 
B) Files from each HIP system into the operational database. 
C) Standardized files onto local desktop systems for access. 
D) Files from each HIP system into the data warehouse. 
A) Scrubbed files into the operational database. 
B) Files from each HIP system into the operational database. 
C) Standardized files onto local desktop systems for access. 
D) Files from each HIP system into the data warehouse.

Question 17

Data is becoming more varied and now includes each of the following EXCEPT:

Accepted Answer

A) Text messages. 
B) Photos and videos. 
C) Meetings. 
D) Tweets. 
A) Text messages. 
B) Photos and videos. 
C) Meetings. 
D) Tweets.

Question 18

Ethical responsibilities are shared by:

Accepted Answer

A) Company employees only. 
B) Company employees and management only. 
C) Company employees, IT, and management only. 
D) All concerned including employees, customers, and management. 
A) Company employees only. 
B) Company employees and management only. 
C) Company employees, IT, and management only. 
D) All concerned including employees, customers, and management.

Question 19

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 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.

Select the false statement from those provided.

Cleansed or scrubbed data:

Select the false statement from those provided.

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

Data normalization:

Each table in a database must meet all of the following conditions EXCEPT:

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

Flat file records are:

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

Describe a data warehouse and the purpose.

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

Select the false statement from the following.

High-impact processes (HIPs):

A record is:

A record pointer is a:

Uploading data is putting:

Data is becoming more varied and now includes each of the following EXCEPT:

Ethical responsibilities are shared by:

The prevention of industrial espionage is aided by all EXCEPT:

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

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

Select the false statement from those provided.

Cleansed or scrubbed data:

Select the false statement from those provided.

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

Data normalization:

Each table in a database must meet all of the following conditions EXCEPT:

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

Flat file records are:

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

Describe a data warehouse and the purpose.

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

Select the false statement from the following.

High-impact processes (HIPs):

A record is:

A record pointer is a:

Uploading data is putting:

Data is becoming more varied and now includes each of the following EXCEPT:

Ethical responsibilities are shared by:

The prevention of industrial espionage is aided by all EXCEPT:

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

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