Question 1

Which of the following is a relational algebra function?

Accepted Answer

A) restrict 
B) project 
C) join 
D) all are relational algebra functions 
A) restrict 
B) project 
C) join 
D) all are relational algebra functions

Question 2

What is the relationship between a database table and a user view?

Accepted Answer

User views are derived databas

Question 3

What is a replicated database and what are the advantages of this approach?

Accepted Answer

The entire database is replicated at eac

Question 4

Entities are

Accepted Answer

A) nouns that are depicted by rectangles on an entity relationship diagram 
B) data that describe the characteristics of properties of resources 
C) associations among elements 
D) sets of data needed to make a decision 
A) nouns that are depicted by rectangles on an entity relationship diagram 
B) data that describe the characteristics of properties of resources 
C) associations among elements 
D) sets of data needed to make a decision

Question 5

A customer name and an unpaid balance is an example of a one-to-many relationship.

Accepted Answer

A) True 
 B)False

Question 6

A replicated database is appropriate when

Accepted Answer

A) there is minimal data sharing among information processing units 
B) there exists a high degree of data sharing and no primary user 
C) there is no risk of the deadlock phenomenon 
D) most data sharing consists of read-write transactions 
A) there is minimal data sharing among information processing units 
B) there exists a high degree of data sharing and no primary user 
C) there is no risk of the deadlock phenomenon 
D) most data sharing consists of read-write transactions

Which of the following is a relational algebra function?

What is the relationship between a database table and a user view?

What is a replicated database and what are the advantages of this approach?

Entities are

A customer name and an unpaid balance is an example of a one-to-many relationship.

A replicated database is appropriate when

The Information System: an Accountants Perspective

Introduction to Transaction Processing

Ethics,fraud,and Internal Control

The Revenue Cycle

The Expenditure Cycle Part I: Purchases and Cash Disbursements Procedures

The Expenditure Cycle Part II: Payroll Processing and Fixed Asset Procedures

The Conversion Cycle

Financial Reporting,and Management Reporting Systems

The Rea Approach to Business Process Modeling

Enterprise Resource Planning Systems

Electronic Commerce Systems

Managing the Systems Development Life Cycle

Auditing It Controls Part I: Sarbanes-Oxley and It Governance

Auditing It Controls Part II: Security and Access

Auditing It Controls Part III: Systems Development, program Changes, and Application Auditing

Filters

Exam 9: Database Management Systems

Which of the following is a relational algebra function?

What is the relationship between a database table and a user view?

What is a replicated database and what are the advantages of this approach?

Entities are

A customer name and an unpaid balance is an example of a one-to-many relationship.

A replicated database is appropriate when

The Information System: an Accountants Perspective

Introduction to Transaction Processing

Ethics,fraud,and Internal Control

The Revenue Cycle

The Expenditure Cycle Part I: Purchases and Cash Disbursements Procedures

The Expenditure Cycle Part II: Payroll Processing and Fixed Asset Procedures

The Conversion Cycle

Financial Reporting,and Management Reporting Systems

The Rea Approach to Business Process Modeling

Enterprise Resource Planning Systems

Electronic Commerce Systems

Managing the Systems Development Life Cycle

Auditing It Controls Part I: Sarbanes-Oxley and It Governance

Auditing It Controls Part II: Security and Access

Auditing It Controls Part III: Systems Development, program Changes, and Application Auditing

Filters