Question 1

The ________ handles the link between the way data are physically stored and each user's logical view of that data.

Accepted Answer

A) database management software (DBMS) 
B) database manager 
C) data warehouse 
D) data dictionary 
A) database management software (DBMS) 
B) database manager 
C) data warehouse 
D) data dictionary

Question 2

How do users retrieve data stored in a database?

Accepted Answer

A) by viewing the appropriate data tables 
B) by executing a query 
C) by performing a search 
D) by specifying the primary keys 
A) by viewing the appropriate data tables 
B) by executing a query 
C) by performing a search 
D) by specifying the primary keys

Question 3

Using the database depicted above,how many primary keys are in the database?

Accepted Answer

A) 0 
B) 3 
C) 4 
D) 5 
A) 0 
B) 3 
C) 4 
D) 5

Question 4

What are the basic requirements when logically designing a relational database model?

Accepted Answer

Every row in every table must have a uni

Question 5

Emma Kolb is a system analyst at a manufacturing company located in the Midwest.She has been asked to analyze the company's accounting information system and to recommend cost-effective improvements.After noting that the production and sales departments use database systems that are entirely separated,she recommends that they be combined.Implementation of her recommendation would benefit the company by contributing to data

Accepted Answer

A) independence. 
B) integration. 
C) redundancy. 
D) qualifications. 
A) independence. 
B) integration. 
C) redundancy. 
D) qualifications.

Question 6

The technique of using queries to investigate hypothesized relationships among data is called

Accepted Answer

A) business intelligence. 
B) online analytical processing. 
C) data analysis. 
D) data mining. 
A) business intelligence. 
B) online analytical processing. 
C) data analysis. 
D) data mining.

Question 7

Which one of the following results corresponds to the query below?

Accepted Answer

A) 
  
B) 
  
C) 
  
D) 
  
A) 
  
B) 
  
C) 
  
D)

Question 8

If a national sales tax were implemented,which language would be used to add a new field in the sales table to track the sales tax due?

Accepted Answer

A) Data Definition Language 
B) Data Manipulation Language 
C) Data Query Language 
D) Data Update Language 
A) Data Definition Language 
B) Data Manipulation Language 
C) Data Query Language 
D) Data Update Language

Question 9

Helen Fume is a recruiter with The Ladders in Nome,Alaska.The Ladders success is largely attributable to its accounting information system.When a client is hired by an employer,Helen creates a record that identifies the employment relationship.Helen follows up on placements by surveying both employers and clients about the employment experience and then entering the results into the AIS.Clients are uniquely identified by social security number.In records that contain client survey data,the social security number is likely to be

Accepted Answer

A) the primary key. 
B) a foreign key. 
C) combined with other data fields to form a primary key. 
D) null. 
A) the primary key. 
B) a foreign key. 
C) combined with other data fields to form a primary key. 
D) null.

Question 10

The ________ occurs when more than one occurrence of a specific data item in a database exists.

Accepted Answer

A) inconsistency anomaly 
B) insert anomaly 
C) delete anomaly 
D) update anomaly 
A) inconsistency anomaly 
B) insert anomaly 
C) delete anomaly 
D) update anomaly

Question 11

File-oriented approaches create problems for organizations because of

Accepted Answer

A) multiple transaction files. 
B) a lack of sophisticated file maintenance software. 
C) multiple users. 
D) multiple master files. 
A) multiple transaction files. 
B) a lack of sophisticated file maintenance software. 
C) multiple users. 
D) multiple master files.

Question 12

Emma Kolb is a system analyst at a manufacturing company located in the Midwest.She has been asked to analyze the company's accounting information system and to recommend cost-effective improvements.After noting that the same production files have been saved and stored independently on several databases,she recommends that they be stored only once.Implementation of her recommendation would benefit the company by contributing to

Accepted Answer

A) data independence. 
B) data integration. 
C) reduce data redundancy. 
D) increase data sharing. 
A) data independence. 
B) data integration. 
C) reduce data redundancy. 
D) increase data sharing.

Question 13

The problem of losing desired information from a database when an unwanted record is purged from the database is referred to as the ________ anomaly.

Accepted Answer

A) purge 
B) erase 
C) delete 
D) integrity 
A) purge 
B) erase 
C) delete 
D) integrity

The ________ handles the link between the way data are physically stored and each user's logical view of that data.

How do users retrieve data stored in a database?

Using the database depicted above,how many primary keys are in the database?

What are the basic requirements when logically designing a relational database model?

The technique of using queries to investigate hypothesized relationships among data is called

Which one of the following results corresponds to the query below?

If a national sales tax were implemented,which language would be used to add a new field in the sales table to track the sales tax due?

The ________ occurs when more than one occurrence of a specific data item in a database exists.

File-oriented approaches create problems for organizations because of

The problem of losing desired information from a database when an unwanted record is purged from the database is referred to as the ________ anomaly.

Conceptual Foundations of Accounting Information Systems

Overview of Transaction Processing and Enterprise Resource Planning Systems

Systems Documentation Techniques

Computer Fraud

Computer Fraud and Abuse Techniques

Control and Accounting Information Systems

Controls for Information Security

Confidentiality and Privacy Controls

Processing Integrity and Availability Controls

Auditing Computer-Based Information Systems

The Revenue Cycle: Sales to Cash Collections

The Expenditure Cycle: Purchasing to Cash Disbursements

The Production Cycle

The Human Resources Management and Payroll Cycle

General Ledger and Reporting System

Database Design Using the Rea Data Model

Implementing an Rea Model in a Relational Database

Special Topics in Rea Modeling

Introduction to Systems Development and Systems Analysis

Ais Development Strategies

Systems Design, implementation, and Operation

Filters

Exam 4: Relational Databases

The ________ handles the link between the way data are physically stored and each user's logical view of that data.

How do users retrieve data stored in a database?

Using the database depicted above,how many primary keys are in the database?

What are the basic requirements when logically designing a relational database model?

The technique of using queries to investigate hypothesized relationships among data is called

Which one of the following results corresponds to the query below?

If a national sales tax were implemented,which language would be used to add a new field in the sales table to track the sales tax due?

The ________ occurs when more than one occurrence of a specific data item in a database exists.

File-oriented approaches create problems for organizations because of

The problem of losing desired information from a database when an unwanted record is purged from the database is referred to as the ________ anomaly.

Conceptual Foundations of Accounting Information Systems

Overview of Transaction Processing and Enterprise Resource Planning Systems

Systems Documentation Techniques

Computer Fraud

Computer Fraud and Abuse Techniques

Control and Accounting Information Systems

Controls for Information Security

Confidentiality and Privacy Controls

Processing Integrity and Availability Controls

Auditing Computer-Based Information Systems

The Revenue Cycle: Sales to Cash Collections

The Expenditure Cycle: Purchasing to Cash Disbursements

The Production Cycle

The Human Resources Management and Payroll Cycle

General Ledger and Reporting System

Database Design Using the Rea Data Model

Implementing an Rea Model in a Relational Database

Special Topics in Rea Modeling

Introduction to Systems Development and Systems Analysis

Ais Development Strategies

Systems Design, implementation, and Operation

Filters