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

With the combination of the logical view and the SQL GRANT command, users either individually or in groups can be restricted to accessing only certain database tables or only certain data within a database table.

Of the following actions or events that can result in a breach of data security, the one that is not necessarily deliberate is ____.

Damaged hardware can result in unusable or unavailable data.

Locks should never be used because of the possibility of deadlock.

The combination of views and the SQL GRANT command can do all of the following, except ____.

All of the following are types of data security (prevention) measures, except ____.

All of the following are true about antivirus software, except ____.

A basic backup and recovery task is maintaining a disk log or journal of all database data retrieval operations.

Forward recovery is used to recreate a table that was destroyed.

A proxy server is firewall software that resides in the Web server.

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

Of the following choices, the most advisable location for a mainframe computer or a group of servers in a 20 story office building is ____.

Data that has been encrypted has to be decrypted to be used again.

All of the following are good rules for employees to follow for data security purposes, except ____.

All of the following are methods of breaching data security, except ____.

Backward recovery uses as inputs the log (starting with the last change to the database) and the last backup taken.

The lost update problem can occur when two people attempt to update the same data simultaneously.

A computer virus is a malicious piece of software that has the goal of damaging hardware as a means of breaching data security.

Stealing disks is a method of breaching computer security.