Accessing data - Implement transactions

Which items would benefit from being made transactional?

Quick-running queries that involve only one table
Long-running queries that span multiple tables
Queries that make use of the file system of a non-Windows operating system.
Queries that make use of the file system on a Windows operating system.