Question 1

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 2

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 3

Select the true statement from those provided below.

Accepted Answer

A) The data warehouse has five to ten years of data while the operational database has current year data. 
B) The data warehouse has current year data while the operational database has five to ten years of data. 
C) The data warehouse archives both current and long-term, five to ten years of data, within its storage. 
D) The data warehouse contains only general ledger type information while the operational database has detail. 
A) The data warehouse has five to ten years of data while the operational database has current year data. 
B) The data warehouse has current year data while the operational database has five to ten years of data. 
C) The data warehouse archives both current and long-term, five to ten years of data, within its storage. 
D) The data warehouse contains only general ledger type information while the operational database has detail.

Question 4

Ethical issues associated with data collection and storage include all of the following EXCEPT:

Accepted Answer

A) Collecting only the necessary information for the transaction. 
B) Selling non-sensitive information only to trusted agents. 
C) Correcting errors in data as quickly as possible. 
D) Precluding unnecessary access of customer data by employees. 
A) Collecting only the necessary information for the transaction. 
B) Selling non-sensitive information only to trusted agents. 
C) Correcting errors in data as quickly as possible. 
D) Precluding unnecessary access of customer data by employees.

Question 5

An example of a one-to-one relationship would be:

Accepted Answer

A) One employee, three timecards for the pay period. 
B) One customer, one billing address. 
C) One customer, four shipping addresses. 
D) Two employees, one skill set. 
A) One employee, three timecards for the pay period. 
B) One customer, one billing address. 
C) One customer, four shipping addresses. 
D) Two employees, one skill set.

Question 6

Storage media and methods of processing are:

Accepted Answer

A) Sequential and random access storage with random and batch data processing. 
B) Sequential and real time access storage with batch and real time data processing. 
C) Batch and random access storage with random and batch data processing. 
D) Sequential and random access storage with batch and real time data processing. 
A) Sequential and random access storage with random and batch data processing. 
B) Sequential and real time access storage with batch and real time data processing. 
C) Batch and random access storage with random and batch data processing. 
D) Sequential and random access storage with batch and real time data processing.

Question 7

Examples of data collection events are

Accepted Answer

A) Transactions that fill customer orders. 
B) Transactions to replenish inventory. 
C) Neither are examples of data collection. 
D) Both answers are examples of data collection. 
A) Transactions that fill customer orders. 
B) Transactions to replenish inventory. 
C) Neither are examples of data collection. 
D) Both answers are examples of data collection.

Question 8

When the data contained in a database are stored in large, two-dimensional tables, the database is referred to as a

Accepted Answer

A) Flat file database. 
B) Hierarchical database. 
C) Network database. 
D) Relational database. 
A) Flat file database. 
B) Hierarchical database. 
C) Network database. 
D) Relational database.

Question 9

Select the correct statement from those provided.

Accepted Answer

A) The hierarchal and relational database models are both extremely flexible in their queries. 
B) The hierarchal model is better suited to queries than the relational database model. 
C) The relational database model is more flexible in its queries than the hierarchal mode. 
D) The relational database model has better processing of large volumes of transactions. 
A) The hierarchal and relational database models are both extremely flexible in their queries. 
B) The hierarchal model is better suited to queries than the relational database model. 
C) The relational database model is more flexible in its queries than the hierarchal mode. 
D) The relational database model has better processing of large volumes of transactions.

Question 10

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 11

Hierarchal databases:

Accepted Answer

A) Are effective in retrieving records without explicit linkages. 
B) Are efficient in processing large volumes of transactions with explicit linkages. 
C) Do not require built-in linkages, they can be created with queries. 
D) Do not require record pointers. 
A) Are effective in retrieving records without explicit linkages. 
B) Are efficient in processing large volumes of transactions with explicit linkages. 
C) Do not require built-in linkages, they can be created with queries. 
D) Do not require record pointers.

Question 12

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 13

Select the true statement from the following.

Accepted Answer

A) A character is a single letter only. 
B) A character is a single number only. 
C) A character is a single symbol only. 
D) A character is a single letter, number, or symbol. 
A) A character is a single letter only. 
B) A character is a single number only. 
C) A character is a single symbol only. 
D) A character is a single letter, number, or symbol.

Question 14

Select the correct statement from the following.

Accepted Answer

A) Data redundancy and concurrency are features of well-designed database management systems. 
B) Data redundancy, not concurrency, is a feature of a well-designed database management system. 
C) Concurrency not, data redundancy, is a feature of a well-designed database management system. 
D) Data redundancy and concurrency are not features of well-designed database management systems. 
A) Data redundancy and concurrency are features of well-designed database management systems. 
B) Data redundancy, not concurrency, is a feature of a well-designed database management system. 
C) Concurrency not, data redundancy, is a feature of a well-designed database management system. 
D) Data redundancy and concurrency are not features of well-designed database management systems.

Question 15

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 16

The three major concerns related to database control and security do NOT include:

Accepted Answer

A) Unauthorized access. 
B) Inadequate backup. 
C) Data integrity. 
D) Adequate backup. 
A) Unauthorized access. 
B) Inadequate backup. 
C) Data integrity. 
D) Adequate backup.

Question 17

Tables in a flat file database must:

Accepted Answer

A) Must contain at least two data items at the intersection of each row and column. 
B) Contain similar data throughout the row. 
C) Label all columns the same to maintain the relationships of the rows. 
D) Contain similar data in the column. 
A) Must contain at least two data items at the intersection of each row and column. 
B) Contain similar data throughout the row. 
C) Label all columns the same to maintain the relationships of the rows. 
D) Contain similar data in the column.

Question 18

Processing of a flat file table is:

Accepted Answer

A) Random. 
B) Sequential. 
C) Random or sequential, selectable by the user. 
D) Direct. 
A) Random. 
B) Sequential. 
C) Random or sequential, selectable by the user. 
D) Direct.

Data processing and storage:

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

Select the true statement from those provided below.

Ethical issues associated with data collection and storage include all of the following EXCEPT:

An example of a one-to-one relationship would be:

Storage media and methods of processing are:

Examples of data collection events are

When the data contained in a database are stored in large, two-dimensional tables, the database is referred to as a

Select the correct statement from those provided.

The fastest growing area of IT is:

Hierarchal databases:

Sequential access means:

Select the true statement from the following.

Select the correct statement from the following.

A file is a:

The three major concerns related to database control and security do NOT include:

Tables in a flat file database must:

Processing of a flat file table is:

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 processing and storage:

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

Select the true statement from those provided below.

Ethical issues associated with data collection and storage include all of the following EXCEPT:

An example of a one-to-one relationship would be:

Storage media and methods of processing are:

Examples of data collection events are

When the data contained in a database are stored in large, two-dimensional tables, the database is referred to as a

Select the correct statement from those provided.

The fastest growing area of IT is:

Hierarchal databases:

Sequential access means:

Select the true statement from the following.

Select the correct statement from the following.

A file is a:

The three major concerns related to database control and security do NOT include:

Tables in a flat file database must:

Processing of a flat file table is:

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