Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us [email protected]
Menu

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
Oracle Discussions

Exam 1z0-071 topic 1 question 150 discussion

Actual exam question from Oracle's 1z0-071
Question #: 150
Topic #: 1
[All 1z0-071 Questions]

Examine the description of EMPLOYEES table:



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? (Choose two.)

  • A. SELECT employee_name FROM employees WHERE (SYSDATE - hire_date) / 12 > 5;
  • B. SELECT employee_name FROM employees WHERE (SYSTIMSSTAMF - hire_date) / 12 > INTERVAL '5' YEAR;
  • C. SELECT employee_name FROM employees WHERE (CURRENT_DATE - hire_date) / 12 > 5
  • D. SELECT employee_name FROM employees WHERE (CURRENT_DATE - hire_date) / 365 >
  • E. SELECT employee_name FROM employees WHERE (SYSDATE - hire_date) / 365 > 5;
  • F. SELECT employee_name FROM employees WHERE (SYSTIMESTAMP - hire_date) / 365 > INTERVAL '1825' DAY;
Show Suggested Answer Hide Answer
Suggested Answer: BF 🗳️
by kesammy9 at Feb. 27, 2023, 5:23 p.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
ArslanAltaf
2 weeks, 1 day ago
Eliminate ABC because of fact /12 .. in order to get year it should be /365.
upvoted 1 times
...
lucemqy
5 months, 3 weeks ago
Selected Answer: DE
DE should be the correct answer
upvoted 1 times
...
zouve
10 months, 2 weeks ago
CE tested SELECT FIRST_NAME, hire_date FROM hr.employees WHERE (SYSDATE - hire_date) / 12 > 5; SELECT FIRST_NAME, hire_date FROM hr.employees WHERE (SYSTIMESTAMP - hire_date) / 12 > INTERVAL '5' YEAR; SELECT FIRST_NAME, hire_date FROM hr.employees WHERE (CURRENT_DATE - hire_date) / 12 > 5; SELECT FIRST_NAME, hire_date FROM hr.employees WHERE (CURRENT_DATE - hire_date) / 365 > SELECT FIRST_NAME, hire_date FROM hr.employees WHERE (SYSDATE - hire_date) / 365 > 5; SELECT FIRST_NAME, hire_date FROM hr.employees WHERE (SYSTIMESTAMP - hire_date) / 365 > INTERVAL '1825' DAY;
upvoted 1 times
zouve
10 months, 2 weeks ago
D. SELECT employee_name FROM employees WHERE (CURRENT_DATE - hire_date) / 365 > 5; E. SELECT employee_name FROM employees WHERE (SYSDATE - hire_date) / 365 > 5; DE now that i am running again the others if you run them are calculate garbage also D is missing a 5;
upvoted 2 times
...
...
Darnun
1 year, 1 month ago
Selected Answer: DE
DE is correct (even though D seems to be with typo). F is not correct as default precision of DAY is 2 - should be INTERVAL '1845' DAY(4)
upvoted 4 times
...
Thorc
1 year, 1 month ago
Selected Answer: EF
I think EF. D is with typo?
upvoted 1 times
...
Thorc
1 year, 1 month ago
I think EF. D is with typo?
upvoted 2 times
...
kesammy9
1 year, 2 months ago
Selected Answer: DE
DE is correct
upvoted 4 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel