单项选择题
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;
相关考题
-
单项选择题
Which constraint can be defines only at the column level?（）
A.UNIQUE
B.NOT NULL
C.CHECK
D.PRIMARY KEY
E.FOREIGN KEY -
单项选择题
In which scenario would TOP N analysis be the best solution?（）
A. You want to identify the most senior employee in the company.
B. You want to find the manager supervising the largest number of employees.
C. You want to identify the person who makes the highest salary for all employees.
D. You want to rank the top three sales representatives who have sold the maximum number of products. -
多项选择题
Which three are true regarding the use of outer joins? （）
A. You cannot use IN operator in a condition that involves an outerjoin.
B. You use (+) on both sides of the WHERE condition to perform an outerjoin.
C. You use (*) on both sides of the WHERE condition to perform an outerjoin.
D. You use an outerjoin to see only the rows that do not meet the join condition.
E. In the WHERE condition, you use (+) following the name of the column in the table without matching rows, to perform an outerjoin.
F. You cannot link a condition that is involved in an outerjoin to another condition by using the OR operator.
