Which two are true about self joins?

• A.They are always condition.
• B.They can use INNER join and LEFT .join.
• C.They require table aliases,
• D.They have no Join condition.
• E.They require the exists operator In the join condition.
• F.They require the not exists operator In the join condition.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true regarding the EXISTS operator used in the correlated subqueries? (Choose two.)

• A.The outer query stops evaluating the result set of the inner query when the first value is found.
• B.It is used to test whether the values retrieved by the inner query exist in the result of the outer query.
• C.It is used to test whether the values retrieved by the outer query exist in the result set of the inner query.
• D.The outer query continues evaluating the result set of the inner query until all the values in the result set are processed.

Comment: *

Name: *

Email: *

Verification: *

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?

• A.SELECT m.last_name "Manager", e.last_name "Employee"
  FROM employees m JOIN employees e
  WHERE m.employee_id = e.manager_id and 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 e.manager_id = 100;
• C.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;
• D.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;

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the description of the EMPLOYEES table.

Evaluate the following SQL statement:
SELECT first_name, employee_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) "Review" FROM employees; The query was written to retrieve the FIRST_NAME, EMPLOYEE_ID, and review date for employees. The review date is the firsts Monday after the completion of six months of the hiring. The NLS_TERRITORY parameter is set to AMERICA in the session.
Which statement is true regarding this query?

• A.The query would execute but the output would give review dates that are Sundays.
• B.The query would execute to give the desired output.
• C.The query would not execute because the NEXT_DAY function accepts a string as argument.
• D.The query would not execute because date functions cannot be nested.

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the data in ORDERS_MASTERand MONTHLY_ORDERStables.
ORDERS_MASTER
ORDER_TOTAL
ORDER_ID
1 1000
2 2000
3 3000
4
MONTHLY_ORDERS
ORDER_TOTAL
ORDER_ID
2 2500
3
Evaluate the following MERGEstatement:
MERGE_INTO orders_master o
USING monthly_orders m
ON (o.order_id = m.order_id)
WHEN MATCHED THEN
UPDATE SET o.order_total = m.order_total
DELETE WHERE (m.order_total IS NULL)
WHEN NOT MATCHED THEN
INSERT VALUES (m.order_id, m.order_total)
What would be the outcome of the above statement?

• A.The ORDERS_MASTERtable would contain the ORDER_IDs1, 2, 3 and 4.
• B.The ORDERS_MASTERtable would contain the ORDER_IDs1, 2 and 4.
• C.The ORDERS_MASTERtable would contain the ORDER_IDs1, 2 and 3.
• D.The ORDERS_MASTERtable would contain the ORDER_IDs1 and 2.

Comment: *

Name: *

Email: *

Verification: *