Question 1

All of the following are true about mirrored databases, except ____.

Accepted Answer

A)  it is not a good idea to have both copies of the database on the same disk 
B)  two copies of the entire database are maintained and both are updated simultaneously 
C)  the greater the distance between the two mirrored copies of the database, the greater the security 
D)  it is a relatively expensive proposition, but allows continuous operation in the event of a disk failure 
E)  it is an alternative to backward recovery

Question 2

Forward recovery uses as inputs the log and the last backup taken.

Accepted Answer

A) True 
 B)False

Question 3

Passwords should not be so difficult to remember that the person herself has to write them down, which is security exposure in itself because someone else could potentially see it.

Accepted Answer

A) True 
 B)False

Question 4

Passwords should appear on the terminal screen when they are typed in.

Accepted Answer

A) True 
 B)False

Question 5

The lost update problem can occur when ____.

Accepted Answer

A)  two users are trying to retrieve the same data simultaneously 
B)  one user is trying to retrieve data and another user is trying to update the same data simultaneously 
C)  two users are trying to update the same data simultaneously 
D)  All of the above. 
E)  None of the above.

Question 6

All of the following are types of data security breaches, except ____.

Accepted Answer

A)  unauthorized data access 
B)  unauthorized data modification 
C)  unauthorized data indexing 
D)  unauthorized program modification 
E)  malicious mischief

Question 7

Unauthorized data access and unauthorized data modification are two types of data security breaches.

Accepted Answer

A) True 
 B)False

Question 8

The Central Zoo maintains a modest information systems environment with a server and a LAN that connects all of the zoo's departments. It maintains a relational database that includes data about its animals, employees, members, and about a variety of infrastructure entities including the animals' enclosures.
a. Devise a data security strategy for the Central Zoo, incorporating appropriate data security measures.
b. Devise a backup and recovery strategy for the Central Zoo.
c. While Central Zoo's database is not subject to heavy update activity, it is possible that two employees could try to update the same record at the same time. Devise a strategy that will avoid data problems when this happens.

Accepted Answer

The answer of The Central Zoo maintains a modest information...

Question 9

A biometric security system is associated with ____.

Accepted Answer

A)  something a person knows 
B)  something a person has 
C)  some part of a person 
D)  some item of a person's clothing 
E)  something a person selects

Question 10

All of the following are true about computer viruses, except ____.

Accepted Answer

A)  they can travel from one computer to another on electric power lines 
B)  they can travel from one computer to another on diskettes 
C)  they can travel from one computer to another on telecommunications lines 
D)  they are capable of copying themselves 
E)  some are capable of corrupting data

Question 11

All of the following are characteristics of forward recovery, except ____.

Accepted Answer

A)  one of the inputs is the last database backup copy 
B)  one of the inputs is the log starting with the first change to the database after the last backup copy was made 
C)  one of the inputs is the current database 
D)  the recovery program makes changes to the backup copy in the same order in which the changes were originally made to the database 
E)  forward recovery is used to recover a destroyed table or database

Question 12

All of the following are disaster recovery tools or techniques, except ____.

Accepted Answer

A)  totally mirrored systems 
B)  hot sites 
C)  cold sites 
D)  multiple versions 
E)  reciprocal agreements

Question 13

A computer virus attack is the computer version of the old concept of "wiretapping."

Accepted Answer

A) True 
 B)False

Question 14

In public key encryption, one key is used to encrypt the data and another key is used to decrypt the data.

Accepted Answer

A) True 
 B)False

Question 15

A proxy server ____.

Accepted Answer

A)  is a software firewall that runs on the Web server 
B)  is designed to use signatures to decide which messages from the World Wide Web to allow to pass 
C)  is designed to test incoming messages from the World Wide Web and allow valid ones to pass through in their entirety 
D)  takes apart an incoming message from the World Wide Web and allows only legitimate pieces of data to go to the company's mainframe or application server 
E)  is built entirely of hardware and does not require specialized software

Question 16

All of the following are true about deadlock, except ____.

Accepted Answer

A)  deadlock can be detected by a resource usage matrix 
B)  deadlock can be detected with a timeout 
C)  the use of locks to prevent the lost update problem can cause deadlock 
D)  deadlock prevention is difficult 
E)  locks should never be used because of the potential for deadlock

Question 17

In the "mirrored databases" backup and recovery technique, two copies of the entire database are maintained and both are updated simultaneously.

Accepted Answer

A) True 
 B)False

Question 18

Backward recovery is an alternative to forward recovery for recreating a table that was destroyed.

Accepted Answer

A) True 
 B)False

Question 19

Recommended places to locate a mainframe computer or a cluster of servers include a building's basement and ground floor.

Accepted Answer

A) True 
 B)False

Question 20

In Secure Socket Layer (SSL) technology on the World Wide Web, a public key encryption algorithm is used to securely transfer a key for a private key encryption algorithm.

Accepted Answer

A) True 
 B)False

Exam 11: Database Control Issues: Security, Backup and Recovery, Concurrency

All of the following are true about mirrored databases, except ____.

Forward recovery uses as inputs the log and the last backup taken.

Passwords should not be so difficult to remember that the person herself has to write them down, which is security exposure in itself because someone else could potentially see it.

Passwords should appear on the terminal screen when they are typed in.

The lost update problem can occur when ____.

All of the following are types of data security breaches, except ____.

Unauthorized data access and unauthorized data modification are two types of data security breaches.

A biometric security system is associated with ____.

All of the following are true about computer viruses, except ____.

All of the following are characteristics of forward recovery, except ____.

All of the following are disaster recovery tools or techniques, except ____.

A computer virus attack is the computer version of the old concept of "wiretapping."

In public key encryption, one key is used to encrypt the data and another key is used to decrypt the data.

A proxy server ____.

All of the following are true about deadlock, except ____.

In the "mirrored databases" backup and recovery technique, two copies of the entire database are maintained and both are updated simultaneously.

Backward recovery is an alternative to forward recovery for recreating a table that was destroyed.

Recommended places to locate a mainframe computer or a cluster of servers include a building's basement and ground floor.

In Secure Socket Layer (SSL) technology on the World Wide Web, a public key encryption algorithm is used to securely transfer a key for a private key encryption algorithm.