Question 1

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

Question 2

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  True

Question 3

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

Accepted Answer

A) True 
 B)False  False

Question 4

List the steps involved in creating a relational database using a top-down approach.

Accepted Answer

1.Identify the views to be modeled.
2.No

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

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 7

Each of the following is a relational algebra function except

Accepted Answer

A) join 
B) project 
C) link 
D) restrict 
A) join 
B) project 
C) link 
D) restrict

Question 8

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

Accepted Answer

The partitioned database approach splits

Question 9

Users access the database

Accepted Answer

A) by direct query 
B) by developing operating software 
C) by constantly interacting with systems programmers 
D) all of the above 
A) by direct query 
B) by developing operating software 
C) by constantly interacting with systems programmers 
D) all of the above

Question 10

Use the following words to complete the sentences.
 
-The __________________________ describes every data element in the database.

Accepted Answer

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

Question 11

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 12

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 13

Discuss the hierarchical database model.What limitation(s)of the hierarchical database model are solved by the network database model?

Accepted Answer

The earliest DBMS were based on the hier

Question 14

Use the following words to complete the sentences.
 
-_________________________ occurs when a specific file is reproduced for each user who needs access to the file.

Accepted Answer

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

Question 15

A user view

Accepted Answer

A) presents the physical arrangement of records in a database for a particular user 
B) is the logical abstract structure of the database 
C) specifies the relationship of data elements in the database 
D) defines how a particular user sees the database 
A) presents the physical arrangement of records in a database for a particular user 
B) is the logical abstract structure of the database 
C) specifies the relationship of data elements in the database 
D) defines how a particular user sees the database

Question 16

Use the following words to complete the sentences.
 
-The conceptual view of the database is often called ____________________.

Accepted Answer

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

Question 17

What is repeating group data?

Accepted Answer

Repeating group data is the ex

Question 18

Which of the following is not one of four interrelated components of the database concept?

Accepted Answer

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

Question 19

Discuss the accountant's role in data modeling and potential problems caused by anomalies.

Accepted Answer

Most accountants will not be directly re

Question 20

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

In a hierarchical model

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.

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

List the steps involved in creating a relational database using a top-down approach.

The update anomaly in unnormalized databases

Which statement is false?

Each of the following is a relational algebra function except

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

Users access the database

Use the following words to complete the sentences. -The __________________________ describes every data element in the database.

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

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?

Discuss the hierarchical database model.What limitation(s)of the hierarchical database model are solved by the network database model?

Use the following words to complete the sentences. -_________________________ occurs when a specific file is reproduced for each user who needs access to the file.

A user view

Use the following words to complete the sentences. -The conceptual view of the database is often called ____________________.

What is repeating group data?

Which of the following is not one of four interrelated components of the database concept?

Discuss the accountant's role in data modeling and potential problems caused by anomalies.

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

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

In a hierarchical model

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.

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

List the steps involved in creating a relational database using a top-down approach.

The update anomaly in unnormalized databases

Which statement is false?

Each of the following is a relational algebra function except

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

Users access the database

Use the following words to complete the sentences. -The __________________________ describes every data element in the database.

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

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?

Discuss the hierarchical database model.What limitation(s)of the hierarchical database model are solved by the network database model?

Use the following words to complete the sentences. -_________________________ occurs when a specific file is reproduced for each user who needs access to the file.

A user view

Use the following words to complete the sentences. -The conceptual view of the database is often called ____________________.

What is repeating group data?

Which of the following is not one of four interrelated components of the database concept?

Discuss the accountant's role in data modeling and potential problems caused by anomalies.

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

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