Question 1

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 2

The textbook refers to four interrelated components of the database concept.Which of the following is not one of the components?

Accepted Answer

A)  the database management system 
B)  the database sdministrator 
C)  the physical database 
D)  the conceptual database 
A)  the database management system 
B)  the database sdministrator 
C)  the physical database 
D)  the conceptual database

Question 3

What is a legacy system?

Accepted Answer

Legacy systems are large mainf

Question 4

In a direct access file system

Accepted Answer

A)  backups are created using the grandfather-father-son approach 
B)  processing a transaction file against a maser file creates a backup file 
C)  files are backed up immediately before an update run 
D)  if the master file is destroyed, it cannot be reconstructed 
A)  backups are created using the grandfather-father-son approach 
B)  processing a transaction file against a maser file creates a backup file 
C)  files are backed up immediately before an update run 
D)  if the master file is destroyed, it cannot be reconstructed

Question 5

Why are the hierarchical and network models called navigational databases?

Accepted Answer

These are called navigational

Question 6

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

Accepted Answer

In a distributed data processing system,

Question 7

What are the four primary elements of the database approach?

Accepted Answer

The users,the database managem

Question 8

In the relational model,a data element is called a relation.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following is not an access control in a database system?

Accepted Answer

A)  antivirus software 
B)  database authorization table 
C)  passwords 
D)  voice prints 
A)  antivirus software 
B)  database authorization table 
C)  passwords 
D)  voice prints

Question 10

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 11

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

Accepted Answer

The data dictionary describes every data

Question 12

An ER diagram is a graphical representation of a data model.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

Use the following words to complete the sentences in questions 1 through 5.
  
-_________________________ occurs when a specific file is reproduced for each user who needs access to the file.

Accepted Answer

The answer of Use the following words to complete the...

Question 15

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 16

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

Accepted Answer

A one-to-one association means that for

Question 17

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 18

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 19

What is the partitioned database approach and what are its advantages?

Accepted Answer

The partitioned database approach splits

Question 20

The physical database is an abstract representation of the database.

Accepted Answer

A) True 
 B)False

A replicated database is appropriate when

The textbook refers to four interrelated components of the database concept.Which of the following is not one of the components?

What is a legacy system?

In a direct access file system

Why are the hierarchical and network models called navigational databases?

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

What are the four primary elements of the database approach?

In the relational model,a data element is called a relation.

Which of the following is not an access control in a database system?

In the relational database model

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

An ER diagram is a graphical representation of a data model.

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

Use the following words to complete the sentences in questions 1 through 5. -_________________________ occurs when a specific file is reproduced for each user who needs access to the file.

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.

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

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

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

What is the partitioned database approach and what are its advantages?

The physical database is an abstract representation of the database.

Auditing and Internal Control

Auditing IT Governance Controls

Security Part I: Auditing Operating Systems and Networks

Systems Development and Program Change Activities

Overview of Transaction Processing and Financial Reporting Systems

Computer-Assisted Audit Tools and Techniques

Data Structures and CAATTs for Data Extraction

Auditing the Revenue Cycle

Auditing the Expenditure Cycle

Business Ethics, Fraud, and Fraud Detection

Enterprise Resource Planning Systems

Filters

Exam 4: IT Security Part II: Auditing Database Systems

A replicated database is appropriate when

The textbook refers to four interrelated components of the database concept.Which of the following is not one of the components?

What is a legacy system?

In a direct access file system

Why are the hierarchical and network models called navigational databases?

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

What are the four primary elements of the database approach?

In the relational model,a data element is called a relation.

Which of the following is not an access control in a database system?

In the relational database model

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

An ER diagram is a graphical representation of a data model.

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

Use the following words to complete the sentences in questions 1 through 5. -_________________________ occurs when a specific file is reproduced for each user who needs access to the file.

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.

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

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

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

What is the partitioned database approach and what are its advantages?

The physical database is an abstract representation of the database.

Auditing and Internal Control

Auditing IT Governance Controls

Security Part I: Auditing Operating Systems and Networks

Systems Development and Program Change Activities

Overview of Transaction Processing and Financial Reporting Systems

Computer-Assisted Audit Tools and Techniques

Data Structures and CAATTs for Data Extraction

Auditing the Revenue Cycle

Auditing the Expenditure Cycle

Business Ethics, Fraud, and Fraud Detection

Enterprise Resource Planning Systems

Filters