Question 1

Explain the three views of a database.

Accepted Answer

The unique internal view of the database

Question 2

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

Accepted Answer

Data redundancy is not a probl

Question 3

The deletion anomaly in unnormalized databases

Accepted Answer

A)  is easily detected by users 
B)  may result in the loss of important data 
C)  complicates adding records to the database 
D)  requires the user to perform excessive updates 
A)  is easily detected by users 
B)  may result in the loss of important data 
C)  complicates adding records to the database 
D)  requires the user to perform excessive updates

Question 4

Replicated databases create considerable data redundancy,which is in conflict with the database concept.Explain the justification of this approach.

Accepted Answer

The primary justification for a replicat

Question 5

What is view integration?

Accepted Answer

A modern company uses hundreds

Question 6

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 7

Explain how linkages between relational tables are accomplished.

Accepted Answer

Tables that are logically related in the

Question 8

In the database method of data management,access authority is maintained by systems programming.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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 11

Use the following words to complete the sentences.
  
-The __________________________ authorizes access to the database.

Accepted Answer

database a

Question 12

An example of a distributed database is

Accepted Answer

A)  partitioned database 
B)  centralized database 
C)  networked database 
D)  all are examples of distributed databases 
A)  partitioned database 
B)  centralized database 
C)  networked database 
D)  all are examples of distributed databases

Question 13

The data manipulation language

Accepted Answer

A)  defines the database to the database management system 
B)  transfers data to the buffer area for manipulation 
C)  enables application programs to interact with and manipulate the database 
D)  describes every data element in the database 
A)  defines the database to the database management system 
B)  transfers data to the buffer area for manipulation 
C)  enables application programs to interact with and manipulate the database 
D)  describes every data element in the database

Question 14

Explain the purpose of an ER diagram in database design.

Accepted Answer

The entity relationship (ER)diagram is t

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

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 17

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

Accepted Answer

A) True 
 B)False

Question 18

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 19

What is a partial dependency?

Accepted Answer

A partial dependency occurs when one or

Question 20

What are two types of distributed databases?

Accepted Answer

Partitione

Explain the three views of a database.

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

The deletion anomaly in unnormalized databases

Replicated databases create considerable data redundancy,which is in conflict with the database concept.Explain the justification of this approach.

What is view integration?

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

Explain how linkages between relational tables are accomplished.

In the database method of data management,access authority is maintained by systems programming.

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

Each of the following is a relational algebra function except

Use the following words to complete the sentences. -The __________________________ authorizes access to the database.

An example of a distributed database is

The data manipulation language

Explain the purpose of an ER diagram in database design.

A user view

In the relational database model

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

Entities are

What is a partial dependency?

What are two types of distributed databases?

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 three views of a database.

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

The deletion anomaly in unnormalized databases

Replicated databases create considerable data redundancy,which is in conflict with the database concept.Explain the justification of this approach.

What is view integration?

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

Explain how linkages between relational tables are accomplished.

In the database method of data management,access authority is maintained by systems programming.

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

Each of the following is a relational algebra function except

Use the following words to complete the sentences. -The __________________________ authorizes access to the database.

An example of a distributed database is

The data manipulation language

Explain the purpose of an ER diagram in database design.

A user view

In the relational database model

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

Entities are

What is a partial dependency?

What are two types of distributed databases?

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