Question 1

The combination of views and the SQL GRANT command can do all of the following, except ____.
A) limit access to a table
B) limit access to part of a table
C) restrict access to a table to read-only access
D) restrict access to a table to create a new table
E) restrict access to a table to read-only and update access

Accepted Answer

The SQL GRANT command with views can limit access to a table or part of a table, restrict access to a table to read-only access or read-only and update access. However, it cannot restrict access to a table to create a new table. This is not the purpose or function of the GRANT command or views.

Question 2

All of the following are types of data security breaches, except ____.
A) unauthorized data access
B) unauthorized data modification
C) unauthorized data indexing
D) unauthorized program modification
E) malicious mischief

Accepted Answer

Unauthorized data indexing is not a type of data security breach. It may be a way for unauthorized individuals to access data, but it is not a direct breach of security. The other options (A, B, D, and E) are all types of data security breaches.

Question 3

Of the following actions or events that can result in a breach of data security, the one that is not necessarily deliberate is ____.
A) unauthorized computer access
B) intercepting data communications
C) spreading computer viruses
D) stealing disks or computers
E) damaging computer hardware

Accepted Answer

Damaging computer hardware can result in a breach of data security but it may not necessarily be a deliberate action. It could be a result of accidental damage or malfunction. The other options listed all involve intentional actions that can result in a breach of data security.

Question 4

All of the following are characteristics of backward recovery, except ____.
A) one of the inputs is the last database backup copy
B) one of the inputs is the log starting with the last change to the database
C) one of the inputs is the current database
D) the roll backward program works on a last-in, first-out basis
E) after rolling backward, an automated procedure can roll forward

Accepted Answer

The answer of All of the following are characteristics of...

Question 5

A private key encryption algorithm ____.
A) can be used to encrypt data on a disk but not to encrypt data for transmission over telecommunications lines
B) executes faster than a public key encryption algorithm
C) is asymmetric
D) requires one key for encryption and another key for decryption
E) allows its encryption key to be openly published

Accepted Answer

Private key encryption algorithms, also known as symmetric key algorithms, are generally faster than public key (asymmetric) encryption algorithms because they use the same key for both encryption and decryption, which is computationally less intensive.

Question 6

A biometric security system is associated with ____.
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

Accepted Answer

A biometric security system uses a specific physical or behavioral characteristic of an individual, such as a fingerprint or iris pattern, to verify their identity. This falls under the category of "some part of a person."

Question 7

All of the following are true about computer viruses, except ____.
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

Accepted Answer

Computer viruses cannot travel from one computer to another on electric power lines. This statement is false.

Question 8

All of the following are true about antivirus software, except ____.
A) they use known portions of virus code to recognize known viruses
B) they must continually update their files of known viruses
C) they monitor the computer system for unusual activity
D) they permit software with the proper signatures on file to execute
E) they prevent certain commands from executing without further authorization

Accepted Answer

Antivirus software does not inherently permit software to execute based on having the proper signatures on file. Instead, it primarily focuses on detecting, preventing, and removing malware based on known virus signatures, unusual system behavior, and unauthorized commands. The concept of permitting software to execute because it has the proper signatures is more aligned with digital signature verification processes, not the primary function of antivirus software.

Question 9

All of the following are good rules for employees to follow for data security purposes, except ____.
A) don't take diskettes or other storage media out of the building
B) avoid using public key encryption because of the insecure nature of transmitting keys
C) don't write your computer password down anywhere
D) don't respond to any unusual requests for information about the computer system from anyone over the telephone
E) logoff your computer or at least lock your office door when you leave your office, even for just a few minutes

Accepted Answer

Avoiding the use of public key encryption is not a good rule for employees to follow as it is a secure method for transmitting keys. All of the other options are good rules for data security purposes.

Question 10

Which of the following is true regarding a transaction log?
A) It keeps a record of the program that changed the data and all of the inputs that the program used.
B) It records the value of a piece of data just before it is changed.
C) It records the value of a piece of data just after it is changed.
D) All of the above.
E) None of the above.

Accepted Answer

The answer of Which of the following is true regarding...

Question 11

All of the following are characteristics of forward recovery, except ____.
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

Accepted Answer

Forward recovery involves applying changes from logs to a backup copy of the database, not the current database itself.

Question 12

