Question 1

In centralized data processing the processing and the databases are stored and maintained in a central location.

Accepted Answer

A) True 
 B)False

Question 2

Information is the interpretation of data that have been processed.

Accepted Answer

A) True 
 B)False

Question 3

Magnetic) Disk storage is:

Accepted Answer

A) The same as magnetic tape storage. 
B) Sequential access. 
C) Random access. 
D) Not direct access. 
A) The same as magnetic tape storage. 
B) Sequential access. 
C) Random access. 
D) Not direct access.

Question 4

Data in the data warehouse:

Accepted Answer

A) Is analyzed by data mining. 
B) Is analyzed by SQL. 
C) Is analyzed by analytical processing. 
D) Both A and C are correct. 
A) Is analyzed by data mining. 
B) Is analyzed by SQL. 
C) Is analyzed by analytical processing. 
D) Both A and C are correct.

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

To "drill down" is the process of successive expansion of data into more detail, going from high-level data to successively lower levels of data.

Accepted Answer

A) True 
 B)False

Question 7

A field is a n):

Accepted Answer

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

Question 8

Select the correct statement from the following.

Accepted Answer

A) DDP and DDB require dependable and extensive processing power for large organizations. 
B) Distributed databases can only be accessed by local queries. 
C) Centralized data processing and databases require dependable and extensive processing power for large organizations. 
D) The trend in data processing and databases is towards centralization due to reliable internet access and increased computer power. 
A) DDP and DDB require dependable and extensive processing power for large organizations. 
B) Distributed databases can only be accessed by local queries. 
C) Centralized data processing and databases require dependable and extensive processing power for large organizations. 
D) The trend in data processing and databases is towards centralization due to reliable internet access and increased computer power.

Question 9

An entire set of files is a database.

Accepted Answer

A) True 
 B)False

Question 10

Some of the AICPA trust services principles may include:

Accepted Answer

A) Management, notice, choice & consent, collection, use & retention, detention, and disclosure to third parties. 
B) Management, choice & consent, collection, use & retention, backup, access, disclosure to third parties, and security for privacy. 
C) Choice & consent, collection, use & retention, access, disclosure to third parties, redundancy for privacy, and quality. 
D) Management, choice & consent, use & retention, access, disclosure to third parties, and monitoring & enforcement. 
A) Management, notice, choice & consent, collection, use & retention, detention, and disclosure to third parties. 
B) Management, choice & consent, collection, use & retention, backup, access, disclosure to third parties, and security for privacy. 
C) Choice & consent, collection, use & retention, access, disclosure to third parties, redundancy for privacy, and quality. 
D) Management, choice & consent, use & retention, access, disclosure to third parties, and monitoring & enforcement.

Question 11

A collection of several years' nonvolatile data used to support strategic decision-making is a n)

Accepted Answer

A) Operational database. 
B) Data warehouse. 
C) Data mine. 
D) What-if simulation. 
A) Operational database. 
B) Data warehouse. 
C) Data mine. 
D) What-if simulation.

Question 12

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 13

OLAP tools include all of the following EXCEPT:

Accepted Answer

A) Drill down. 
B) Drill up. 
C) Pivoting. 
D) Time series analysis. 
A) Drill down. 
B) Drill up. 
C) Pivoting. 
D) Time series analysis.

Question 14

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 15

Select the true statement from those provided.

Accepted Answer

A) Batch processing fails to attain the efficiency of real-time processing. 
B) Real-time processing fails to attain the efficiency of batch processing. 
C) Real-time processing is efficient for large groups of similar data. 
D) Real-time processing has less complex audit trails. 
A) Batch processing fails to attain the efficiency of real-time processing. 
B) Real-time processing fails to attain the efficiency of batch processing. 
C) Real-time processing is efficient for large groups of similar data. 
D) Real-time processing has less complex audit trails.

Question 16

When using a SQL query language you are restricted to searching two tables for common values such as Vendor Name.

Accepted Answer

A) True 
 B)False

Question 17

While an employee may have access to privileged information, an example of unethical activities would be a

Accepted Answer

A) Nurse viewing the medications of the next patient. 
B) Car salesman viewing the credit rating of a customer with a car in for warranty repairs. 
C) Manager reviewing the hours worked of an assigned employee. 
D) Warehouseman viewing the availability of materials needed for production. 
A) Nurse viewing the medications of the next patient. 
B) Car salesman viewing the credit rating of a customer with a car in for warranty repairs. 
C) Manager reviewing the hours worked of an assigned employee. 
D) Warehouseman viewing the availability of materials needed for production.

Question 18

Magnetic tape is a form of

Accepted Answer

A) Direct access media. 
B) Random access media. 
C) Sequential access media. 
D) Alphabetical access media. 
A) Direct access media. 
B) Random access media. 
C) Sequential access media. 
D) Alphabetical access media.

Question 19

Advantages of distributed databases include all EXCEPT:

Accepted Answer

A) Reduced hardware costs. 
B) Improved responsiveness. 
C) Eased managerial obligations. 
D) Easier incremental growth. 
A) Reduced hardware costs. 
B) Improved responsiveness. 
C) Eased managerial obligations. 
D) Easier incremental growth.

Question 20

With structured query language SQL):

Accepted Answer

A) One-to-one relationships can be determined. 
B) One-to-many relationships can be determined. 
C) Many-to-one relationships can be determined. 
D) All of the possibilities, A, B, and C, are correct. 
A) One-to-one relationships can be determined. 
B) One-to-many relationships can be determined. 
C) Many-to-one relationships can be determined. 
D) All of the possibilities, A, B, and C, are correct.

In centralized data processing the processing and the databases are stored and maintained in a central location.

Information is the interpretation of data that have been processed.

Magnetic) Disk storage is:

Data in the data warehouse:

Data normalization:

To "drill down" is the process of successive expansion of data into more detail, going from high-level data to successively lower levels of data.

A field is a n):

Select the correct statement from the following.

An entire set of files is a database.

Some of the AICPA trust services principles may include:

A collection of several years' nonvolatile data used to support strategic decision-making is a n)

Storage media and methods of processing are:

OLAP tools include all of the following EXCEPT:

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

Select the true statement from those provided.

When using a SQL query language you are restricted to searching two tables for common values such as Vendor Name.

While an employee may have access to privileged information, an example of unethical activities would be a

Magnetic tape is a form of

Advantages of distributed databases include all EXCEPT:

With structured query language SQL):

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 centralized data processing the processing and the databases are stored and maintained in a central location.

Information is the interpretation of data that have been processed.

Magnetic) Disk storage is:

Data in the data warehouse:

Data normalization:

To "drill down" is the process of successive expansion of data into more detail, going from high-level data to successively lower levels of data.

A field is a n):

Select the correct statement from the following.

An entire set of files is a database.

Some of the AICPA trust services principles may include:

A collection of several years' nonvolatile data used to support strategic decision-making is a n)

Storage media and methods of processing are:

OLAP tools include all of the following EXCEPT:

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

Select the true statement from those provided.

When using a SQL query language you are restricted to searching two tables for common values such as Vendor Name.

While an employee may have access to privileged information, an example of unethical activities would be a

Magnetic tape is a form of

Advantages of distributed databases include all EXCEPT:

With structured query language SQL):

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