A.& B.ACCEPT C.PROMPT D.&&
A.It allows a grantee DBA privileges. B.It is required syntax for object privileges. C.It allows privileges on specified columns of tables. D.It is used to grant an object privilege on a foreign key column. E.It allows the grantee to grant object privileges to other users and roles.
The EMP table has these columns: 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;