Question 1

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 2

What are the key control implications of the absence of database normalization?

Accepted Answer

When considering the quality of the data

Question 3

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 4

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 5

What is a replicated database and what are the advantages of this approach?

Accepted Answer

The entire database is replicated at eac

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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 8

What is repeating group data?

Accepted Answer

Repeating group data is the ex

Question 9

Which of the following is a relational algebra function?

Accepted Answer

A)  restrict 
B)  project 
C)  join 
D)  all are relational algebra functions 
A)  restrict 
B)  project 
C)  join 
D)  all are relational algebra functions

Question 10

The data definition language

Accepted Answer

A)  identifies, for the database management system, the names and relationships of all data elements, records, and files that comprise the database 
B)  inserts database commands into application programs to enable standard programs to interact with and manipulate the database 
C)  permits users to process data in the database without the need for conventional programs 
D)  describes every data element in the database 
A)  identifies, for the database management system, the names and relationships of all data elements, records, and files that comprise the database 
B)  inserts database commands into application programs to enable standard programs to interact with and manipulate the database 
C)  permits users to process data in the database without the need for conventional programs 
D)  describes every data element in the database

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

All of the following are basic data management tasks except

Accepted Answer

A)  data deletion 
B)  data storage 
C)  data attribution 
D)  data retrieval 
A)  data deletion 
B)  data storage 
C)  data attribution 
D)  data retrieval

Question 13

An important feature associated with the traditional approach to data management is the ability to produce ad hoc reports.

Accepted Answer

A) True 
 B)False

Question 14

A deadlock is a phenomenon that prevents the processing of transactions.

Accepted Answer

A) True 
 B)False

Question 15

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 16

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

Accepted Answer

A) True 
 B)False

Question 17

A join builds a new table by creating links.

Accepted Answer

A) True 
 B)False

Question 18

What is the insertion anomaly?

Accepted Answer

Because of a table i

Question 19

What is the update anomaly?

Accepted Answer

The update anomaly results from data red

Question 20

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

Users access the database

What are the key control implications of the absence of database normalization?

Which statement is false?

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

What is a replicated database and what are the advantages of this approach?

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

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

What is repeating group data?

Which of the following is a relational algebra function?

The data definition language

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

All of the following are basic data management tasks except

An important feature associated with the traditional approach to data management is the ability to produce ad hoc reports.

A deadlock is a phenomenon that prevents the processing of transactions.

The most serious problem with unnormalized databases is the

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

A join builds a new table by creating links.

What is the insertion anomaly?

What is the update anomaly?

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

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

Users access the database

What are the key control implications of the absence of database normalization?

Which statement is false?

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

What is a replicated database and what are the advantages of this approach?

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

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

What is repeating group data?

Which of the following is a relational algebra function?

The data definition language

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

All of the following are basic data management tasks except

An important feature associated with the traditional approach to data management is the ability to produce ad hoc reports.

A deadlock is a phenomenon that prevents the processing of transactions.

The most serious problem with unnormalized databases is the

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

A join builds a new table by creating links.

What is the insertion anomaly?

What is the update anomaly?

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

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