You define a multiple-row subquery in the WHERE clause of an SQL query with a comparison operator "=". What happens when the main query is executed?
SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE > 5;
SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE > 5;
SELECT ENAME FROM EMP WHERE (SYSDATE-HIRE_DATE)/365 > 5;
SELECT ENAME FROM EMP WHERE (SYSDATE-HIRE_DATE)* 365 > 5;