Oracle Database 12c SQL 1z0-071 Question # 89 Topic 9 Discussion

Oracle Database 12c SQL 1z0-071 Question # 89 Topic 9 Discussion

1z0-071 Exam Topic 9 Question 89 Discussion:
Question #: 89
Topic #: 9

Examine the description of the EMPLOYEES table:

1z0-071 Question 89

The session time zone is the same as the database server

Which two statements will list only the employees who have been working with the company for more than five years?


A.

SELECT employee_ name FROM employees WHERE (SYSDATE – hire_ data) / 365>5


B.

SELECT employee_ name FROM employees WHERE (SYSTIMESTAMP – hire_ data) / 365>


C.

SELECT employee_ name FROM employees WHERE (CUARENT_ DATE – hire_ data / 365>5


D.

SELECT employee_ name FROM employees WHERE (SYSNAYW – hire_ data / 12> 3


E.

SELECT employee_ name FROM employees WHERE (SYSNAYW – hire_ data / 12> 3


F.

SELECT employee_ name FROM employees WHERE (CUNACV_ DATE – hire_ data / 12> 3


Get Premium 1z0-071 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.