Question 1

Timestamping is a control that is used to ensure database partitioning.

Accepted Answer

A) True 
 B)False

Question 2

Discuss the key factors to consider in determining how to partition a corporate database.

Accepted Answer

The partitioned approach works best for

Question 3

The physical database is an abstract representation of the database.

Accepted Answer

A) True 
 B)False

Question 4

All of the following are advantages of a partitioned database except

Accepted Answer

A)  increased user control by having the data stored locally 
B)  deadlocks are eliminated 
C)  transaction processing response time is improved 
D)  partitioning can reduce losses in case of disaster 
A)  increased user control by having the data stored locally 
B)  deadlocks are eliminated 
C)  transaction processing response time is improved 
D)  partitioning can reduce losses in case of disaster

Question 5

A table is in first normal form when it is

Accepted Answer

A)  free of repeating group data 
B)  free of transitive dependencies 
C)  free of partial dependencies 
D)  free of update anomalies 
E)  none of the above 
A)  free of repeating group data 
B)  free of transitive dependencies 
C)  free of partial dependencies 
D)  free of update anomalies 
E)  none of the above

Question 6

In a distributed data processing system,a database can be centralized or distributed.What are the options? Explain.

Accepted Answer

In a distributed data processing system,

Timestamping is a control that is used to ensure database partitioning.

Discuss the key factors to consider in determining how to partition a corporate database.

The physical database is an abstract representation of the database.

All of the following are advantages of a partitioned database except

A table is in first normal form when it is

In a distributed data processing system,a database can be centralized or distributed.What are the options? Explain.

The Information System: An Accountant’s 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

General Ledger, 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

Construct, Deliver, and Maintain Systems Projects

IT Controls : Sarbanes-Oxley and IT Governance

IT Controls : Security and Access

IT Controls : Systems Development Program Changes and Application Controls

Filters

Exam 9: Database Management Systems

Timestamping is a control that is used to ensure database partitioning.

Discuss the key factors to consider in determining how to partition a corporate database.

The physical database is an abstract representation of the database.

All of the following are advantages of a partitioned database except

A table is in first normal form when it is

In a distributed data processing system,a database can be centralized or distributed.What are the options? Explain.

The Information System: An Accountant’s 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

General Ledger, 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

Construct, Deliver, and Maintain Systems Projects

IT Controls : Sarbanes-Oxley and IT Governance

IT Controls : Security and Access

IT Controls : Systems Development Program Changes and Application Controls

Filters