Question 1

How does the database approach solve the problem of data redundancy?

Accepted Answer

Data redundancy is not a probl

Question 2

What is a database authorization table?

Accepted Answer

The database authorization table contain

Question 3

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 
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 4

Which backup technique is most appropriate for sequential batch systems?

Accepted Answer

A)  grandparent-parent-child approach 
B)  staggered backup approach 
C)  direct backup 
D)  remote site, intermittent backup 
A)  grandparent-parent-child approach 
B)  staggered backup approach 
C)  direct backup 
D)  remote site, intermittent backup

Question 5

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 6

All of the following are basic data management tasks except

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

Question 7

Distinguish between a database lockout and a deadlock.

Accepted Answer

To achieve data currency,simultaneous ac

Question 8

Under the database approach,data is viewed as proprietary or owned by users.

Accepted Answer

A) True 
 B)False

Question 9

In the relational database model all of the following are true except

Accepted Answer

A)  data is presented to users as tables 
B)  data can be extracted from specified rows from specified tables 
C)  a new table can be built by joining two tables 
D)  only one-to-many relationships can be supported 
A)  data is presented to users as tables 
B)  data can be extracted from specified rows from specified tables 
C)  a new table can be built by joining two tables 
D)  only one-to-many relationships can be supported

Question 10

A recovery module suspends all data processing while the system reconciles its journal files against the database.

Accepted Answer

A) True 
 B)False

Question 11

The data manipulation language

Accepted Answer

A)  defines the database to the database management system 
B)  transfers data to the buffer area for manipulation 
C)  enables application programs to interact with and manipulate the database 
D)  describes every data element in the database 
A)  defines the database to the database management system 
B)  transfers data to the buffer area for manipulation 
C)  enables application programs to interact with and manipulate the database 
D)  describes every data element in the database

Question 12

What services are provided by a database management system?

Accepted Answer

Database management systems typically pr

Question 13

One purpose of a database system is the easy sharing of data.But this ease of sharing can also jeopardize security.Discuss at least three forms of access control designed to reduce this risk.

Accepted Answer

Many types of access control are possibl

Question 14

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 
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 15

Which term is not associated with the relational database model?

Accepted Answer

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

Question 16

Which of the following is a level of the database that is defined by the data definition language?

Accepted Answer

A)  user view 
B)  schema 
C)  internal view 
D)  all are levels or views of the database 
A)  user view 
B)  schema 
C)  internal view 
D)  all are levels or views of the database

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

There is more than one conceptual view of the database.

Accepted Answer

A) True 
 B)False

Question 19

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 con

Question 20

What are the four elements of the database approach? Explain the role of each.

Accepted Answer

Users are the individuals in the organiz

How does the database approach solve the problem of data redundancy?

What is a database authorization table?

The data definition language

Which backup technique is most appropriate for sequential batch systems?

Which duty is not the responsibility of the database administrator?

All of the following are basic data management tasks except

Distinguish between a database lockout and a deadlock.

Under the database approach,data is viewed as proprietary or owned by users.

In the relational database model all of the following are true except

A recovery module suspends all data processing while the system reconciles its journal files against the database.

The data manipulation language

What services are provided by a database management system?

One purpose of a database system is the easy sharing of data.But this ease of sharing can also jeopardize security.Discuss at least three forms of access control designed to reduce this risk.

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

Which term is not associated with the relational database model?

Which of the following is a level of the database that is defined by the data definition language?

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

There is more than one conceptual view 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?

What are the four elements of the database approach? Explain the role of each.

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

How does the database approach solve the problem of data redundancy?

What is a database authorization table?

The data definition language

Which backup technique is most appropriate for sequential batch systems?

Which duty is not the responsibility of the database administrator?

All of the following are basic data management tasks except

Distinguish between a database lockout and a deadlock.

Under the database approach,data is viewed as proprietary or owned by users.

In the relational database model all of the following are true except

A recovery module suspends all data processing while the system reconciles its journal files against the database.

The data manipulation language

What services are provided by a database management system?

One purpose of a database system is the easy sharing of data.But this ease of sharing can also jeopardize security.Discuss at least three forms of access control designed to reduce this risk.

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

Which term is not associated with the relational database model?

Which of the following is a level of the database that is defined by the data definition language?

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

There is more than one conceptual view 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?

What are the four elements of the database approach? Explain the role of each.

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