Question 1

The data manipulation language

Accepted Answer

A) defines the database to the database management system 
B) transfers data to the buffer area for manipulation 
C) enables application programs to interact with and manipulate the database 
D) describes every data element in the database 
A) defines the database to the database management system 
B) transfers data to the buffer area for manipulation 
C) enables application programs to interact with and manipulate the database 
D) describes every data element in the database

Question 2

The database management system provides a controlled environment for accessing the database.

Accepted Answer

A) True 
 B)False

Question 3

The term occurrence is used to describe the number of items associated with an entity.

Accepted Answer

A) True 
 B)False

Question 4

Describe an environment in which a firm should use a partitioned database.

Accepted Answer

A partitioned database approac

Question 5

Define repeating groups,partial dependencies and transitive dependencies and discuss how they are dealt with in the process of normalizing tables.

Accepted Answer

Repeating group data occurs when multipl

Question 6

Explain how to link tables in (1:1)association.Why may this be different in a (1:0,1)association?

Accepted Answer

Where a true 1:1 association exists betw

Question 7

What is a database lockout?

Accepted Answer

To achieve data currency,simultaneous ac

Question 8

Which characteristic is associated with the database approach to data management?

Accepted Answer

A) data sharing 
B) multiple storage procedures 
C) data redundancy 
D) excessive storage costs 
A) data sharing 
B) multiple storage procedures 
C) data redundancy 
D) excessive storage costs

Question 9

A lockout is a software control that prevents multiple users from simultaneous access to data.

Accepted Answer

A) True 
 B)False

Question 10

The advantages of a partitioned database include all of the following except

Accepted Answer

A) user control is enhanced 
B) data transmission volume is increased 
C) response time is improved 
D) risk of destruction of entire database is reduced 
A) user control is enhanced 
B) data transmission volume is increased 
C) response time is improved 
D) risk of destruction of entire database is reduced

Question 11

Which term is not associated with the relational database model?

Accepted Answer

A) tuple 
B) attribute 
C) collision 
D) relation 
A) tuple 
B) attribute 
C) collision 
D) relation

Question 12

Data currency is preserved in a centralized database by

Accepted Answer

A) partitioning the database 
B) using a lockout procedure 
C) replicating the database 
D) implementing concurrency controls 
A) partitioning the database 
B) using a lockout procedure 
C) replicating the database 
D) implementing concurrency controls

Question 13

Task-data dependency is directly related to data redundancy.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

1.The value of at least one attribute in

Question 15

What are two types of distributed databases?

Accepted Answer

Partitione

Question 16

What is the insertion anomaly?

Accepted Answer

When a table is unno

Question 17

Explain a database lockout and the deadlock phenomenon.Contrast that to concurrency control and the timestamping technique.Describe the importance of these items in relation to database integrity.

Accepted Answer

In a centralized database,a database loc

Question 18

The deletion anomaly in unnormalized databases

Accepted Answer

A) is easily detected by users 
B) may result in the loss of important data 
C) complicates adding records to the database 
D) requires the user to perform excessive updates 
A) is easily detected by users 
B) may result in the loss of important data 
C) complicates adding records to the database 
D) requires the user to perform excessive updates

Question 19

In the relational model,a data element is called a relation.

Accepted Answer

A) True 
 B)False

Question 20

The normalization process involves identifying and removing structural dependencies from the tables being modeled.

Accepted Answer

A) True 
 B)False

The data manipulation language

The database management system provides a controlled environment for accessing the database.

The term occurrence is used to describe the number of items associated with an entity.

Describe an environment in which a firm should use a partitioned database.

Define repeating groups,partial dependencies and transitive dependencies and discuss how they are dealt with in the process of normalizing tables.

Explain how to link tables in (1:1)association.Why may this be different in a (1:0,1)association?

What is a database lockout?

Which characteristic is associated with the database approach to data management?

A lockout is a software control that prevents multiple users from simultaneous access to data.

The advantages of a partitioned database include all of the following except

Which term is not associated with the relational database model?

Data currency is preserved in a centralized database by

Task-data dependency is directly related to data redundancy.

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

What are two types of distributed databases?

What is the insertion anomaly?

Explain a database lockout and the deadlock phenomenon.Contrast that to concurrency control and the timestamping technique.Describe the importance of these items in relation to database integrity.

The deletion anomaly in unnormalized databases

In the relational model,a data element is called a relation.

The normalization process involves identifying and removing structural dependencies from the tables being modeled.

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

The data manipulation language

The database management system provides a controlled environment for accessing the database.

The term occurrence is used to describe the number of items associated with an entity.

Describe an environment in which a firm should use a partitioned database.

Define repeating groups,partial dependencies and transitive dependencies and discuss how they are dealt with in the process of normalizing tables.

Explain how to link tables in (1:1)association.Why may this be different in a (1:0,1)association?

What is a database lockout?

Which characteristic is associated with the database approach to data management?

A lockout is a software control that prevents multiple users from simultaneous access to data.

The advantages of a partitioned database include all of the following except

Which term is not associated with the relational database model?

Data currency is preserved in a centralized database by

Task-data dependency is directly related to data redundancy.

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

What are two types of distributed databases?

What is the insertion anomaly?

Explain a database lockout and the deadlock phenomenon.Contrast that to concurrency control and the timestamping technique.Describe the importance of these items in relation to database integrity.

The deletion anomaly in unnormalized databases

In the relational model,a data element is called a relation.

The normalization process involves identifying and removing structural dependencies from the tables being modeled.

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