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.
Which SQL statement would you execute?

• A.SELECT m.last_name "Manager", e.last_name "Employee"
  FROM employees m JOIN employees e
  WHERE m.employee_id = e.manager_id AND e.manager_id=100;
• B.SELECT m.last_name "Manager", e.last_name "Employee"
  FROM employees m JOIN employees e
  ON m.employee_id = e.manager_id
  WHERE m.manager_id=100;
• C.SELECT m.last_name "Manager", e.last_name "Employee"
  FROM employees m JOIN employees e
  ON m.employee_id = e.manager_id
  WHERE e.manager_id=100;
• D.SELECT m.last_name "Manager", e.last_name "Employee"
  FROM employees m JOIN employees e
  ON e.employee_id = m.manager_id
  WHERE m.manager_id=100;

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the PROMOTIONS table.
Evaluate the following SQL statement:
Which statement is true regarding the outcome of the above query?

• A.It shows COST_REMARK for all the promos in the table.
• B.It produces an error because the subquery gives an error.
• C.It shows COST_REMARK for all the promos in the promo category 'TV'.
• D.It produces an error because subqueries cannot be used with the CASE expression.

Comment: *

Name: *

Email: *

Verification: *

The SALES table has columns PROD_ID and QUANTITY_SOLD of data type NUMBER. Which two queries execute successfully?

• A.SELECT prod_id FROM sales WHERE quantity_sold> 55000 AND COUNT(*)> 10 GROUP BY prod_id HAVING COUNT(*)> 10;
• B.SELECT COUNT(prod_id) FROM sales GROUP BY prod_id WHERE quantity_sold> 55000;
• C.SELECT COUNT(prod_id) FROM sales WHERE quantity_sold>55000 GROUP BY prod_id;
• D.SELECT prod_id FROM sales WHERE quantity_sold> 55000 GROUP BY prod_id HAVING COUNT(*)> 10;
• E.SELECT prod_id FROM sales WHERE quantity_sold> 55000 AND COUNT(*)> 10 GROUP BY COUNT(*)> 10;

Comment: *

Name: *

Email: *

Verification: *

Examine these statements and the result:
CREATE SEQUENCE customer_seq CACHE 10;
SELECT customer_seq. NEXTVAL FROM DUAL; NEXTVAL
1
Now examine this command:
ALTER SEQUENCE customer_soq <MISaiNG CLAUSE>;
What must replace missing clause for customer_seq. nfxtvai. to return 11?

• A.INCREMENT BY 10
• B.MINVALUE 11
• C.NOCACHE
• D.START WITH 11
• E.cycle 11

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the ORDER_ITEMS table. (Choose the best answer.)

You must select the ORDER_ID of the order that has the highest total value among all the orders in the ORDER_ITEMS table.
Which query would produce the desired result?

• A.SELECT order_idFROM order_itemsWHERE (unit_price*quantity) = (SELECT MAX(unit_price*quantity)FROM order_itemsGROUP BY order_id)
• B.SELECT order_idFROM order_itemsWHERE(unit_price*quantity)
  MAX(unit_price*quantity)GROUP BY order_id);
• C.SELECT order_idFROM order_itemsGROUP BY order_idHAVING
  SUM(unit_price*quantity) = (SELECT MAX (SUM(unit_price*quantity))FROM order_items GROUP BY order_id);
• D.SELECT order_idFROM order_itemsWHERE(unit_price*quantity) = (SELECT MAX (SUM(unit_price*quantity)FROM order_items) GROUP BY order_id);

Comment: *

Name: *

Email: *

Verification: *