Multiple choice technology databases

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?

  1. SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE > 5;

  2. SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE > 5;

  3. SELECT ENAME FROM EMP WHERE (SYSDATE-HIRE_DATE)/365 > 5;

  4. SELECT ENAME FROM EMP WHERE (SYSDATE-HIRE_DATE)* 365 > 5;
Reveal answer Fill a bubble to check yourself
C Correct answer

Keep practicing — related questions