Question 1

Which of the following is not a common form of conceptual database model?

Accepted Answer

A)  hierarchical 
B)  network 
C)  sequential 
D)  relational 
A)  hierarchical 
B)  network 
C)  sequential 
D)  relational

Question 2

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 3

Explain a database lockout and the deadlock phenomenon. Contrast that to concurrency control and the timestamping technique. Describe the importance of these items in relation to database integrity.

Accepted Answer

In a centralized database, a lockout is

Question 4

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}$
-The __________________________ describes every data element in the database.

Accepted Answer

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

Question 5

The physical database is an abstract representation of the database.

Accepted Answer

A) True 
 B)False

Question 6

What is a database lockout?

Accepted Answer

To achieve data currency, simultaneous a

Question 7

Why are the hierarchical and network models called navigational databases?

Accepted Answer

These are called navigational

Question 8

Subschemas are used to authorize user access privileges to specific data elements.

Accepted Answer

A) True 
 B)False

Question 9

What services are provided by a database management system?

Accepted Answer

Database management systems typically pr

Question 10

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

Accepted Answer

Data redundancy is not a probl

Question 11

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}$
-The __________________________ authorizes access to the database.

Accepted Answer

database a

Question 12

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 13

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 14

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 15

A major difference between the database and flat-file models is the pooling of data into a common shared database.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

There is more than one conceptual view of the database.

Accepted Answer

A) True 
 B)False

Question 18

Discuss the key factors to consider in determining how to partition a corporate database.

Accepted Answer

The partitioned approach works best for

Question 19

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

Accepted Answer

The partitioned database approach splits

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

Which of the following is not a common form of conceptual database model?

The data manipulation language

Explain a database lockout and the deadlock phenomenon. Contrast that to concurrency control and the timestamping technique. Describe the importance of these items in relation to database integrity.

Use the following words to complete the sentences in question(s). database administrator data dictionary data redundancy index sequential access method query language schema sequential structure subschema -The __________________________ describes every data element in the database.

The physical database is an abstract representation of the database.

What is a database lockout?

Why are the hierarchical and network models called navigational databases?

Subschemas are used to authorize user access privileges to specific data elements.

What services are provided by a database management system?

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

Use the following words to complete the sentences in question(s). database administrator data dictionary data redundancy index sequential access method query language schema sequential structure subschema -The __________________________ authorizes access to the database.

Which duty is not the responsibility of the database administrator?

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

In a direct access file system

A major difference between the database and flat-file models is the pooling of data into a common shared database.

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

There is more than one conceptual view of the database.

Discuss the key factors to consider in determining how to partition a corporate database.

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

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

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

Which of the following is not a common form of conceptual database model?

The data manipulation language

Explain a database lockout and the deadlock phenomenon. Contrast that to concurrency control and the timestamping technique. Describe the importance of these items in relation to database integrity.

Use the following words to complete the sentences in question(s). database administrator data dictionary data redundancy index sequential access method query language schema sequential structure subschema -The __________________________ describes every data element in the database.

The physical database is an abstract representation of the database.

What is a database lockout?

Why are the hierarchical and network models called navigational databases?

Subschemas are used to authorize user access privileges to specific data elements.

What services are provided by a database management system?

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

Use the following words to complete the sentences in question(s). database administrator data dictionary data redundancy index sequential access method query language schema sequential structure subschema -The __________________________ authorizes access to the database.

Which duty is not the responsibility of the database administrator?

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

In a direct access file system

A major difference between the database and flat-file models is the pooling of data into a common shared database.

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

There is more than one conceptual view of the database.

Discuss the key factors to consider in determining how to partition a corporate database.

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

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

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