Combines results of compatible queries.

Committed changes survive failures.

SQL command for modifying records.

Query nested inside another query.

Permanently applies transaction changes.

Data structure accelerating database lookups.

SQL command for removing records.

Subquery referencing the outer query.

Reverses uncommitted transaction changes.

Index determining physical or logical row ordering.