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?
Evaluate the following two queries:
Which statement is true regarding the above two queries?
Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)
View the Exhibit and examine the structure of the ORDER_ITEMS table.
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?
Evaluate this query:
SQL> SELECT TRUNC(ROUND(156.00,-1),-1)
FROM DUAL;
What will be the result?
