Question 1

Which characteristic is not associated with the database approach to data management?

Accepted Answer

A) the ability to process data without the help of a programmer 
B) the ability to control access to the data 
C) constant production of backups 
D) the inability to determine what data is available 
A) the ability to process data without the help of a programmer 
B) the ability to control access to the data 
C) constant production of backups 
D) the inability to determine what data is available

Question 2

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

Accepted Answer

A restrict extracts selected rows from a

Question 3

What is view integration?

Accepted Answer

A modern company uses hundreds

Question 4

Which of the following may provide many distinct views of the database?

Accepted Answer

A) the schema 
B) the internal view 
C) the user view 
D) the conceptual view 
A) the schema 
B) the internal view 
C) the user view 
D) the conceptual view

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

What typical features are provided by a database management system (DBMS)?

Accepted Answer

1.Program development which permits both

Question 8

When is a table in third normal form (3NF)?

Accepted Answer

A table is in third normal form when it

Question 9

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 10

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

Accepted Answer

database a

Question 11

In a distributed data processing system,a database can be centralized or distributed.Explain each.

Accepted Answer

When the database is centralized,the ent

Question 12

A join builds a new table from two tables consisting of all concatenated pairs of rows from each table.

Accepted Answer

A) True 
 B)False

Question 13

If an organization uses a commercial database management system,its systems developers will likely use a bottom-up approach to data modeling.

Accepted Answer

A) True 
 B)False

Question 14

How is a database deadlock usually resolved? What are factors that influence the decision made regarding the transactions?

Accepted Answer

Resolving a deadlock usually involves sa

Question 15

What control maintains complete,current,and consistent data at all information processing units?

Accepted Answer

A) deadlock control 
B) replication control 
C) concurrency control 
D) gateway control 
A) deadlock control 
B) replication control 
C) concurrency control 
D) gateway control

Question 16

What are the problems with the flat-file approach? How does the database approach solve them?

Accepted Answer

Data redundancy causes significant data

Question 17

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

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 20

Why are the hierarchical and network models called navigational databases?

Accepted Answer

These are called navigational

Which characteristic is not associated with the database approach to data management?

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

What is view integration?

Which of the following may provide many distinct views of the database?

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

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

What typical features are provided by a database management system (DBMS)?

When is a table in third normal form (3NF)?

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

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

In a distributed data processing system,a database can be centralized or distributed.Explain each.

A join builds a new table from two tables consisting of all concatenated pairs of rows from each table.

If an organization uses a commercial database management system,its systems developers will likely use a bottom-up approach to data modeling.

How is a database deadlock usually resolved? What are factors that influence the decision made regarding the transactions?

What control maintains complete,current,and consistent data at all information processing units?

What are the problems with the flat-file approach? How does the database approach solve them?

Data concurrency

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

The data definition language

Why are the hierarchical and network models called navigational databases?

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

Which characteristic is not associated with the database approach to data management?

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

What is view integration?

Which of the following may provide many distinct views of the database?

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

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

What typical features are provided by a database management system (DBMS)?

When is a table in third normal form (3NF)?

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

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

In a distributed data processing system,a database can be centralized or distributed.Explain each.

A join builds a new table from two tables consisting of all concatenated pairs of rows from each table.

If an organization uses a commercial database management system,its systems developers will likely use a bottom-up approach to data modeling.

How is a database deadlock usually resolved? What are factors that influence the decision made regarding the transactions?

What control maintains complete,current,and consistent data at all information processing units?

What are the problems with the flat-file approach? How does the database approach solve them?

Data concurrency

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

The data definition language

Why are the hierarchical and network models called navigational databases?

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