Question 1

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 C

Question 2

What services are provided by a database management system?

Accepted Answer

Database management systems typically provide the following services: a.program development which permits both programmers and end users to create applications to access the database; b.backup and recovery is built in therefore reducing likelihood of data loss; c.database usage reporting captures statistics on what data is being used,by whom,when; and especially d.database access is provided to authorized users.

Question 3

Why are the hierarchical and network models called navigational databases?

Accepted Answer

These are called navigational models because traversing or searching them requires following a predefined path which is established through explicit linkages between related records.

Question 4

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 5

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 6

What is the relationship between a database table and a user view?

Accepted Answer

User views are derived databas

Question 7

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 8

What is a partial dependency?

Accepted Answer

A partial dependency occurs when one or

Question 9

Data concurrency

Accepted Answer

A)  is a security issue in partitioned databases 
B)  is implemented using timestamping 
C)  may result in data lockout 
D)  occurs when a deadlock is triggered 
A)  is a security issue in partitioned databases 
B)  is implemented using timestamping 
C)  may result in data lockout 
D)  occurs when a deadlock is triggered

Question 10

Describe a specific data element,entity,and record type in the expenditure cycle.

Accepted Answer

data element: vendor's name or

Question 11

The task of searching the database to locate a stored record for processing is called

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 12

Which of the following is not a responsibility of the database management system?

Accepted Answer

A)  provide an interface between the users and the physical database 
B)  provide security against a natural disaster 
C)  ensure that the internal schema and external schema are consistent 
D)  authorize access to portions of the database 
A)  provide an interface between the users and the physical database 
B)  provide security against a natural disaster 
C)  ensure that the internal schema and external schema are consistent 
D)  authorize access to portions of the database

Question 13

A description of the physical arrangement of records in the database is

Accepted Answer

A)  the internal view 
B)  the conceptual view 
C)  the subschema 
D)  the external view 
A)  the internal view 
B)  the conceptual view 
C)  the subschema 
D)  the external view

Question 14

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

Accepted Answer

1)When an organization decides to purcha

Question 15

What is a database lockout?

Accepted Answer

To achieve data currency,simultaneous ac

Question 16

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 17

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

Question 18

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 19

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 20

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)

The data manipulation language

What services are provided by a database management system?

Why are the hierarchical and network models called navigational databases?

The deletion anomaly in unnormalized databases

In the relational database model

What is the relationship between a database table and a user view?

Which term is not associated with the relational database model?

What is a partial dependency?

Data concurrency

Describe a specific data element,entity,and record type in the expenditure cycle.

The task of searching the database to locate a stored record for processing is called

Which of the following is not a responsibility of the database management system?

A description of the physical arrangement of records in the database is

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

What is a database lockout?

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

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

Which of the following is a relational algebra function?

A replicated database is appropriate when

In a hierarchical model

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

The data manipulation language

What services are provided by a database management system?

Why are the hierarchical and network models called navigational databases?

The deletion anomaly in unnormalized databases

In the relational database model

What is the relationship between a database table and a user view?

Which term is not associated with the relational database model?

What is a partial dependency?

Data concurrency

Describe a specific data element,entity,and record type in the expenditure cycle.

The task of searching the database to locate a stored record for processing is called

Which of the following is not a responsibility of the database management system?

A description of the physical arrangement of records in the database is

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

What is a database lockout?

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

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

Which of the following is a relational algebra function?

A replicated database is appropriate when

In a hierarchical model

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