Question 1

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

Accepted Answer

A) True 
 B)False  False

Question 2

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

Accepted Answer

The most apparent difference between the relational model and navigational models is the way that data associations are represented to the user. In navigational models, data are represented in tree structures or network structures. The navigational database models have explicit links, called pointers, between records. Data are accessed using defined data paths.
The relational model portrays data in the form of two-dimensional tables. Users do not perceive any pointers linking the tables. At the conceptual level (logical view) and the external level (user's view), data are represented only as tables. Relations between tables are formed by an attribute (data element) that is common to the tables. This attribute is a primary key in one table and a foreign key in the other.
The relational model is more flexible than a navigational model. Users can obtain data from the database by using the primary key and a database query language. Typically users do not require assistance from programmers to obtain answers to ad hoc queries.

Question 3

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 B

Question 4

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 administrator 
C)  the physical database 
D)  the conceptual database 
A)  the database management system 
B)  the database administrator 
C)  the physical database 
D)  the conceptual database

Question 5

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 6

What flat-file data management problems are solved as a result of using the database concept?

Accepted Answer

a. no data redundancy
b. singl

Question 7

Data concurrency

Accepted Answer

A)  is a security issue in partitioned databases 
B)  is implemented using time stamping 
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 time stamping 
C)  may result in data lockout 
D)  occurs when a deadlock is triggered

Question 8

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 9

Explain the relationship between the three levels of the data definition language. As a user, which level would you be most interested in?

Accepted Answer

One level is the schema, which is the co

Question 10

Use the following words to complete the sentences in question(s).
 $\begin{array}{ll}
\text { database administrator } & \text { data dictionary } \
\text { data redundancy } & \text { index sequential access method } \
\text { query language } & \text { schema } \
\text { sequential structure } & \text { subschema }
\end{array}$
-_________________________ 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 11

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 12

What are four ways in which database management systems provide a controlled environment to manage user access and the data resources?

Accepted Answer

Program development,

Question 13

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 14

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 15

What are the four primary elements of the database approach?

Accepted Answer

The users, the database manage

Question 16

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 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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 20

Explain the three views of a database.

Accepted Answer

The unique internal view of the database

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

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

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?

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.

What flat-file data management problems are solved as a result of using the database concept?

Data concurrency

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

Explain the relationship between the three levels of the data definition language. As a user, which level would you be most interested in?

Which statement is not correct? A query language like SQL

What are four ways in which database management systems provide a controlled environment to manage user access and the data resources?

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

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

What are the four primary elements of the database approach?

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

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

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

In the relational database model

Explain the three views of a database.

Auditing and Internal Control

Auditing IT Governance Controls

Auditing Operating Systems and Networks

Systems Development and Program Change Activities

Transaction Processing and Financial Reporting Systems Overview

Computer Assisted Audit Tools and Techniques

Data Structures and Caatts for Data Extraction

Auditing the Revenue Cycle

Auditing the Expenditure Cycle

Enterprise Resource Planning Systems

Business Ethics, Fraud, and Fraud Detection

Filters

Exam 4: Auditing Database Systems

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

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

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?

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.

What flat-file data management problems are solved as a result of using the database concept?

Data concurrency

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

Explain the relationship between the three levels of the data definition language. As a user, which level would you be most interested in?

Which statement is not correct? A query language like SQL

What are four ways in which database management systems provide a controlled environment to manage user access and the data resources?

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

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

What are the four primary elements of the database approach?

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

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

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

In the relational database model

Explain the three views of a database.

Auditing and Internal Control

Auditing IT Governance Controls

Auditing Operating Systems and Networks

Systems Development and Program Change Activities

Transaction Processing and Financial Reporting Systems Overview

Computer Assisted Audit Tools and Techniques

Data Structures and Caatts for Data Extraction

Auditing the Revenue Cycle

Auditing the Expenditure Cycle

Enterprise Resource Planning Systems

Business Ethics, Fraud, and Fraud Detection

Filters