Question 1

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 2

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 conceptual view of the database is often called ____________________.

Accepted Answer

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

Question 3

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 4

Time stamping is a control that is used to ensure database partitioning.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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 7

What are two types of distributed databases?

Accepted Answer

Partitione

Question 8

Data access methods allow records to be located, stored and retrieved. .

Accepted Answer

A) True 
 B)False

Question 9

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 10

What is the flat-file model?

Accepted Answer

The flat-file model describes

Question 11

What types of problems does data redundancy cause?

Accepted Answer

a. increased data storage because the sa

Question 12

All of the following are elements of the DBMS which facilitate user access to the database except

Accepted Answer

A)  query language 
B)  data access language 
C)  data manipulation language 
D)  data definition language 
A)  query language 
B)  data access language 
C)  data manipulation language 
D)  data definition language

Question 13

The data definition language is used to insert special database commands into application programs.

Accepted Answer

A) True 
 B)False

Question 14

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 ____________________ allows users to retrieve and modify data easily.

Accepted Answer

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

Question 15

The database management system provides a controlled environment for accessing the database.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

Which of the following is not a basic database backup and recovery feature?

Accepted Answer

A)  checkpoint 
B)  backup database 
C)  transaction log 
D)  database authority table 
A)  checkpoint 
B)  backup database 
C)  transaction log 
D)  database authority table

Question 18

What is a legacy system?

Accepted Answer

Legacy systems are large mainf

Question 19

What is a database authorization table?

Accepted Answer

The database authorization table contain

Question 20

Examining programmer authority tables for information about who has access to Data Definition Language commands will provide evidence about who is responsible for creating subschemas.

Accepted Answer

A) True 
 B)False

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

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 conceptual view of the database is often called ____________________.

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.

Time stamping is a control that is used to ensure database partitioning.

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

In a relational database

What are two types of distributed databases?

Data access methods allow records to be located, stored and retrieved. .

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

What is the flat-file model?

What types of problems does data redundancy cause?

All of the following are elements of the DBMS which facilitate user access to the database except

The data definition language is used to insert special database commands into application programs.

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 ____________________ allows users to retrieve and modify data easily.

The database management system provides a controlled environment for accessing the database.

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

Which of the following is not a basic database backup and recovery feature?

What is a legacy system?

What is a database authorization table?

Examining programmer authority tables for information about who has access to Data Definition Language commands will provide evidence about who is responsible for creating subschemas.

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 relational database model all of the following are true except

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 conceptual view of the database is often called ____________________.

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.

Time stamping is a control that is used to ensure database partitioning.

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

In a relational database

What are two types of distributed databases?

Data access methods allow records to be located, stored and retrieved. .

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

What is the flat-file model?

What types of problems does data redundancy cause?

All of the following are elements of the DBMS which facilitate user access to the database except

The data definition language is used to insert special database commands into application programs.

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 ____________________ allows users to retrieve and modify data easily.

The database management system provides a controlled environment for accessing the database.

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

Which of the following is not a basic database backup and recovery feature?

What is a legacy system?

What is a database authorization table?

Examining programmer authority tables for information about who has access to Data Definition Language commands will provide evidence about who is responsible for creating subschemas.

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