Database Security - Quiz 1

The process of periodically taking a copy of the database and log file on to offline storage media.

• Journaling

• Backup

• Auditing

• Recovery

A hidden program or an electronic component which makes the protection system ineffective. It is often activated by an event or a normal action.

• Malware

• Firewall

• Back door

• Trapdoor

The encoding of the data by a special algorithm that renders the data unreadable by any program without the decryption key.

• Encryption

• Decryption

• Cryptography

• Scrambling

A mechanism that determines whether a user is who he/she claims to be.

• Password

• Authorization

• Authentication

• Username

Any situation or event, whether intentional or accidental, that may adversely affect a system and consequently the organization.

• Confidentiality

• Security

• Threat

• Integrity

A category of disk drives that employ two or more drives in combination for fault tolerance and performance.

• Hard disks

• Solid-state drives

• Data storage

• Redundant Array of Independent Disks (RAID)

A computer that sits between a Web browser and a Web server. It intercepts all requests for web pages and saves them locally for some time. It provides improvement in performance and filters requests.

• Proxy server

• Cloud server

• Database server

• Application server

The dynamic result of one or more relational operations operating on the base relations to produce another relation.

• Tuple

• View

• Relation

• Snapshot

The technique of segmenting logically sequential data, such as a file, so that consecutive segments are stored on different physical storage device.

• Data striping

• Data mirroring

• Data segmenting

• Data dividing

The process of keeping and maintaining a log file (or journal) of all changes made to the database to enable recovery to be undertaken effectively in the event of a failure.

• Backup

• Recovery

• Auditing

• Journaling