Question 1

What is the update anomaly?

Accepted Answer

The update anomaly results from data red

Question 2

A description of the physical arrangement of records in the database is

Accepted Answer

A)  the internal view 
B)  the conceptual view 
C)  the subschema 
D)  the external view 
A)  the internal view 
B)  the conceptual view 
C)  the subschema 
D)  the external view

Question 3

Use the following words to complete the sentences.
database administrator
data dictionary
data redundancy
index sequential access method
query language
schema
sequential structure
subschema
-_________________________ 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 4

Why are the hierarchical and network models called navigational databases?

Accepted Answer

These are called navigational

Question 5

Cardinality describes the number of possible occurrences in one table that are associated with a single occurrence in a related table.

Accepted Answer

A) True 
 B)False

Question 6

The physical database is an abstract representation of the database.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

What is a transitive dependency?

Accepted Answer

A transitive dependency occurs

Question 9

Which statement is false?

Accepted Answer

A)  The DBMS is special software that is programmed to know which data elements each user is authorized to access. 
B)  User programs send requests for data to the DBMS. 
C)  During processing, the DBMS periodically makes backup copies of the physical database. 
D)  The DBMS does not control access to the database. 
A)  The DBMS is special software that is programmed to know which data elements each user is authorized to access. 
B)  User programs send requests for data to the DBMS. 
C)  During processing, the DBMS periodically makes backup copies of the physical database. 
D)  The DBMS does not control access to the database.

Question 10

What are two types of distributed databases?

Accepted Answer

Partitione

Question 11

Each of the following is a relational algebra function except

Accepted Answer

A)  join 
B)  project 
C)  link 
D)  restrict 
A)  join 
B)  project 
C)  link 
D)  restrict

Question 12

A join builds a new table by creating links.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

Discuss the accountant's role in data modeling and potential problems caused by anomalies.

Accepted Answer

Most accountants will not be directly re

Question 15

To the user, data processing procedures for routine transactions, such as entering sales orders, appear to be identical in the database environment and in the traditional environment.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

1. The value of at least one attribute i

Question 17

There is more than one conceptual view of the database.

Accepted Answer

A) True 
 B)False

Question 18

Task-data dependency is directly related to data redundancy.

Accepted Answer

A) True 
 B)False

Question 19

List the steps involved in creating a relational database using a top-down approach.

Accepted Answer

1. Identify the views to be modeled.
2.

Question 20

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

What is the update anomaly?

A description of the physical arrangement of records in the database is

Why are the hierarchical and network models called navigational databases?

Cardinality describes the number of possible occurrences in one table that are associated with a single occurrence in a related table.

The physical database is an abstract representation of the database.

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

What is a transitive dependency?

Which statement is false?

What are two types of distributed databases?

Each of the following is a relational algebra function except

A join builds a new table by creating links.

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

Discuss the accountant's role in data modeling and potential problems caused by anomalies.

To the user, data processing procedures for routine transactions, such as entering sales orders, appear to be identical in the database environment and in the traditional environment.

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

There is more than one conceptual view of the database.

Task-data dependency is directly related to data redundancy.

List the steps involved in creating a relational database using a top-down approach.

A table is in first normal form when it is

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

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

What is the update anomaly?

A description of the physical arrangement of records in the database is

Why are the hierarchical and network models called navigational databases?

Cardinality describes the number of possible occurrences in one table that are associated with a single occurrence in a related table.

The physical database is an abstract representation of the database.

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

What is a transitive dependency?

Which statement is false?

What are two types of distributed databases?

Each of the following is a relational algebra function except

A join builds a new table by creating links.

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

Discuss the accountant's role in data modeling and potential problems caused by anomalies.

To the user, data processing procedures for routine transactions, such as entering sales orders, appear to be identical in the database environment and in the traditional environment.

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

There is more than one conceptual view of the database.

Task-data dependency is directly related to data redundancy.

List the steps involved in creating a relational database using a top-down approach.

A table is in first normal form when it is

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

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