单项选择题
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? （）
单项选择题 Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: Which UPDATE statement is valid?（）
