QUESTION: 25

Examine the structure of the EMPLOYEES table.

There is a parent/child relationship between EMPLOYEE_ID and MANAGER_ID.
You want to display the last names and manager IDs of employees who work for the same manager as the employee whose EMPLOYEE_ID is 123.

Which query provides the correct output?

SELECT e.last_name, m.manager_id
FROM employees e RIGHT OUTER JOIN employees m
on (e.manager_id = m.employee_id)
AND e.employee_id = 123;
SELECT e.last_name, m.manager_id
FROM employees e LEFT OUTER JOIN employees m
on (e.employee_id = m.manager_id)
WHERE e.employee_id = 123;
SELECT e.last_name, e.manager_id
FROM employees e RIGHT OUTER JOIN employees m
on (e.employee_id = m.employee_id)
WHERE e.employee_id = 123;
SELECT m.last_name, e.manager_id
FROM employees e LEFT OUTER JOIN employees m
on (e.manager_id = m.manager_id)
WHERE e.employee_id = 123;

Answer(s): D

Show Answer Next Question

QUESTION: 26

Which normal form is a table in if it has no multi-valued attributes and no partial dependencies?

second normal form
first normal form
third normal form
fourth normal form

Answer(s): A

Reference:

https://blog.udemy.com/database-normal-forms/

Show Answer Next Question

QUESTION: 27

Sales data of a company is stored in two tables, SALES1 and SALES2, with some data being duplicated across the tables. You want to display the results from the SALES1 table, which are not present in the SALES2 table.

Which set operator generates the required output?

INTERSECT
UNION
PLUS
MINUS
SUBTRACT

Answer(s): D

Reference:

https://docs.oracle.com/cd/B19306_01/server.102/b14200/queries004.htm

Show Answer Next Question

QUESTION: 28

Evaluate the following ALTER TABLE statement:

ALTER TABLE orders
SET UNUSED (order_date);

Which statement is true?

After executing the ALTER TABLE command, you can add a new column called ORDER_DATE to the
ORDERS table.
The ORDER_DATE column must be empty for the ALTER TABLE command to execute successfully.
ROLLBACK can be used to get back the ORDER_DATE column in the ORDERS table.
The DESCRIBE command would still display the ORDER_DATE column.

Answer(s): A

Show Answer Next Question

Free Oracle 1Z0-071 Exam Braindumps (page: 8)

QUESTION: 25

QUESTION: 26

Reference:

QUESTION: 27

Reference:

QUESTION: 28

1Z0-071 Exam Discussions & Posts