Question 1

Direct access:

Accepted Answer

A) Means no passwords are required to access data items in a database. 
B) Is the same as sequential access. 
C) Is the same as random access. 
D) Is the process used by magnetic tape storage medium. 
A) Means no passwords are required to access data items in a database. 
B) Is the same as sequential access. 
C) Is the same as random access. 
D) Is the process used by magnetic tape storage medium.

Question 2

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 3

Data must be collected to complete a transaction such as a sale.

Accepted Answer

A) True 
 B)False

Question 4

Batch Processing correlates mostly to which of the following data storage techniques?

Accepted Answer

A) Sequential Access 
B) Random Access 
C) Database processing 
D) None of the Above 
A) Sequential Access 
B) Random Access 
C) Database processing 
D) None of the Above

Question 5

Select the true statement from those provided below.

Accepted Answer

A) Managers use much the same data as operational departments to manage the organization. 
B) All users, managers, sales, production, utilize the features of a data warehouse equally. 
C) Data warehouses are isolated to protect operational information from unauthorized access. 
D) Managers require access to historical data this is generally not available to other individuals. 
A) Managers use much the same data as operational departments to manage the organization. 
B) All users, managers, sales, production, utilize the features of a data warehouse equally. 
C) Data warehouses are isolated to protect operational information from unauthorized access. 
D) Managers require access to historical data this is generally not available to other individuals.

Question 6

In distributed data processing DDP) and distributed databases DDB), the processing and the databases are dispersed to different locations of the organization.

Accepted Answer

A) True 
 B)False

Question 7

Magnetic tape storage medium allows:

Accepted Answer

A) Sequential access storage with random data processing. 
B) Random access storage with random data processing. 
C) Batch access storage with random data processing. 
D) Sequential access storage with sequential data processing. 
A) Sequential access storage with random data processing. 
B) Random access storage with random data processing. 
C) Batch access storage with random data processing. 
D) Sequential access storage with sequential data processing.

Question 8

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 9

Random access means that you are searching for specific data but do not know where it is within the database.

Accepted Answer

A) True 
 B)False

Question 10

A set of small databases where data are collected, processed, and stored on multiple computers within a network is a:

Accepted Answer

A) Centralized database. 
B) Distributed database. 
C) Flat file database. 
D) High-impact process. 
A) Centralized database. 
B) Distributed database. 
C) Flat file database. 
D) High-impact process.

Question 11

Data mining is the process of searching an operational database for identifiable patterns in the data.

Accepted Answer

A) True 
 B)False

Question 12

Random 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 placed into the system, not alphabetically. 
D) All data items must be read in alphabetical order, not in the order they were placed in 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 placed into the system, not alphabetically. 
D) All data items must be read in alphabetical order, not in the order they were placed in the system.

Question 13

A company's database contains three types of records: vendors, parts, and purchasing.The vendor records include the vendor number, name, address, and terms.The parts records include part numbers, name, description, and warehouse location.Purchasing records include purchase numbers, vendor numbers which reference the vendor record), part numbers which reference the parts record), and quantity.What structure of database is being used?

Accepted Answer

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

Question 14

The reasons to store customer names, addresses, and other similar information include all but:

Accepted Answer

A) To follow up with the customer. 
B) To create financial reports. 
C) To expedite future orders. 
D) To ease the customer's follow-on ordering processes. 
A) To follow up with the customer. 
B) To create financial reports. 
C) To expedite future orders. 
D) To ease the customer's follow-on ordering processes.

Question 15

The customer company, who uses a cloud provides, must have some IT structure to access and use the data stored in a cloud.

Accepted Answer

A) True 
 B)False

Question 16

Data mining:

Accepted Answer

A) Searches for random patterns. 
B) Searches for patterns in the operational database. 
C) Results will not generally predict customer preferences. 
D) Analyzes past patterns to predict future events. 
A) Searches for random patterns. 
B) Searches for patterns in the operational database. 
C) Results will not generally predict customer preferences. 
D) Analyzes past patterns to predict future events.

Question 17

In this type of distributed system, each computer or process on the network is either a Client or a server.

Accepted Answer

A) Distributed Data Processing 
B) Client / Server System 
C) Online Analytical Processing 
D) Distributed Database System 
A) Distributed Data Processing 
B) Client / Server System 
C) Online Analytical Processing 
D) Distributed Database System

Question 18

An example of unstructured data would be customer telephone numbers.

Accepted Answer

A) True 
 B)False

Question 19

A data warehouse is a temperature controlled building where files and records are retained.

Accepted Answer

A) True 
 B)False

Question 20

Appropriate information for a medical facility would NOT include:

Accepted Answer

A) Social Security number. 
B) Health insurance company. 
C) Next of kin notification information. 
D) Personal spending habits. 
A) Social Security number. 
B) Health insurance company. 
C) Next of kin notification information. 
D) Personal spending habits.

Direct access:

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

Data must be collected to complete a transaction such as a sale.

Batch Processing correlates mostly to which of the following data storage techniques?

Select the true statement from those provided below.

In distributed data processing DDP) and distributed databases DDB), the processing and the databases are dispersed to different locations of the organization.

Magnetic tape storage medium allows:

Uploading data is putting:

Random access means that you are searching for specific data but do not know where it is within the database.

A set of small databases where data are collected, processed, and stored on multiple computers within a network is a:

Data mining is the process of searching an operational database for identifiable patterns in the data.

Random access means:

The reasons to store customer names, addresses, and other similar information include all but:

The customer company, who uses a cloud provides, must have some IT structure to access and use the data stored in a cloud.

Data mining:

In this type of distributed system, each computer or process on the network is either a Client or a server.

An example of unstructured data would be customer telephone numbers.

A data warehouse is a temperature controlled building where files and records are retained.

Appropriate information for a medical facility would NOT include:

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

Direct access:

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

Data must be collected to complete a transaction such as a sale.

Batch Processing correlates mostly to which of the following data storage techniques?

Select the true statement from those provided below.

In distributed data processing DDP) and distributed databases DDB), the processing and the databases are dispersed to different locations of the organization.

Magnetic tape storage medium allows:

Uploading data is putting:

Random access means that you are searching for specific data but do not know where it is within the database.

A set of small databases where data are collected, processed, and stored on multiple computers within a network is a:

Data mining is the process of searching an operational database for identifiable patterns in the data.

Random access means:

The reasons to store customer names, addresses, and other similar information include all but:

The customer company, who uses a cloud provides, must have some IT structure to access and use the data stored in a cloud.

Data mining:

In this type of distributed system, each computer or process on the network is either a Client or a server.

An example of unstructured data would be customer telephone numbers.

A data warehouse is a temperature controlled building where files and records are retained.

Appropriate information for a medical facility would NOT include:

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