Transaction preserves database rules.

Same row returns different values within transaction.

SQL command for retrieving data.

Removes duplicate query results.

Concurrent transactions appear appropriately separated.

SQL command for adding records.

Combines results of compatible queries.

Committed changes survive failures.

SQL command for modifying records.

Query nested inside another query.