Question 1

What is view integration?

Accepted Answer

A modern company uses hundreds

Question 2

The database approach to data management is sometimes called the flat file approach.

Accepted Answer

A) True 
 B)False

Question 3

What control maintains complete, current, and consistent data at all information processing units?

Accepted Answer

A)  deadlock control 
B)  replication control 
C)  concurrency control 
D)  gateway control 
A)  deadlock control 
B)  replication control 
C)  concurrency control 
D)  gateway control

Question 4

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 5

What typical features are provided by a database management system (DBMS)?

Accepted Answer

1. Program development which permits bot

Question 6

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 7

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 8

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 9

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

Accepted Answer

A restrict extracts selected rows from a

Question 10

What is a replicated database and what are the advantages of this approach?

Accepted Answer

The entire database is replicated at eac

Question 11

What is the normal cardinality between a Customer entity and a Sales order entity? What does it signify? Why is it the only logical cardinality?

Accepted Answer

The normal cardinality is 1:M which sign

Question 12

Improperly normalized databases are associated with three types of anomalies: the update anomaly, the insertion anomaly, and the deletion anomaly.

Accepted Answer

A) True 
 B)False

Question 13

In the relational database model

Accepted Answer

A)  relationships are explicit 
B)  the user perceives that files are linked using pointers 
C)  data is represented on two-dimensional tables 
D)  data is represented as a tree structure 
A)  relationships are explicit 
B)  the user perceives that files are linked using pointers 
C)  data is represented on two-dimensional tables 
D)  data is represented as a tree structure

Question 14

In a distributed data processing system, a database can be centralized or distributed. Explain each.

Accepted Answer

When the database is centralized, the en

Question 15

A customer name and an unpaid balance is an example of a one-to-many relationship.

Accepted Answer

A) True 
 B)False

Question 16

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 17

All of the following are elements of the DBMS which facilitate user access to the database except

Accepted Answer

A)  query language 
B)  data access language 
C)  data manipulation language 
D)  data definition language 
A)  query language 
B)  data access language 
C)  data manipulation language 
D)  data definition language

Question 18

When is a table in third normal form (3NF)?

Accepted Answer

A table is in third normal form when it

Question 19

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

Accepted Answer

A partitioned database approac

Question 20

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

Accepted Answer

A) True 
 B)False

What is view integration?

The database approach to data management is sometimes called the flat file approach.

What control maintains complete, current, and consistent data at all information processing units?

A table is in second normal form when it is

What typical features are provided by a database management system (DBMS)?

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

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

Which term is not associated with the relational database model?

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

What is a replicated database and what are the advantages of this approach?

What is the normal cardinality between a Customer entity and a Sales order entity? What does it signify? Why is it the only logical cardinality?

Improperly normalized databases are associated with three types of anomalies: the update anomaly, the insertion anomaly, and the deletion anomaly.

In the relational database model

In a distributed data processing system, a database can be centralized or distributed. Explain each.

A customer name and an unpaid balance is an example of a one-to-many relationship.

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

All of the following are elements of the DBMS which facilitate user access to the database except

When is a table in third normal form (3NF)?

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

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

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 view integration?

The database approach to data management is sometimes called the flat file approach.

What control maintains complete, current, and consistent data at all information processing units?

A table is in second normal form when it is

What typical features are provided by a database management system (DBMS)?

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

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

Which term is not associated with the relational database model?

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

What is a replicated database and what are the advantages of this approach?

What is the normal cardinality between a Customer entity and a Sales order entity? What does it signify? Why is it the only logical cardinality?

Improperly normalized databases are associated with three types of anomalies: the update anomaly, the insertion anomaly, and the deletion anomaly.

In the relational database model

In a distributed data processing system, a database can be centralized or distributed. Explain each.

A customer name and an unpaid balance is an example of a one-to-many relationship.

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

All of the following are elements of the DBMS which facilitate user access to the database except

When is a table in third normal form (3NF)?

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

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

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