试题详情
- 单项选择题 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;
关注下方微信公众号，在线模考后查看
热门试题
- Which two are charac
- Which three are DATE
- The EMPLOYEES table
- Examine the structu
- ClicktheExhibitbutto
- Examine the structu
- Which iSQL*Plus feat
- The database adminis
- ClicktheExhibitbutto
- Examinethestructureo
- Top N analysis requi
- Which two statements
- Which four are valid
- Which SQL statement
- Which three SELECT s
- EvaluatetheSQLstatem
- Which clause should
- What does the TRUNCA
- You need to produce
- Which two tasks can