Evaluate the following SQL statement:
SQL> select cust_id, cust_last_name "Last name"
FROM customers
WHERE country_id = 10
UNION
SELECT cust_id CUST_NO, cust_last_name
FROM customers
WHERE country_id = 30
Identify three ORDER BY clauses either one of which can complete the query.

• A.ORDER BY "Last name"
• B.ORDER BY 2, cust_id
• C.ORDER BY CUST_NO
• D.ORDER BY 2, 1
• E.ORDER BY "CUST_NO"

Comment: *

Name: *

Email: *

Verification: *

Examine the structure of the EMPLOYEES table. (Choose the best answer.)

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.

• A.SELECT last_name, hire_date, salaryFROM employeesWHERE manager_id
  (SELECT employee_id FROM employees WHERE employee_id = '100')UNIONSELECT last_name, hire_date, salaryFROM employeesWHERE hire_date > SYSDATE -
  1 80INTERSECTSELECT last_name, hire_date, salaryFROM employeesWHERE salary >
  1 0000;
• B.SELECT last_name, hire_date, salaryFROM employeesWHERE manager_id
  (SELECT employee_id FROM employees WHERE employee_id = 100)UNION
  ALL(SELECT last_name, hire_date, salaryFROM employeesWHERE hire_date >
  SYSDATE -180INTERSECTSELECT last_name, hire_date, salaryFROM
  employeesWHERE salary > 10000);
• C.SELECT last_name, hire_date, salaryFROM employeesWHERE salary > 10000UNION ALL SELECT last_name, hire_date, salaryFROM employeesWHERE manager_ID = (SELECT employee_id FROM employees WHERE employee_id
  100)INETRSECTSELECT last_name, hire_date, salaryFROM employees WHERE
  hire_date > SYSDATE- 180;
• D.(SELECT last_name, hire_date, salaryFROM employeesWHERE salary > 10000UNION ALLSELECT last_name, hire_date, salaryFROM employeesWHERE manager_ID = (SELECT employee_id FROM employees WHERE employee_id = 100))UNIONSELECT last_name, hire_date, salaryFROM employeesWHERE hire_date > SYSDATE -180;

Comment: *

Name: *

Email: *

Verification: *

Which two statements best describe the benefits of using the WITH clause? (Choose two.)

• A.It enables sessions to reuse the same query block in a SELECT statement, if it occurs more than once in a complex query.
• B.It can improve the performance of a large query by storing the result of a query block having the WITH clause in the session's temporary tablespace.
• C.It enables sessions to store a query block permanently in memory and use it to create complex queries.
• D.It enables sessions to store the results of a query permanently.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the details of the ORDER_ITEMS table.

Evaluate the following SQL statements:
Statement 1:
SELECT MAX(unit_price*quantity) "Maximum Order"
FROM order_items;
Statement 2:
SELECT MAX(unit_price*quantity) "Maximum Order"
FROM order_items
GROUP BY order_id;
Which statements are true regarding the output of these SQL statements? (Choose all that apply.)

• A.Both statements would ignore NULL values for the UNIT_PRICE and QUANTITY columns.
• B.Statement 1 would return only one row of output.
• C.Statement 2 would return multiple rows of output.
• D.Statement 1 would not return give the same output.
• E.Both the statements would give the same output.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true regarding a SAVEPOINT? (Choose two.)

• A.Only one SAVEPOINTmay be issued in a transaction
• B.A SAVEPOINTdoes not issue a COMMIT
• C.Rolling back to a SAVEPOINTcan undo a DELETEstatement
• D.Rolling back to a SAVEPOINT can undo a TRUNCATEstatement
• E.Rolling back to a SAVEPOINTcan undo a CREATE INDEX statement

Comment: *

Name: *

Email: *

Verification: *