Question 1

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 2

What is a transitive dependency?

Accepted Answer

A transitive dependency occurs

Question 3

Data concurrency

Accepted Answer

A)  is a security issue in partitioned databases 
B)  is implemented using timestamping 
C)  may result in data lockout 
D)  occurs when a deadlock is triggered 
A)  is a security issue in partitioned databases 
B)  is implemented using timestamping 
C)  may result in data lockout 
D)  occurs when a deadlock is triggered

Question 4

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 5

The update anomaly in unnormalized databases

Accepted Answer

A)  occurs because of data redundancy 
B)  complicates adding records to the database 
C)  may result in the loss of important data 
D)  often results in excessive record insertions 
A)  occurs because of data redundancy 
B)  complicates adding records to the database 
C)  may result in the loss of important data 
D)  often results in excessive record insertions

Question 6

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 lockout is u

Question 7

The term occurrence is used to describe the number of attributes or fields pertaining to a specific entity.

Accepted Answer

A) True 
 B)False

Question 8

Which procedure will prevent two end users from accessing the same data element at the same time?

Accepted Answer

A)  data redundancy 
B)  data replication 
C)  data lockout 
D)  none of the above 
A)  data redundancy 
B)  data replication 
C)  data lockout 
D)  none of the above

Question 9

Which of the following is not a responsibility of the database management system?

Accepted Answer

A)  provide an interface between the users and the physical database 
B)  provide security against a natural disaster 
C)  ensure that the internal schema and external schema are consistent 
D)  authorize access to portions of the database 
A)  provide an interface between the users and the physical database 
B)  provide security against a natural disaster 
C)  ensure that the internal schema and external schema are consistent 
D)  authorize access to portions of the database

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

Ownership of data in traditional legacy systems often leads to data redundancy.This in turn leads to several data management problems.What are they? How does the database approach solve them?

Accepted Answer

Data redundancy causes significant data

Question 12

Logical database design is the foundation of the conceptual design.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

The partitioned database approach splits

Question 14

Which statement is not correct? A query language like SQL

Accepted Answer

A)  is written in a fourth-generation language 
B)  requires user familiarity with COBOL 
C)  allows users to retrieve and modify data 
D)  reduces reliance on programmers 
A)  is written in a fourth-generation language 
B)  requires user familiarity with COBOL 
C)  allows users to retrieve and modify data 
D)  reduces reliance on programmers

Question 15

Explain the three types of anomalies associated with database tables that have not been normalized.

Accepted Answer

The update anomaly is the result of data

Question 16

The textbook refers to four interrelated components of the database concept.Which of the following is not one of the components?

Accepted Answer

A)  the database management system 
B)  the database sdministrator 
C)  the physical database 
D)  the conceptual database 
A)  the database management system 
B)  the database sdministrator 
C)  the physical database 
D)  the conceptual database

Question 17

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

Accepted Answer

A table is in third normal form when it

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

Describe a specific data element,entity,and record type in the expenditure cycle.

Accepted Answer

data element: vendor's name or

Question 20

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

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

What is a transitive dependency?

Data concurrency

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

The update anomaly in unnormalized databases

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 term occurrence is used to describe the number of attributes or fields pertaining to a specific entity.

Which procedure will prevent two end users from accessing the same data element at the same time?

Which of the following is not a responsibility of the database management system?

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

Ownership of data in traditional legacy systems often leads to data redundancy.This in turn leads to several data management problems.What are they? How does the database approach solve them?

Logical database design is the foundation of the conceptual design.

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

Which statement is not correct? A query language like SQL

Explain the three types of anomalies associated with database tables that have not been normalized.

The textbook refers to four interrelated components of the database concept.Which of the following is not one of the components?

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

A table is in second normal form when it is

Describe a specific data element,entity,and record type in the expenditure cycle.

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

The Information System: An Accountant’s 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 : Sarbanes-Oxley and IT Governance

IT Controls : Security and Access

IT Controls : Systems Development Program Changes and Application Controls

Filters

Exam 9: Database Management Systems

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

What is a transitive dependency?

Data concurrency

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

The update anomaly in unnormalized databases

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 term occurrence is used to describe the number of attributes or fields pertaining to a specific entity.

Which procedure will prevent two end users from accessing the same data element at the same time?

Which of the following is not a responsibility of the database management system?

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

Ownership of data in traditional legacy systems often leads to data redundancy.This in turn leads to several data management problems.What are they? How does the database approach solve them?

Logical database design is the foundation of the conceptual design.

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

Which statement is not correct? A query language like SQL

Explain the three types of anomalies associated with database tables that have not been normalized.

The textbook refers to four interrelated components of the database concept.Which of the following is not one of the components?

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

A table is in second normal form when it is

Describe a specific data element,entity,and record type in the expenditure cycle.

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

The Information System: An Accountant’s 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 : Sarbanes-Oxley and IT Governance

IT Controls : Security and Access

IT Controls : Systems Development Program Changes and Application Controls

Filters