单项选择题
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;
单项选择题 What is necessary for your query on an existing view to execute successfully? （）
多项选择题 Which two statements accurately describe a role? （）
单项选择题 In which case would you use a FULL OUTER JOIN? （）
