Question 1

Explain the three views of a database.

Accepted Answer

The unique internal view of the database

Question 2

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 3

An example of a distributed database is

Accepted Answer

A)  partitioned database 
B)  centralized database 
C)  networked database 
D)  all are examples of distributed databases 
A)  partitioned database 
B)  centralized database 
C)  networked database 
D)  all are examples of distributed databases

Question 4

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

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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 u

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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 9

Describe an environment in which a firm should use a partitioned database.

Accepted Answer

A partitioned database approac

Question 10

What is the flat-file model?

Accepted Answer

The flat-file model describes

Question 11

Use the following words to complete the sentences in questions 1 through 5.
  
-The __________________________ authorizes access to the database.

Accepted Answer

database a

Question 12

The database attributes that individual users have permission to access are defined in

Accepted Answer

A)  operating system. 
B)  user manual. 
C)  database schema. 
D)  user view. 
E)  application listing. 
A)  operating system. 
B)  user manual. 
C)  database schema. 
D)  user view. 
E)  application listing.

Question 13

Data concurrency

Accepted Answer

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

Question 14

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 15

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

Accepted Answer

The partitioned approach works best for

Question 16

Ownership of data in traditional legacy systems often leads to data redundancy.This in turn leads to several data management problems.What are they? How does the database approach solve them?

Accepted Answer

Data redundancy causes significant data

Question 17

Use the following words to complete the sentences in questions 1 through 5.
  
-The __________________________ describes every data element in the database.

Accepted Answer

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

Question 18

Which statement is false?

Accepted Answer

A)  The DBMS is special software that is programmed to know which data elements each user is authorized to access. 
B)  User programs send requests for data to the DBMS. 
C)  During processing, the DBMS periodically makes backup copies of the physical database. 
D)  The DBMS does not control access to the database. 
A)  The DBMS is special software that is programmed to know which data elements each user is authorized to access. 
B)  User programs send requests for data to the DBMS. 
C)  During processing, the DBMS periodically makes backup copies of the physical database. 
D)  The DBMS does not control access to the database.

Question 19

What types of problems does data redundancy cause?

Accepted Answer

a.increased data storage because the sam

Question 20

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

Accepted Answer

A)  data sharing 
B)  multiple storage procedures 
C)  data redundancy 
D)  excessive storage costs 
A)  data sharing 
B)  multiple storage procedures 
C)  data redundancy 
D)  excessive storage costs

Explain the three views of a database.

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

An example of a distributed database is

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.

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

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.

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

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

Describe an environment in which a firm should use a partitioned database.

What is the flat-file model?

Use the following words to complete the sentences in questions 1 through 5. -The __________________________ authorizes access to the database.

The database attributes that individual users have permission to access are defined in

Data concurrency

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

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

Ownership of data in traditional legacy systems often leads to data redundancy.This in turn leads to several data management problems.What are they? How does the database approach solve them?

Use the following words to complete the sentences in questions 1 through 5. -The __________________________ describes every data element in the database.

Which statement is false?

What types of problems does data redundancy cause?

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

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

Explain the three views of a database.

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

An example of a distributed database is

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.

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

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.

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

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

Describe an environment in which a firm should use a partitioned database.

What is the flat-file model?

Use the following words to complete the sentences in questions 1 through 5. -The __________________________ authorizes access to the database.

The database attributes that individual users have permission to access are defined in

Data concurrency

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

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

Ownership of data in traditional legacy systems often leads to data redundancy.This in turn leads to several data management problems.What are they? How does the database approach solve them?

Use the following words to complete the sentences in questions 1 through 5. -The __________________________ describes every data element in the database.

Which statement is false?

What types of problems does data redundancy cause?

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

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