The EMP table has these columns: ENAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results? （）<br>A:SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE >5;<br>B:SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE >5;<br>C:SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 >5;<br>D:SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 >5;

The EMP table has these columns: ENAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results? （）
A:SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE >5;
B:SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE >5;
C:SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 >5;
D:SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 >5;

出自：Oracle认证

提示：
同一【IP】的非会员用户每天可免费获取10次答案

本站试题总数:【10143087】个 (题库试题定时更新)