Question 1

Which of the following statements is true regarding an operational database?

Accepted Answer

A) An operational database is an integrated collection of enterprise-wide data that includes 5 to 10 years of nonvolatile data. 
B) An operational database includes data for the current fiscal year and supports day-to-day operations and record keeping for the transaction processing system. 
C) An operational database includes data from the past 5 to 10 years and supports day-to-day operations and record keeping for the transaction processing system. 
D) None of the above statements are true. 
A) An operational database is an integrated collection of enterprise-wide data that includes 5 to 10 years of nonvolatile data. 
B) An operational database includes data for the current fiscal year and supports day-to-day operations and record keeping for the transaction processing system. 
C) An operational database includes data from the past 5 to 10 years and supports day-to-day operations and record keeping for the transaction processing system. 
D) None of the above statements are true. B

Question 2

Drill down within OLAP is:

Accepted Answer

A) Identifying trends in the comparison of data in several databases. 
B) The aggregation or collection of similar data from several databases. 
C) The presentation of variances from the expected in dollar value. 
D) Is the successive expansion of data as lower levels of data are exposed. 
A) Identifying trends in the comparison of data in several databases. 
B) The aggregation or collection of similar data from several databases. 
C) The presentation of variances from the expected in dollar value. 
D) Is the successive expansion of data as lower levels of data are exposed. D

Question 3

Select the correct statement from those provided below.

Accepted Answer

A) If batch processing is selected due to payroll and production type processing mandates, the entire system must be batch processing. 
B) If real-time processing is selected due to sales and inventory type processing mandates, the entire system must be real-time processing. 
C) If sales and inventory are real-time, payroll and production may be batch processing in a well-designed system. 
D) Because sales are frequently shipped out of warehouses, sales, inventory, and payroll are all good candidates for batch processing concepts. 
A) If batch processing is selected due to payroll and production type processing mandates, the entire system must be batch processing. 
B) If real-time processing is selected due to sales and inventory type processing mandates, the entire system must be real-time processing. 
C) If sales and inventory are real-time, payroll and production may be batch processing in a well-designed system. 
D) Because sales are frequently shipped out of warehouses, sales, inventory, and payroll are all good candidates for batch processing concepts. C

Question 4

Database management systems, DBMS, is are):

Accepted Answer

A) Software that manages a database and controls access and use of data 
B) Printed policies about the use and access to data. 
C) Systems which require each user to create his own master data file. 
D) Systems that allow unlimited access to the data files by all users. 
A) Software that manages a database and controls access and use of data 
B) Printed policies about the use and access to data. 
C) Systems which require each user to create his own master data file. 
D) Systems that allow unlimited access to the data files by all users.

Question 5

Advantages of distributed databases include all EXCEPT:

Accepted Answer

A) Easier incremental growth. 
B) Multiple site access for processing. 
C) Decreased user involvement. 
D) Increased user control. 
A) Easier incremental growth. 
B) Multiple site access for processing. 
C) Decreased user involvement. 
D) Increased user control.

Question 6

With a client/server system all processing is done on the server.

Accepted Answer

A) True 
 B)False

Question 7

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.
TEST BANK - CHAPTER 13 - TRUE / FALSE 
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.
TEST BANK - CHAPTER 13 - TRUE / FALSE

Question 8

A bank would consider which of the following as nonprivate information?

Accepted Answer

A) Customer name. 
B) Customer address if the customer is a business. 
C) Customer phone number if it is listed number. 
D) All of the above, A, B, and C, are private and privileged types of information. 
A) Customer name. 
B) Customer address if the customer is a business. 
C) Customer phone number if it is listed number. 
D) All of the above, A, B, and C, are private and privileged types of information.

Question 9

The amount of IT structure maintained by a client would not change if the database is stored with a cloud provider rather than onsite.

Accepted Answer

A) True 
 B)False

Question 10

OLAP tools include all of the following EXCEPT:

Accepted Answer

A) Consolidation. 
B) Inclusion reports. 
C) Exception reports. 
D) What if simulations. 
A) Consolidation. 
B) Inclusion reports. 
C) Exception reports. 
D) What if simulations.

Question 11

Each of the following is an online privacy practice recommended by the AICPA Trust Services Principles Privacy Framework except:

Accepted Answer

A) Redundant data should be eliminated from the database. 
B) Notification of privacy policies should be given to customers. 
C) Private information should not be given to third parties without the customer's consent. 
D) All of the above.
TEST BANK - CHAPTER 13 - MULTIPLE CHOICE 
A) Redundant data should be eliminated from the database. 
B) Notification of privacy policies should be given to customers. 
C) Private information should not be given to third parties without the customer's consent. 
D) All of the above.
TEST BANK - CHAPTER 13 - MULTIPLE CHOICE

