Question 1

A table is in third normal form when it is

Accepted Answer

A)  free of repeating group data 
B)  free of transitive dependencies 
C)  free of partial dependencies 
D)  free of deletion anomalies 
E)  none of the above 
A)  free of repeating group data 
B)  free of transitive dependencies 
C)  free of partial dependencies 
D)  free of deletion anomalies 
E)  none of the above B

Question 2

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

Accepted Answer

User views are derived database tables.A single table may contribute data to several different views On the other hand,simple views may be constructed from a single table.

Question 3

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 D

Question 4

Which duty is not the responsibility of the database administrator?

Accepted Answer

A)  to develop and maintain the data dictionary 
B)  to implement security controls 
C)  to design application programs 
D)  to design the subschema 
A)  to develop and maintain the data dictionary 
B)  to implement security controls 
C)  to design application programs 
D)  to design the subschema

Question 5

Which statement is correct?

Accepted Answer

A)  in a normalized database, data about vendors occur in several locations 
B)  the accountant is responsible for database normalization 
C)  in a normalized database, deletion of a key record could result in the destruction of the audit trail 
D)  connections between M:M tables are provided by a link table 
A)  in a normalized database, data about vendors occur in several locations 
B)  the accountant is responsible for database normalization 
C)  in a normalized database, deletion of a key record could result in the destruction of the audit trail 
D)  connections between M:M tables are provided by a link table

Question 6

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 7

The database approach to data management is sometimes called the flat file approach.

Accepted Answer

A) True 
 B)False

Question 8

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

Question 9

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 10

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 11

Describe an environment in which a firm should use a partitioned database.

Accepted Answer

A partitioned database approac

Question 12

Data currency is preserved in a centralized database by

Accepted Answer

A)  partitioning the database 
B)  using a lockout procedure 
C)  replicating the database 
D)  implementing concurrency controls 
A)  partitioning the database 
B)  using a lockout procedure 
C)  replicating the database 
D)  implementing concurrency controls

Question 13

Contrast the navigational databases with relational databases.What is the primary advantage of the relational model?

Accepted Answer

The most apparent difference between the

Question 14

All of the following are elements of the DBMS which facilitate user access to the database except

Accepted Answer

A)  query language 
B)  data access language 
C)  data manipulation language 
D)  data definition language 
A)  query language 
B)  data access language 
C)  data manipulation language 
D)  data definition language

Question 15

What services are provided by a database management system?

Accepted Answer

Database management systems typically pr

Question 16

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 17

Why are the hierarchical and network models called navigational databases?

Accepted Answer

These are called navigational

Question 18

A lockout is a software control that prevents multiple users from simultaneous access to data.

Accepted Answer

A) True 
 B)False

Question 19

A table in third normal form is free of partial dependencies,multiple dependencies,and transitive dependencies.

Accepted Answer

A) True 
 B)False

Question 20

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

A table is in third normal form when it is

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

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

Which duty is not the responsibility of the database administrator?

Which statement is correct?

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

The database approach to data management is sometimes called the flat file approach.

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.

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

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

Describe an environment in which a firm should use a partitioned database.

Data currency is preserved in a centralized database by

Contrast the navigational databases with relational databases.What is the primary advantage of the relational model?

All of the following are elements of the DBMS which facilitate user access to the database except

What services are provided by a database management system?

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

Why are the hierarchical and network models called navigational databases?

A lockout is a software control that prevents multiple users from simultaneous access to data.

A table in third normal form is free of partial dependencies,multiple dependencies,and transitive dependencies.

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

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

A table is in third normal form when it is

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

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

Which duty is not the responsibility of the database administrator?

Which statement is correct?

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

The database approach to data management is sometimes called the flat file approach.

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.

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

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

Describe an environment in which a firm should use a partitioned database.

Data currency is preserved in a centralized database by

Contrast the navigational databases with relational databases.What is the primary advantage of the relational model?

All of the following are elements of the DBMS which facilitate user access to the database except

What services are provided by a database management system?

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

Why are the hierarchical and network models called navigational databases?

A lockout is a software control that prevents multiple users from simultaneous access to data.

A table in third normal form is free of partial dependencies,multiple dependencies,and transitive dependencies.

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

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