Oracle
1Z0-071 · Question #145
1Z0-071 Question #145: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #145. The question stem and answer options stay visible for context.
Question
Examine the structure of the EMPLOYEES table. You must display the details of employees who have manager with MANAGER_ID 100, who were hired in the past 6 months and who have salaries greater than 10000. Which query would retrieve the required result?
Options
- ASELECT last_name, hire_date, salary
- BSELECT last_name, hire_date, salary
- CSELECT last_name, hire_date, salary
- D(SELECT last_name, hire_date, salary
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.