In Secure Socket Layer (SSL) technology on the World Wide Web ____.
A) the server, using a random number generator, creates a "session key," the key for the private key algorithm with which the secure transaction (the actual online shopping) will be conducted
B) the actual online shopping is conducted with a public key algorithm
C) the key with which the actual online shopping will be conducted is transmitted with a private key algorithm
D) the client sends the server its public key for its public key algorithm
E) a public key algorithm is used to transmit the "session key" for a private key algorithm with which the secure transaction (the actual online shopping) will be conducted

Accepted Answer

In SSL technology, a public key algorithm is used to transmit the "session key" for a private key algorithm with which the actual online shopping will be conducted. This ensures secure communication between the client and the server.

Question 13

Of the following choices, the most advisable location for a mainframe computer or a group of servers in a 20 story office building is ____.
A) the basement
B) the ground floor
C) floors two through eight
D) floors nine through nineteen
E) the top floor (floor twenty)

Accepted Answer

It is not advisable to place the mainframe computer or group of servers in the basement as there could be issues with flooding or humidity. The ground floor is also not advisable as it is more prone to security breaches and potential damage from external factors. The top floor is also not recommended as it could be difficult to access and maintain. Floors two through eight would be the most advisable location as it provides easy access and maintenance while also being more secure and less prone to external threats.

Question 14

All of the following are rules of thumb regarding creating a password, except ____.
A) it should not be too long
B) it should not be too short
C) it should not be obvious
D) it should have to be written down
E) it should not be too difficult to remember

Accepted Answer

All of the other options are rules of thumb for creating a strong password, but writing it down increases the risk of it falling into the wrong hands. A strong password should be long and complex, but also easy enough for the user to remember without having to write it down.

Question 15

All of the following are true about mirrored databases, except ____.
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

Accepted Answer

Mirrored databases are not an alternative to backward recovery; they are primarily used for redundancy and high availability, not for recovering from logical errors or data corruption.

Question 16

A proxy server ____.
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

Accepted Answer

A proxy server is designed to take apart an incoming message from the World Wide Web and allow only legitimate pieces of data to go to the company's mainframe or application server. It serves as an intermediary gateway between a user's local network and the Internet, providing an additional layer of security and filtering incoming requests according to configured rules. A proxy server can run on either software or hardware, but the main purpose remains the same.

Question 17

In a public key encryption algorithm ____.
A) the public key is used for encryption and the private key is used for decryption
B) the private key is used for encryption and the public key is used for decryption
C) a private key is used for both encryption and decryption
D) a public key is used for both encryption and decryption
E) a symmetric key is used for both encryption and decryption

Accepted Answer

In a public key encryption algorithm, the public key is used for encryption and the private key is used for decryption. This allows for secure communication without having to share a secret key between parties.

Question 18

Recovering from a data entry error discovered a few minutes after it happened can best be accomplished with ____.
A) forward recovery
B) backward recovery
C) mirrored databases
D) hot sites
E) versioning

Accepted Answer

Backward recovery involves restoring a system to a previous known state, which would be appropriate for recovering from a recent data entry error. Forward recovery involves continuing from where the error occurred, which would not be helpful in this situation. Mirrored databases and hot sites are backup solutions for disaster recovery, and versioning involves keeping multiple versions of data for historical purposes rather than recovering from an error.

Question 19

All of the following are methods of breaching data security, except ____.
A) unauthorized computer access
B) intercepting data communications
C) stealing disks or computers
D) spreading computer viruses
E) using public key encryption

Accepted Answer

Using public key encryption is not a method of breaching data security, but rather a method of enhancing data security. The other options listed are all methods that can be used to breach data security.

Question 20

All of the following are types of data security (prevention) measures, except ____.
A) data encryption
B) wiretaps
C) antivirus software
D) passwords
E) firewalls

Accepted Answer

Wiretaps are a form of surveillance and not a data security prevention measure.

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

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 breaches, except ____.

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

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

A private key encryption algorithm ____.

A biometric security system is associated with ____.

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

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

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

Which of the following is true regarding a transaction log?

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

In Secure Socket Layer (SSL) technology on the World Wide Web ____.

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

All of the following are rules of thumb regarding creating a password, except ____.

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

A proxy server ____.

In a public key encryption algorithm ____.

Recovering from a data entry error discovered a few minutes after it happened can best be accomplished with ____.

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

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