Question 1

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 2

Discuss the key factors to consider in determining how to partition a corporate database.

Accepted Answer

The partitioned approach works best for

Question 3

Contrast the navigational databases with relational databases.What is the primary advantage of the relational model?

Accepted Answer

The most apparent difference between the

Question 4

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 5

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 6

Explain the three views of a database.

Accepted Answer

The unique internal view of the database

Question 7

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 8

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 9

Entities are

Accepted Answer

A)  nouns that are depicted by rectangles on an entity relationship diagram 
B)  data that describe the characteristics of properties of resources 
C)  associations among elements 
D)  sets of data needed to make a decision 
A)  nouns that are depicted by rectangles on an entity relationship diagram 
B)  data that describe the characteristics of properties of resources 
C)  associations among elements 
D)  sets of data needed to make a decision

Question 10

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 11

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 12

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 13

Data normalization groups data attributes into tables in accordance with specific design objectives.

Accepted Answer

A) True 
 B)False

Question 14

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 15

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

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

Users are the individuals in the organiz

Question 18

An entity is any physical thing about which the organization wishes to capture data.

Accepted Answer

A) True 
 B)False

Question 19

What are two types of distributed databases?

Accepted Answer

Partitione

Question 20

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

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

Discuss the key factors to consider in determining how to partition a corporate database.

Contrast the navigational databases with relational databases.What is the primary advantage of the relational model?

The most serious problem with unnormalized databases is the

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

Explain the three views of a database.

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

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.

Entities are

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

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

Which statement is false?

Data normalization groups data attributes into tables in accordance with specific design objectives.

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

A table is in first normal form when it is

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

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

An entity is any physical thing about which the organization wishes to capture data.

What are two types of distributed databases?

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

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

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 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

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

Discuss the key factors to consider in determining how to partition a corporate database.

Contrast the navigational databases with relational databases.What is the primary advantage of the relational model?

The most serious problem with unnormalized databases is the

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

Explain the three views of a database.

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

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.

Entities are

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

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

Which statement is false?

Data normalization groups data attributes into tables in accordance with specific design objectives.

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

A table is in first normal form when it is

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

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

An entity is any physical thing about which the organization wishes to capture data.

What are two types of distributed databases?

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

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

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 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