mediumSQLcorrelated subqueriesSingle-choice MCQ

A correlated subquery is used in the SELECT list to fetch a related value. What happens if, for some outer row, the subquery returns more than one row?

SELECT e.name, (SELECT d.budget FROM dept d WHERE d.id = e.dept_id) AS budget FROM emp e;