Question 1

What is a data dictionary, and what purpose does it serve?

Accepted Answer

The answer of What is a data dictionary, and what...

Question 2

Users access the database

Accepted Answer

A)  by direct query 
B)  by developing operating software 
C)  by constantly interacting with systems programmers 
D)  all of the above

Question 3

Discuss and give an example of one-to-one, one-to-many, and many-to-many record associations.

Accepted Answer

The answer of Discuss and give an example of one-to-one,...

Question 4

In a distributed data processing system, a database can be centralized or distributed. What are the options? Explain.

Accepted Answer

The answer of In a distributed data processing system, a...

Question 5

What is a replicated database and what are the advantages of this approach?

Accepted Answer

The answer of What is a replicated database and what...

Question 6

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

Question 7

Which term is not associated with the relational database model?

Accepted Answer

A)  tuple 
B)  attribute 
C)  collision 
D)  relation

Question 8

All of the following are basic data management tasks except

Accepted Answer

A)  data deletion 
B)  data storage 
C)  data attribution 
D)  data retrieval

Question 9

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

Question 10

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

Question 11

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

Accepted Answer

A)  data sharing 
B)  multiple storage procedures 
C)  data redundancy 
D)  excessive storage costs

Question 12

Audit objectives for the database management system include all of the following except

Accepted Answer

A)  verifying that the security group monitors and reports on fault tolerance violations 
B)  confirming that backup procedures are adequate 
C)  ensuring that authorized users access only those files they need to perform their duties 
D)  verifying that unauthorized users cannot access data files

Question 13

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

Accepted Answer

The answer of Replicated databases create considerable data redundancy, which...

Question 14

Which of the following is not a test of access controls?

Accepted Answer

A)  biometric controls 
B)  encryption controls 
C)  backup controls 
D)  inference controls

Question 15

Data normalization groups data attributes into tables in accordance with specific design objectives.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

A customer name and an unpaid balance is an example of a one-to-many relationship.

Accepted Answer

A) True 
 B)False

Question 19

The earliest DBAs were based on the hierarchical data model.

Accepted Answer

A) True 
 B)False

Question 20

What is the internal view of a database?

Accepted Answer

The answer of What is the internal view of a...

Exam 4: Auditing Database Systems

What is a data dictionary, and what purpose does it serve?

Users access the database

Discuss and give an example of one-to-one, one-to-many, and many-to-many record associations.

In a distributed data processing system, a database can be centralized or distributed. What are the options? Explain.

What is a replicated database and what are the advantages of this approach?

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

Which term is not associated with the relational database model?

All of the following are basic data management tasks except

The data definition language

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

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

Audit objectives for the database management system include all of the following except

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

Which of the following is not a test of access controls?

Data normalization groups data attributes into tables in accordance with specific design objectives.

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

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

A customer name and an unpaid balance is an example of a one-to-many relationship.

The earliest DBAs were based on the hierarchical data model.

What is the internal view of a database?