Exec executes a query without returning any rows.

Prepare creates a prepared statement for later queries or executions.

Query executes a query that returns rows, typically a SELECT.

QueryRow executes a query that is expected to return at most one row.