Question 12

Magnetic) Disk storage is:

Accepted Answer

A) Preferred over magnetic tape storage. 
B) Sequential access. 
C) Not random access. 
D) Not direct access. 
A) Preferred over magnetic tape storage. 
B) Sequential access. 
C) Not random access. 
D) Not direct access.

Question 13

A database is a n):

Accepted Answer

A) Set of characters. 
B) Row within a file. 
C) Collection of related records. 
D) Entire set of files. 
A) Set of characters. 
B) Row within a file. 
C) Collection of related records. 
D) Entire set of files.

Question 14

If real-time processing is to occur, database records must be stored on random access media.

Accepted Answer

A) True 
 B)False

Question 15

Random access means that any data item on the storage media can be directly accessed without reading in sequence.

Accepted Answer

A) True 
 B)False

Question 16

Data mining would be useful in all of the following situations except

Accepted Answer

A) Identifying hidden patterns in customers' buying habits. 
B) Assessing customer reactions to new products. 
C) Determining customers' behavior patterns. 
D) Accessing customers' payment histories. 
A) Identifying hidden patterns in customers' buying habits. 
B) Assessing customer reactions to new products. 
C) Determining customers' behavior patterns. 
D) Accessing customers' payment histories.

Question 17

An entire record forms a "database."

Accepted Answer

A) True 
 B)False

Question 18

A field is a:

Accepted Answer

A) Row within a record. 
B) Column within a record. 
C) Series or collection of records. 
D) Character is a single letter, number, or symbol. 
A) Row within a record. 
B) Column within a record. 
C) Series or collection of records. 
D) Character is a single letter, number, or symbol.

Question 19

Real-time data item processing is more complex because:

Accepted Answer

A) It must utilize sequential storage medium. 
B) It must group data items together before processing. 
C) The slower response times indicate more systems activity. 
D) There is duplication of effort in processing transactions. 
A) It must utilize sequential storage medium. 
B) It must group data items together before processing. 
C) The slower response times indicate more systems activity. 
D) There is duplication of effort in processing transactions.

Question 20

Distributed data processing and databases:

Accepted Answer

A) May require management to enforce hardware and software configuration policies. 
B) Make hardware and software configuration easier as local assets can be utilized. 
C) Ease security concerns as remote systems are not required to maintain connectivity. 
D) All of the above are correct. 
A) May require management to enforce hardware and software configuration policies. 
B) Make hardware and software configuration easier as local assets can be utilized. 
C) Ease security concerns as remote systems are not required to maintain connectivity. 
D) All of the above are correct.

Which of the following statements is true regarding an operational database?

Drill down within OLAP is:

Select the correct statement from those provided below.

Database management systems, DBMS, is are):

Advantages of distributed databases include all EXCEPT:

With a client/server system all processing is done on the server.

Ethical responsibilities are shared by:

A bank would consider which of the following as nonprivate information?

The amount of IT structure maintained by a client would not change if the database is stored with a cloud provider rather than onsite.

OLAP tools include all of the following EXCEPT:

Each of the following is an online privacy practice recommended by the AICPA Trust Services Principles Privacy Framework except:

Magnetic) Disk storage is:

A database is a n):

If real-time processing is to occur, database records must be stored on random access media.

Random access means that any data item on the storage media can be directly accessed without reading in sequence.

Data mining would be useful in all of the following situations except

An entire record forms a "database."

A field is a:

Real-time data item processing is more complex because:

Distributed data processing and databases:

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

Which of the following statements is true regarding an operational database?

Drill down within OLAP is:

Select the correct statement from those provided below.

Database management systems, DBMS, is are):

Advantages of distributed databases include all EXCEPT:

With a client/server system all processing is done on the server.

Ethical responsibilities are shared by:

A bank would consider which of the following as nonprivate information?

The amount of IT structure maintained by a client would not change if the database is stored with a cloud provider rather than onsite.

OLAP tools include all of the following EXCEPT:

Each of the following is an online privacy practice recommended by the AICPA Trust Services Principles Privacy Framework except:

Magnetic) Disk storage is:

A database is a n):

If real-time processing is to occur, database records must be stored on random access media.

Random access means that any data item on the storage media can be directly accessed without reading in sequence.

Data mining would be useful in all of the following situations except

An entire record forms a "database."

A field is a:

Real-time data item processing is more complex because:

Distributed data processing and databases:

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