Question 1

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

Accepted Answer

A)  the ability to process data without the help of a programmer 
B)  the ability to control access to the data 
C)  constant production of backups 
D)  the inability to determine what data is available 
A)  the ability to process data without the help of a programmer 
B)  the ability to control access to the data 
C)  constant production of backups 
D)  the inability to determine what data is available

Question 2

Explain the purpose of an ER diagram in database design.

Accepted Answer

The entity relationship (ER) diagram is

Question 3

The formal name for a row in the physical database table is

Accepted Answer

A)  attribute 
B)  schema 
C)  tuple 
D)  link 
A)  attribute 
B)  schema 
C)  tuple 
D)  link

Question 4

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

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Which of the following is not a problem usually associated with the flat-file approach to data management?

Accepted Answer

A)  data redundancy 
B)  restricting access to data to the primary user 
C)  data storage 
D)  currency of information 
A)  data redundancy 
B)  restricting access to data to the primary user 
C)  data storage 
D)  currency of information

Question 7

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

Accepted Answer

User views are derived databas

Question 8

What is a database lockout?

Accepted Answer

To achieve data currency, simultaneous a

Question 9

What are the problems with the flat-file approach? How does the database approach solve them?

Accepted Answer

Data redundancy causes significant data

Question 10

The data definition language

Accepted Answer

A)  identifies, for the database management system, the names and relationships of all data elements, records, and files that comprise the database 
B)  inserts database commands into application programs to enable standard programs to interact with and manipulate the database 
C)  permits users to process data in the database without the need for conventional programs 
D)  describes every data element in the database 
A)  identifies, for the database management system, the names and relationships of all data elements, records, and files that comprise the database 
B)  inserts database commands into application programs to enable standard programs to interact with and manipulate the database 
C)  permits users to process data in the database without the need for conventional programs 
D)  describes every data element in the database

Question 11

Which of the following may provide many distinct views of the database?

Accepted Answer

A)  the schema 
B)  the internal view 
C)  the user view 
D)  the conceptual view 
A)  the schema 
B)  the internal view 
C)  the user view 
D)  the conceptual view

Question 12

What is the insertion anomaly?

Accepted Answer

When a table is unno

Question 13

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

Question 14

Explain the three views of a database.

Accepted Answer

The unique internal view of the database

Question 15

Foreign keys physically connect logically related tables to achieve the associates described in the data model.

Accepted Answer

A) True 
 B)False

Question 16

How is a database deadlock usually resolved? What are factors that influence the decision made regarding the transactions?

Accepted Answer

Resolving a deadlock usually involves sa

Question 17

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 18

In the database method of data management, access authority is maintained by systems programming.

Accepted Answer

A) True 
 B)False

Question 19

The data dictionary describes all of the data elements in the database.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

The partitioned database approach splits

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

Explain the purpose of an ER diagram in database design.

The formal name for a row in the physical database table is

A table is in third normal form when it is

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

Which of the following is not a problem usually associated with the flat-file approach to data management?

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

What is a database lockout?

What are the problems with the flat-file approach? How does the database approach solve them?

The data definition language

Which of the following may provide many distinct views of the database?

What is the insertion anomaly?

A replicated database is appropriate when

Explain the three views of a database.

Foreign keys physically connect logically related tables to achieve the associates described in the data model.

How is a database deadlock usually resolved? What are factors that influence the decision made regarding the transactions?

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

In the database method of data management, access authority is maintained by systems programming.

The data dictionary describes all of the data elements in the database.

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

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

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

Explain the purpose of an ER diagram in database design.

The formal name for a row in the physical database table is

A table is in third normal form when it is

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

Which of the following is not a problem usually associated with the flat-file approach to data management?

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

What is a database lockout?

What are the problems with the flat-file approach? How does the database approach solve them?

The data definition language

Which of the following may provide many distinct views of the database?

What is the insertion anomaly?

A replicated database is appropriate when

Explain the three views of a database.

Foreign keys physically connect logically related tables to achieve the associates described in the data model.

How is a database deadlock usually resolved? What are factors that influence the decision made regarding the transactions?

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

In the database method of data management, access authority is maintained by systems programming.

The data dictionary describes all of the data elements in the database.

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

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