View the exhibit and examine the structure of the EMPLOYEEStable.

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_NAMEof the managers and the second column would have LAST_NAMEof the employees.
Which SQL statement would you execute?
SELECT m.last_name "Manager", e.last_name "Employee"

Which two commands execute successfully?
* MANAGER is an existing role with no privileges or roles.
* EMP is an existing role containing the CREATE TABLE privilege.
* EMPLOYEES is an existing table in the HR schema.

Examine this query:

Which two methods should you use to prevent prompting for a hire date value when this query is executed?
(Choose two.)

View the Exhibit and examine the data in the PRODUCT_INFORMATION table.

Which two tasks would require subqueries? (Choose two.)

View the Exhibit and examine the structure of the ORDER_ITEMStable.

Examine the following SQL statement:
SELECT order_id, product_id, unit_price
FROM order_items
WHERE unit_price
(SELECT MAX(unit_price)
FROM order_items
GROUP BY order_id);
You want to display the PRODUCT_ID of the product that has the highest UNIT_PRICE per ORDER_ID.What correction should be made in the above SQL statement to achieve this?