Question 1

Database security includes all EXCEPT:

Accepted Answer

A) Password protection. 
B) Encryption 
C) LAN structure. 
D) Firewalls. 
A) Password protection. 
B) Encryption 
C) LAN structure. 
D) Firewalls. C

Question 2

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

Question 3

Data redundancy occurs:

Accepted Answer

A) When shared databases are utilized. 
B) When inventory has the same data in its files as sales has in its files. 
C) When customer addresses are needed by both shipping and billing. 
D) In all properly designed database management systems. 
A) When shared databases are utilized. 
B) When inventory has the same data in its files as sales has in its files. 
C) When customer addresses are needed by both shipping and billing. 
D) In all properly designed database management systems. B

Question 4

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.

Question 5

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 6

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

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 answers are correct. 
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 answers are correct.

Question 9

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 10

Batch processing:

Accepted Answer

A) Occurs when dissimilar transactions are grouped and processed as a group. 
B) Occurs when similar transactions are grouped together and processed as a group. 
C) Occurs when the transaction is processed as soon as it is entered. 
D) Would not be used for payment to vendor type transactions since they are time sensitive. 
A) Occurs when dissimilar transactions are grouped and processed as a group. 
B) Occurs when similar transactions are grouped together and processed as a group. 
C) Occurs when the transaction is processed as soon as it is entered. 
D) Would not be used for payment to vendor type transactions since they are time sensitive.

Question 11

A flat file database has:

Accepted Answer

A) The ability to call necessary information from linked databases. 
B) Two dimensions, rows and depth. 
C) Only columns. 
D) Two dimensions, rows and columns. 
A) The ability to call necessary information from linked databases. 
B) Two dimensions, rows and depth. 
C) Only columns. 
D) Two dimensions, rows and columns.

Question 12

Structured data:

Accepted Answer

A) Includes data collected from transactions 
B) Easily fit into rows and columns 
C) Include accounting data 
D) All of the answers are true of structured data 
A) Includes data collected from transactions 
B) Easily fit into rows and columns 
C) Include accounting data 
D) All of the answers are true of structured data

Question 13

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 14

Data reveal relationships between records.These can be thought of as:

Accepted Answer

A) One-to-one relationships. 
B) Many-to-many relationships. 
C) One-to-many relationships. 
D) All are examples of relationships. 
A) One-to-one relationships. 
B) Many-to-many relationships. 
C) One-to-many relationships. 
D) All are examples of relationships.

Question 15

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 16

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

Accepted Answer

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

Question 17

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 18

In database terminology, columns are also called:

Accepted Answer

A) Primary keys 
B) Record pointers 
C) Attributes 
D) Flat files 
A) Primary keys 
B) Record pointers 
C) Attributes 
D) Flat files

Question 19

Hierarchical databases are NOT:

Accepted Answer

A) Inverted tree structures. 
B) One-to-one relationships. 
C) One-to-many relationships. 
D) Many-to-one relationships. 
A) Inverted tree structures. 
B) One-to-one relationships. 
C) One-to-many relationships. 
D) Many-to-one relationships.

Question 20

Automatic integrated backup means:

Accepted Answer

A) That each site must accomplish its own backup. 
B) One site may backup sites it does not normally support. 
C) If data is lost at one site it may be available from another site. 
D) All of the answers are correct. 
A) That each site must accomplish its own backup. 
B) One site may backup sites it does not normally support. 
C) If data is lost at one site it may be available from another site. 
D) All of the answers are correct.

Database security includes all EXCEPT:

A field is a:

Data redundancy occurs:

Select the correct statement from those provided below.

Database management systems, DBMS, is (are):

Magnetic tape storage medium allows:

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

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

Batch processing:

A flat file database has:

Structured data:

Select the true statement from those provided.

Data reveal relationships between records.These can be thought of as:

OLAP tools include all of the following EXCEPT:

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

Advantages of distributed databases include all EXCEPT:

In database terminology, columns are also called:

Hierarchical databases are NOT:

Automatic integrated backup means:

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

Database security includes all EXCEPT:

A field is a:

Data redundancy occurs:

Select the correct statement from those provided below.

Database management systems, DBMS, is (are):

Magnetic tape storage medium allows:

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

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

Batch processing:

A flat file database has:

Structured data:

Select the true statement from those provided.

Data reveal relationships between records.These can be thought of as:

OLAP tools include all of the following EXCEPT:

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

Advantages of distributed databases include all EXCEPT:

In database terminology, columns are also called:

Hierarchical databases are NOT:

Automatic integrated backup means:

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