Question 1

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 
A)  data deletion 
B)  data storage 
C)  data attribution 
D)  data retrieval D

Question 2

Use the following words to complete the sentences in questions 1 through 5.
  
-The ____________________ allows users to retrieve and modify data easily.

Accepted Answer

query language

Question 3

A join builds a new table by creating links.

Accepted Answer

A) True 
 B)False  False

Question 4

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

Accepted Answer

A)  the ability to process data without the help of a programmer 
B)  the ability to control access to the data 
C)  constant production of backups 
D)  the inability to determine what data is available 
A)  the ability to process data without the help of a programmer 
B)  the ability to control access to the data 
C)  constant production of backups 
D)  the inability to determine what data is available

Question 5

In a hierarchical model

Accepted Answer

A)  links between related records are implicit 
B)  the way to access data is by following a predefined data path. 
C)  an owner (parent) record may own just one member (child) record 
D)  a member (child) record may have more than one owner (parent) 
A)  links between related records are implicit 
B)  the way to access data is by following a predefined data path. 
C)  an owner (parent) record may own just one member (child) record 
D)  a member (child) record may have more than one owner (parent)

Question 6

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 
A)  biometric controls 
B)  encryption controls 
C)  backup controls 
D)  inference controls

Question 7

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 8

The term occurrence is used to describe the number of attributes or fields pertaining to a specific entity.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

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

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

Accepted Answer

The primary justification for a replicat

Question 13

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 
A)  by direct query 
B)  by developing operating software 
C)  by constantly interacting with systems programmers 
D)  all of the above

Question 14

A lockout is a software control that prevents multiple users from simultaneous access to data.

Accepted Answer

A) True 
 B)False

Question 15

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 16

In a relational database

Accepted Answer

A)  the user's view of the physical database is the same as the physical database 
B)  users perceive that they are manipulating a single table 
C)  a virtual table exists in the form of rows and columns of a table stored on the disk 
D)  a programming language (COBOL) is used to create a user's view of the database 
A)  the user's view of the physical database is the same as the physical database 
B)  users perceive that they are manipulating a single table 
C)  a virtual table exists in the form of rows and columns of a table stored on the disk 
D)  a programming language (COBOL) is used to create a user's view of the database

Question 17

What is DML?

Accepted Answer

DML is the proprietary databas

Question 18

All of the following are advantages of a partitioned database except

Accepted Answer

A)  increased user control by having the data stored locally 
B)  deadlocks are eliminated 
C)  transaction processing response time is improved 
D)  partitioning can reduce losses in case of disaster 
A)  increased user control by having the data stored locally 
B)  deadlocks are eliminated 
C)  transaction processing response time is improved 
D)  partitioning can reduce losses in case of disaster

Question 19

All of the following tests of controls will provide evidence that access to the data files is limited except

Accepted Answer

A)  inspecting biometric controls 
B)  reconciling program version numbers 
C)  comparing job descriptions with access privileges stored in the authority table 
D)  attempting to retrieve unauthorized data via inference queries 
A)  inspecting biometric controls 
B)  reconciling program version numbers 
C)  comparing job descriptions with access privileges stored in the authority table 
D)  attempting to retrieve unauthorized data via inference queries

Question 20

Describe two tests of controls that would provide evidence that the database management system is protected against unauthorized access attempts.

Accepted Answer

compare job descriptions with authority

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

Use the following words to complete the sentences in questions 1 through 5. -The ____________________ allows users to retrieve and modify data easily.

A join builds a new table by creating links.

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

In a hierarchical model

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

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

The term occurrence is used to describe the number of attributes or fields pertaining to a specific entity.

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

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

Which statement is not correct? A query language like SQL

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

Users access the database

A lockout is a software control that prevents multiple users from simultaneous access to data.

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

In a relational database

What is DML?

All of the following are advantages of a partitioned database except

All of the following tests of controls will provide evidence that access to the data files is limited except

Describe two tests of controls that would provide evidence that the database management system is protected against unauthorized access attempts.

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

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

Use the following words to complete the sentences in questions 1 through 5. -The ____________________ allows users to retrieve and modify data easily.

A join builds a new table by creating links.

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

In a hierarchical model

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

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

The term occurrence is used to describe the number of attributes or fields pertaining to a specific entity.

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

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

Which statement is not correct? A query language like SQL

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

Users access the database

A lockout is a software control that prevents multiple users from simultaneous access to data.

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

In a relational database

What is DML?

All of the following are advantages of a partitioned database except

All of the following tests of controls will provide evidence that access to the data files is limited except

Describe two tests of controls that would provide evidence that the database management system is protected against unauthorized access attempts.

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