Question 1

An ER diagram is a graphical representation of a data model.

Accepted Answer

A) True 
 B)False

Question 2

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 3

The most serious problem with unnormalized databases is the

Accepted Answer

A) update anomaly 
B) insertion anomaly 
C) deletion anomaly 
D) none of the above 
A) update anomaly 
B) insertion anomaly 
C) deletion anomaly 
D) none of the above

Question 4

Explain the three views of a database.

Accepted Answer

The unique internal view of the database

Question 5

Which of the following is not a common form of conceptual database model?

Accepted Answer

A) hierarchical 
B) network 
C) sequential 
D) relational 
A) hierarchical 
B) network 
C) sequential 
D) relational

Question 6

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 
A) free of repeating group data 
B) free of transitive dependencies 
C) free of partial dependencies 
D) free of update anomalies

Question 7

What are the four elements of the database approach? Explain the role of each.

Accepted Answer

Users are the individuals in the organiz

Question 8

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 9

How does the database approach solve the problem of data redundancy?

Accepted Answer

Data redundancy is not a probl

Question 10

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 11

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

Accepted Answer

A) True 
 B)False

Question 12

Under the database approach,data is viewed as proprietary or owned by users.

Accepted Answer

A) True 
 B)False

Question 13

In the relational database model all of the following are true except

Accepted Answer

A) data is presented to users as tables 
B) data can be extracted from specified rows from specified tables 
C) a new table can be built by joining two tables 
D) only one-to-many relationships can be supported 
A) data is presented to users as tables 
B) data can be extracted from specified rows from specified tables 
C) a new table can be built by joining two tables 
D) only one-to-many relationships can be supported

Question 14

There is more than one conceptual view of the database.

Accepted Answer

A) True 
 B)False

Question 15

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 
A) free of repeating group data 
B) free of transitive dependencies 
C) free of partial dependencies 
D) free of insert anomalies

Question 16

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 17

Explain how linkages between relational tables are accomplished.

Accepted Answer

Logically related tables need to be phys

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

All of the following are advantages of a partitioned database except

Accepted Answer

A) increased user control by having the data stored locally 
B) deadlocks are eliminated 
C) transaction processing response time is improved 
D) partitioning can reduce losses in case of disaster 
A) increased user control by having the data stored locally 
B) deadlocks are eliminated 
C) transaction processing response time is improved 
D) partitioning can reduce losses in case of disaster

Question 20

What is the update anomaly?

Accepted Answer

The update anomaly results from data red

An ER diagram is a graphical representation of a data model.

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

The most serious problem with unnormalized databases is the

Explain the three views of a database.

Which of the following is not a common form of conceptual database model?

A table is in first normal form when it is

What are the four elements of the database approach? Explain the role of each.

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

How does the database approach solve the problem of data redundancy?

In the relational database model

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

Under the database approach,data is viewed as proprietary or owned by users.

In the relational database model all of the following are true except

There is more than one conceptual view of the database.

A table is in second normal form when it is

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

Explain how linkages between relational tables are accomplished.

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

All of the following are advantages of a partitioned database except

What is the update anomaly?

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

An ER diagram is a graphical representation of a data model.

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

The most serious problem with unnormalized databases is the

Explain the three views of a database.

Which of the following is not a common form of conceptual database model?

A table is in first normal form when it is

What are the four elements of the database approach? Explain the role of each.

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

How does the database approach solve the problem of data redundancy?

In the relational database model

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

Under the database approach,data is viewed as proprietary or owned by users.

In the relational database model all of the following are true except

There is more than one conceptual view of the database.

A table is in second normal form when it is

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

Explain how linkages between relational tables are accomplished.

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

All of the following are advantages of a partitioned database except

What is the update anomaly?

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