1Z0-071 Free Practice Test

View the Exhibit and examine the structure of the EMPLOYEES table.
You want to display all employees and their managers having 100 as the MANAGER_ID. You want the output in two columns: the first column would have the LAST_NAME of the managers and the second column would have LAST_NAME of the employees.
<>

1. A. SELECT m.last_name "Manager", e.last_name "Employee" FROM employees m JOIN employees eON m.employee_id = e.manager_id WHERE m.manager_id=100;
2. B. SELECT m.last_name "Manager", e.last_name "Employee"FROM employees m JOIN employees e ON m.employee_id = e.manager_id WHERE e.managerjd=100;
3. C. SELECT m.last_name "Manager", e.last_name "Employee" FROM employees m JOIN employees eON e.employee_id = m.manager_id WHERE m.manager_id=100;
4. D. SELECT m.last_name "Manager", e.last_name "Employee" FROM employees m JOIN employees eWHERE m.employee_id = e.manager_id AND e.managerjd=100;

Correct Answer: B

View the Exhibit and examine the structure of the EMPLOYEES and JOB_HISTORY tables. (Choose all that apply.)
<>>>------------------------------------- >

1. A. UNION
2. B. MINUS
3. C. INTERSECT
4. D. UNION ALL

Correct Answer: AD

Which two statements are true regarding working with dates? (Choose two.)

1. A. The RR date format automatically calculates the century from the SYSDATE function but allows the session user to enter the century.
2. B. The RR date format automatically calculates the century from the SYSDATE function and does not allow a session user to enter the century.
3. C. The default internal storage of dates is in character format.
4. D. The default internal storage of dates is in numeric format.

Correct Answer: AD

View the Exhibit and examine the details of the PRODUCT_INFORMATION table.
<>>>

1. A. It would not execute because the entire WHERE clause is not enclosed within parentheses.
2. B. It would execute but would return no rows.
3. C. It would not execute because the same column has been used twice with the AND logical operator.
4. D. It would execute and return the desired.

Correct Answer: B

View the exhibit and examine the data in the PROJ_TASK_DETAILS table. (Choose the best answer.)
<>>>>

1. A. SELECT p.task_id, p.based_on, d.task_in_chargeFROM proj_task_details p JOIN proj_task_details dON (p.task_id = d.task_id);
2. B. SELECT p.task_id, p.based_on, d.task_in_chargeFROM proj_task_details p FULL OUTER JOIN proj_task_details dON (p.based_on = d.task_id);
3. C. SELECT p.task_id, p.based_on, d.task_in_chargeFROM proj_task_details p JOIN proj_task_details dON (p.based_on = d.task_id);
4. D. SELECT p.task_id, p.based_on, d.task_in_chargeFROM proj_task_details p LEFT OUTER JOIN proj_task_details dON (p.based_on = d.task_id);

Correct Answer: D