Question 1

A row in a table that contains data about a specific item in a database table is call

Accepted Answer

A) a data model. 
B) an attribute. 
C) a tuple. 
D) a relational record. 
A) a data model. 
B) an attribute. 
C) a tuple. 
D) a relational record.

Question 2

Identify one potential outcome of the update anomaly.

Accepted Answer

A) inconsistent data 
B) inability to add new data 
C) unintentional loss of data 
D) none of the above 
A) inconsistent data 
B) inability to add new data 
C) unintentional loss of data 
D) none of the above

Question 3

A low-level view of the database that describes how the data are actually stored and accessed is the

Accepted Answer

A) conceptual-level schema. 
B) subschema. 
C) internal-level schema. 
D) external-level schema. 
A) conceptual-level schema. 
B) subschema. 
C) internal-level schema. 
D) external-level schema.

Question 4

The logical structure of a database is described by the

Accepted Answer

A) data dictionary. 
B) schema. 
C) database management system. 
D) context diagram. 
A) data dictionary. 
B) schema. 
C) database management system. 
D) context diagram.

Question 5

Which is probably the most immediate and significant effect of database technology on accounting?

Accepted Answer

A) Replacement of the double entry-system. 
B) Change in the nature of financial reporting. 
C) Elimination of traditional records such as journals and ledgers. 
D) Quicker access to and greater use of accounting information in decision-making. 
A) Replacement of the double entry-system. 
B) Change in the nature of financial reporting. 
C) Elimination of traditional records such as journals and ledgers. 
D) Quicker access to and greater use of accounting information in decision-making.

Question 6

Which of the following would not be found in a data dictionary entry for a data item?

Accepted Answer

A) records containing a specific data item 
B) physical location of the data 
C) source of the data item 
D) field type 
A) records containing a specific data item 
B) physical location of the data 
C) source of the data item 
D) field type

Question 7

Describe a major advantage of database systems over file-oriented transaction processing systems.

Accepted Answer

Database systems separate logical and ph

Question 8

Pat Owen is chair of the National Grizzly Society,which maintains a database of all grizzly bears within the United States.One table will store the name,birth date,and other characteristics of all of the grizzly bears that have been registered.Each grizzly bear is uniquely identified by a registration number.A second table will contain data that link each grizzly bear to its male and female parents by means of their registration numbers.The primary key in the second table is

Accepted Answer

A) name. 
B) birth date. 
C) the same as the primary key in the first table. 
D) a combination of primary keys in the first table. 
A) name. 
B) birth date. 
C) the same as the primary key in the first table. 
D) a combination of primary keys in the first table.

Question 9

Identify one potential outcome of the delete anomaly.

Accepted Answer

A) inconsistent data 
B) inability to add new data 
C) unintentional loss of data 
D) none of the above 
A) inconsistent data 
B) inability to add new data 
C) unintentional loss of data 
D) none of the above

Question 10

What is the difference in logical view and physical view?

Accepted Answer

The logical view is how the user or prog

Question 11

Describe the difference between update anomaly,insert anomaly,and delete anomaly.Provide an example for each of the anomaly.

Accepted Answer

Update anomaly is an improper database o

Question 12

All of the following are benefits of the database approach except

Accepted Answer

A) data integration and sharing. 
B) decentralized management of data. 
C) minimal data redundancy. 
D) cross-functional analysis and reporting. 
A) data integration and sharing. 
B) decentralized management of data. 
C) minimal data redundancy. 
D) cross-functional analysis and reporting.

Question 13

A relational database in which vendor data is not maintained independently of purchase order data will most likely result in

Accepted Answer

A) an update anomaly. 
B) an insert anomaly. 
C) a delete anomaly. 
D) an integrity anomaly. 
A) an update anomaly. 
B) an insert anomaly. 
C) a delete anomaly. 
D) an integrity anomaly.

A row in a table that contains data about a specific item in a database table is call

Identify one potential outcome of the update anomaly.

A low-level view of the database that describes how the data are actually stored and accessed is the

The logical structure of a database is described by the

Which is probably the most immediate and significant effect of database technology on accounting?

Which of the following would not be found in a data dictionary entry for a data item?

Describe a major advantage of database systems over file-oriented transaction processing systems.

Identify one potential outcome of the delete anomaly.

What is the difference in logical view and physical view?

Describe the difference between update anomaly,insert anomaly,and delete anomaly.Provide an example for each of the anomaly.

All of the following are benefits of the database approach except

A relational database in which vendor data is not maintained independently of purchase order data will most likely result in

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

A row in a table that contains data about a specific item in a database table is call

Identify one potential outcome of the update anomaly.

A low-level view of the database that describes how the data are actually stored and accessed is the

The logical structure of a database is described by the

Which is probably the most immediate and significant effect of database technology on accounting?

Which of the following would not be found in a data dictionary entry for a data item?

Describe a major advantage of database systems over file-oriented transaction processing systems.

Identify one potential outcome of the delete anomaly.

What is the difference in logical view and physical view?

Describe the difference between update anomaly,insert anomaly,and delete anomaly.Provide an example for each of the anomaly.

All of the following are benefits of the database approach except

A relational database in which vendor data is not maintained independently of purchase order data will most likely result in

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