like operator subquery

Which statement is true regarding subqueries?