Accessing data - Implement transactions

Which items would benefit from being made transactional?

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