Question 1

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

Accepted Answer

A restrict extracts selected rows from a

Question 2

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 3

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 4

Give three examples that illustrate how cardinality reflects an organization's underlying business rules.

Accepted Answer

1)When an organization decides to purcha

Question 5

In a relational database

Accepted Answer

A)  the user's view of the physical database is the same as the physical database 
B)  users perceive that they are manipulating a single table 
C)  a virtual table exists in the form of rows and columns of a table stored on the disk 
D)  a programming language (COBOL) is used to create a user's view of the database 
A)  the user's view of the physical database is the same as the physical database 
B)  users perceive that they are manipulating a single table 
C)  a virtual table exists in the form of rows and columns of a table stored on the disk 
D)  a programming language (COBOL) is used to create a user's view of the database

Question 6

The deletion anomaly is the least important of the problems affecting unnormalized databases.

Accepted Answer

A) True 
 B)False

Question 7

In a hierarchical model

Accepted Answer

A)  links between related records are implicit 
B)  the way to access data is by following a predefined data path 
C)  an owner (parent) record may own just one member (child) record 
D)  a member (child) record may have more than one owner (parent) 
A)  links between related records are implicit 
B)  the way to access data is by following a predefined data path 
C)  an owner (parent) record may own just one member (child) record 
D)  a member (child) record may have more than one owner (parent)

Question 8

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 9

What are the characteristics of a properly designed relational database table?

Accepted Answer

The characteristics of a properly design

Question 10

The data definition language is used to insert special database commands into application programs.

Accepted Answer

A) True 
 B)False

Question 11

There is more than one conceptual view of the database.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

What is a database lockout?

Accepted Answer

To achieve data currency,simultaneous ac

Question 14

Distinguish between a database lockout and a deadlock.

Accepted Answer

To achieve data currency,simultaneous ac

Question 15

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

Accepted Answer

Users are the individuals in the organiz

Question 16

The database management system provides a controlled environment for accessing the database.

Accepted Answer

A) True 
 B)False

Question 17

Use the following words to complete the sentences.
  
-The ____________________ allows users to retrieve and modify data easily.

Accepted Answer

The answer of Use the following words to complete the...

Question 18

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 19

In the relational model,a data element is called a relation.

Accepted Answer

A) True 
 B)False

Question 20

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

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

Which term is not associated with the relational database model?

A replicated database is appropriate when

Give three examples that illustrate how cardinality reflects an organization's underlying business rules.

In a relational database

The deletion anomaly is the least important of the problems affecting unnormalized databases.

In a hierarchical model

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

What are the characteristics of a properly designed relational database table?

The data definition language is used to insert special database commands into application programs.

There is more than one conceptual view of the database.

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

What is a database lockout?

Distinguish between a database lockout and a deadlock.

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

The database management system provides a controlled environment for accessing the database.

Use the following words to complete the sentences. -The ____________________ allows users to retrieve and modify data easily.

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

In the relational model,a data element is called a relation.

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

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

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

Which term is not associated with the relational database model?

A replicated database is appropriate when

Give three examples that illustrate how cardinality reflects an organization's underlying business rules.

In a relational database

The deletion anomaly is the least important of the problems affecting unnormalized databases.

In a hierarchical model

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

What are the characteristics of a properly designed relational database table?

The data definition language is used to insert special database commands into application programs.

There is more than one conceptual view of the database.

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

What is a database lockout?

Distinguish between a database lockout and a deadlock.

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

The database management system provides a controlled environment for accessing the database.

Use the following words to complete the sentences. -The ____________________ allows users to retrieve and modify data easily.

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

In the relational model,a data element is called a relation.

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

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