Question 1

A deadlock is a phenomenon that prevents the processing of transactions.

Accepted Answer

A) True 
 B)False

Question 2

Which statement is correct?

Accepted Answer

A)  in a normalized database,data about vendors occur in several locations 
B)  the accountant is responsible for database normalization 
C)  in a normalized database,deletion of a key record could result in the destruction of the audit trail 
D)  connections between M:M tables are provided by a link table 
A)  in a normalized database,data about vendors occur in several locations 
B)  the accountant is responsible for database normalization 
C)  in a normalized database,deletion of a key record could result in the destruction of the audit trail 
D)  connections between M:M tables are provided by a link table

Question 3

What are the characteristics of a properly designed relational database table?

Accepted Answer

The characteristics of a properly design

Question 4

What are the key control implications of the absence of database normalization?

Accepted Answer

When considering the quality of the data

Question 5

All of the following are basic data management tasks except

Accepted Answer

A)  data deletion 
B)  data storage 
C)  data attribution 
D)  data retrieval 
A)  data deletion 
B)  data storage 
C)  data attribution 
D)  data retrieval

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Use the following words to complete the sentences.
 $\begin{array}{ll}
\text { database administrator } & \text { data dictionary } \
\text { data redundancy } & \text { index sequential access method } \
\text { query language } & \text { schema } \
\text { sequential structure } & \text { subschema }
\end{array}$ 
-_________________________ occurs when a specific file is reproduced for each user who needs access to the file.

Accepted Answer

The answer of Use the following words to complete the...

Question 8

What is the partitioned database approach and what are its advantages?

Accepted Answer

The partitioned database approach splits

Question 9

The deletion anomaly is the least important of the problems affecting unnormalized databases.

Accepted Answer

A) True 
 B)False

Question 10

What is the insertion anomaly?

Accepted Answer

Because of a table i

Question 11

Which of the following is not a common form of conceptual database model?

Accepted Answer

A)  hierarchical 
B)  network 
C)  sequential 
D)  relational 
A)  hierarchical 
B)  network 
C)  sequential 
D)  relational

Question 12

Explain the basic results that come from the restrict,project,and join functions.

Accepted Answer

A restrict extracts selected rows from a

Question 13

Which of the following is a level of the database that is defined by the data definition language?

Accepted Answer

A)  user view 
B)  schema 
C)  internal view 
D)  all are levels or views of the database 
A)  user view 
B)  schema 
C)  internal view 
D)  all are levels or views of the database

Question 14

Logical database design is the foundation of the conceptual design.

Accepted Answer

A) True 
 B)False

Question 15

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 16

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,

Question 17

Replicated databases create considerable data redundancy,which is in conflict with the database concept.Explain the justification of this approach.

Accepted Answer

The primary justification for a replicat

Question 18

A table is in second 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 insert 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 insert anomalies 
E)  none of the above

Question 19

Under the database approach,data is viewed as proprietary or owned by users.

Accepted Answer

A) True 
 B)False

Question 20

The physical database is an abstract representation of the database.

Accepted Answer

A) True 
 B)False

A deadlock is a phenomenon that prevents the processing of transactions.

Which statement is correct?

What are the characteristics of a properly designed relational database table?

What are the key control implications of the absence of database normalization?

All of the following are basic data management tasks except

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

What is the partitioned database approach and what are its advantages?

The deletion anomaly is the least important of the problems affecting unnormalized databases.

What is the insertion anomaly?

Which of the following is not a common form of conceptual database model?

Explain the basic results that come from the restrict,project,and join functions.

Which of the following is a level of the database that is defined by the data definition language?

Logical database design is the foundation of the conceptual design.

All of the following are advantages of a partitioned database except

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

Replicated databases create considerable data redundancy,which is in conflict with the database concept.Explain the justification of this approach.

A table is in second normal form when it is

Under the database approach,data is viewed as proprietary or owned by users.

The physical database is an abstract representation of the database.

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

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 Part I: Sarbanes-Oxley and It Governance

IT Controls Part II: Security and Access

IT Controls Part III: Systems Development, program Changes, and Application Controls

Filters

Exam 9: Database Management Systems

A deadlock is a phenomenon that prevents the processing of transactions.

Which statement is correct?

What are the characteristics of a properly designed relational database table?

What are the key control implications of the absence of database normalization?

All of the following are basic data management tasks except

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

What is the partitioned database approach and what are its advantages?

The deletion anomaly is the least important of the problems affecting unnormalized databases.

What is the insertion anomaly?

Which of the following is not a common form of conceptual database model?

Explain the basic results that come from the restrict,project,and join functions.

Which of the following is a level of the database that is defined by the data definition language?

Logical database design is the foundation of the conceptual design.

All of the following are advantages of a partitioned database except

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

Replicated databases create considerable data redundancy,which is in conflict with the database concept.Explain the justification of this approach.

A table is in second normal form when it is

Under the database approach,data is viewed as proprietary or owned by users.

The physical database is an abstract representation of the database.

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

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 Part I: Sarbanes-Oxley and It Governance

IT Controls Part II: Security and Access

IT Controls Part III: Systems Development, program Changes, and Application Controls

Filters