Question 1

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 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

Which procedure will prevent two end users from accessing the same data element at the same time?

Accepted Answer

A) data redundancy 
B) data replication 
C) data lockout 
D) none of the above 
A) data redundancy 
B) data replication 
C) data lockout 
D) none of the above

Question 5

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 6

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 
A) free of repeating group data 
B) free of transitive dependencies 
C) free of partial dependencies 
D) free of deletion anomalies

Question 7

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 8

The physical database is an abstract representation of the database.

Accepted Answer

A) True 
 B)False

Question 9

Which statement is not correct? A query language like SQL

Accepted Answer

A) is written in a fourth-generation language 
B) requires user familiarity with COBOL 
C) allows users to retrieve and modify data 
D) reduces reliance on programmers 
A) is written in a fourth-generation language 
B) requires user familiarity with COBOL 
C) allows users to retrieve and modify data 
D) reduces reliance on programmers

Question 10

Explain the purpose of an ER diagram in database design.

Accepted Answer

The entity relationship (ER)diagram is t

Question 11

Task-data dependency is

Accepted Answer

A) failure to update the files of all users affected by a change 
B) another term for data redundancy 
C) user's inability to obtain additional information as needs change 
D) none of the above 
A) failure to update the files of all users affected by a change 
B) another term for data redundancy 
C) user's inability to obtain additional information as needs change 
D) none of the above

Question 12

What are the three data management problems caused by data redundancy?

Accepted Answer

data storage,date up

Question 13

What is a transitive dependency?

Accepted Answer

A transitive dependency occurs

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

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

Question 16

What is a partial dependency?

Accepted Answer

A partial dependency occurs when one or

Question 17

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 18

Timestamping is a control that is used to ensure database partitioning.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Which duty is not the responsibility of the database administrator?

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

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

Which procedure will prevent two end users from accessing the same data element at the same time?

An example of a distributed database is

A table is in third normal form when it is

Which statement is correct?

The physical database is an abstract representation of the database.

Which statement is not correct? A query language like SQL

Explain the purpose of an ER diagram in database design.

Task-data dependency is

What are the three data management problems caused by data redundancy?

What is a transitive dependency?

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

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

What is a partial dependency?

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

Timestamping is a control that is used to ensure database partitioning.

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

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

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 duty is not the responsibility of the database administrator?

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

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

Which procedure will prevent two end users from accessing the same data element at the same time?

An example of a distributed database is

A table is in third normal form when it is

Which statement is correct?

The physical database is an abstract representation of the database.

Which statement is not correct? A query language like SQL

Explain the purpose of an ER diagram in database design.

Task-data dependency is

What are the three data management problems caused by data redundancy?

What is a transitive dependency?

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

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

What is a partial dependency?

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

Timestamping is a control that is used to ensure database partitioning.

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

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

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