CS Security & Databases 3

Question 1

Which SQL command removes all rows from a table but keeps its structure and is typically not logged row-by-row?

Accepted Answer

TRUNCATE

Answer

TRUNCATE quickly removes all rows while preserving the table definition, unlike DROP which removes the table.

Question 2

An attacker intercepts and secretly relays communication between two parties who believe they are talking directly. What is this attack called?

Accepted Answer

Man-in-the-middle attack

Answer

A man-in-the-middle attack places the attacker between two communicating parties to eavesdrop or alter traffic.

Question 3

In the CIA triad, which property is violated when an attacker modifies records in a database without authorization?

Accepted Answer

Integrity

Answer

Unauthorized modification of data is a violation of integrity.

Question 4

Two transactions each hold a lock the other needs, and neither can proceed. What is this situation called?

Accepted Answer

Deadlock

Answer

A deadlock occurs when transactions wait on each other's locks in a cycle, so none can proceed.

Question 5

Which of the following best describes a database index?

Accepted Answer

A data structure that speeds up lookups at the cost of extra storage and slower writes

Answer

An index (often a B-tree) accelerates reads but must be updated on writes and consumes storage.

(CS) Computer Science Practice Test